Skip to Content

Changes for page Database Connectivity

Last modified by Erik Bakker on 2024/06/21 09:38
From version 38.1
edited by Erik Bakker
on 2023/01/31 12:10
Change comment: There is no comment for this version
To version 43.1
edited by Erik Bakker
on 2024/06/21 09:37
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -SFTP Inbound Connectivity
1 +Database Connectivity
Content
... ... @@ -1,18 +1,19 @@
1 1  {{container}}
2 2  {{container layoutStyle="columns"}}
3 3  (((== About ==
4 -With the help of this store item, you can easily retrieve files from an SFTP location with the help of eMagiz
4 +This store item allows you to connect to various databases and provides examples of SQL queries that can be executed on the database.
5 5  
6 6  == Documentation ==
7 7  
8 8  ==== 1. How to use====
9 9  
10 -With this store component, you can easily set up a connection to an SFTP to retrieve data from an SFTP.
10 +This store item allows you to connect to various databases and provides examples of SQL queries that can be executed on the database.
11 11  
12 12  ==== 2. Keynotes & restrictions====
13 13  
14 -* Note that you need valid authentication to properly connect eMagiz to the SFTP.
15 -* Note that the eMagiz user has to have sufficient rights on the SFTP to read and delete files.
14 +* Note that you need valid authentication to connect eMagiz to the database.
15 +* Note that the eMagiz user has to have sufficient rights on the database to read and delete files.
16 +* This store item will only work on the [[current runtime>>doc:Main.eMagiz Academy.Fundamentals.fundamental-runtime-generation3||target="blank"]] architecture
16 16  
17 17  ==== 3. License Information====
18 18  
... ... @@ -20,16 +20,19 @@
20 20  
21 21  ==== 4. Relevant eMagiz Academy Microlearnings====
22 22  
23 -* [[SFTP Connectivity>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.File based connectivity.intermediate-file-based-connectivity-sftp-connectivity||target="blank"]]
24 +* [[Database Connectivity>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Database Connectivity||target="blank"]]
25 +* [[Stored Procedures>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Database Connectivity||target="blank"]]
24 24  
25 25  //Would you please consult the privacy policy of eMagiz at the following [[link>>https://www.emagiz.com/privacy-policy/||target="blank"]])))
26 26  
27 27  ((((% border="2" cellpadding="10" cellspacing="10" style="width:292px" %)
28 28  |=(% style="width: 45px;" %)#|=(% style="width: 241px;" %)Option
29 -|(% style="width:45px" %) a|(% style="width:241px" %) Caching - Username/Password
30 -|(% style="width:45px" %) b|(% style="width:241px" %) Caching - Private Key
31 -|(% style="width:45px" %) c|(% style="width:241px" %) Non-caching - Username/Password
32 -|(% style="width:45px" %) d|(% style="width:241px" %) Non-caching - Private Key
31 +|(% style="width:45px" %) a|(% style="width:241px" %) eMagiz SFTP - Caching
32 +|(% style="width:45px" %) b|(% style="width:241px" %) eMagiz SFTP - Default
33 +|(% style="width:45px" %) c|(% style="width:241px" %) Caching - Default Authentication
34 +|(% style="width:45px" %) d|(% style="width:241px" %) Caching - Private Key Authentication
35 +|(% style="width:45px" %) e|(% style="width:241px" %) Default - Default Authentication
36 +|(% style="width:45px" %) f|(% style="width:241px" %) Default - Private Key Authentication
33 33  )))
34 34  {{/container}}
35 35  {{/container}}