Skip to Content

Changes for page Database Connectivity

Last modified by Erik Bakker on 2024/06/21 09:38
From version 25.1
edited by Erik Bakker
on 2022/05/02 08:25
Change comment: There is no comment for this version
To version 42.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,49 +1,39 @@
1 1  {{container}}
2 2  {{container layoutStyle="columns"}}
3 -(((= About =
4 -With the help of this store item, you can easily retrieve files from an SFTP location with the help of eMagiz
3 +(((== About ==
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 -= Documentation =
6 +== Documentation ==
7 7  
8 -
9 -=== 1. How to use===
10 -=== 1. How to use===
11 11  ==== 1. How to use====
12 12  
10 +This store item allows you to connect to various databases and provides examples of SQL queries that can be executed on the database.
13 13  
12 +==== 2. Keynotes & restrictions====
14 14  
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
15 15  
16 -With this store component, you can easily set up a connection to an SFTP to retrieve data from an SFTP.
18 +==== 3. License Information====
17 17  
18 -
19 -**2. Keynotes & restrictions**
20 -
21 -a. Note that you need valid authentication to properly connect eMagiz to the SFTP.
22 -b. Note that the eMagiz user has to have sufficient rights on the SFTP to read and delete files.
23 -
24 -**3. License Information**
25 25  Part of the standard license agreement as agreed upon when using the store for the first time.
26 26  
22 +==== 4. Relevant eMagiz Academy Microlearnings====
27 27  
28 -**4. Relevant eMagiz Academy Microlearnings**
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.WebHome||target="blank"]]
29 29  
30 -[[https:~~/~~/emagiz.github.io/docs/microlearning/intermediate-file-based-connectivity-sftp-connectivity>>url:https://emagiz.github.io/docs/microlearning/intermediate-file-based-connectivity-sftp-connectivity]]
27 +//Would you please consult the privacy policy of eMagiz at the following [[link>>https://www.emagiz.com/privacy-policy/||target="blank"]])))
31 31  
32 -
33 -Would you please consult the privacy policy of eMagiz at the following link: [[https:~~/~~/www.emagiz.com/privacy-policy/?>>url:https://www.emagiz.com/privacy-policy/?]])))
34 -
35 -
36 -
37 37  ((((% border="2" cellpadding="10" cellspacing="10" style="width:292px" %)
38 38  |=(% style="width: 45px;" %)#|=(% style="width: 241px;" %)Option
39 -|(% style="width:45px" %) a|(% style="width:241px" %) OAuth 2.0 - Authorization Code
40 -|(% style="width:45px" %) b|(% style="width:241px" %) REST - Basic Auth
41 -|(% style="width:45px" %) c|(% style="width:241px" %) REST - Client Certificate
42 -|(% style="width:45px" %) d|(% style="width:241px" %) REST - Header Mapper
43 -|(% style="width:45px" %) e|(% style="width:241px" %) OAuth 2.0 - Client Credentials
44 -|(% style="width:45px" %) f|(% style="width:241px" %) REST - SSL
45 -|(% style="width:45px" %) g|(% style="width:241px" %) Dynamic Token
46 -|(% style="width:45px" %) h|(% style="width:241px" %) No Authentication
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
47 47  )))
48 48  {{/container}}
49 49  {{/container}}
XWiki.StyleSheetExtension[0]
Caching policy
... ... @@ -1,1 +1,0 @@
1 -long
Code
... ... @@ -1,6 +1,0 @@
1 -div.container-columns div.first-column {
2 - width:65%;
3 -}
4 -div.container-columns div.last-column {
5 - width:35%;
6 -}
Content Type
... ... @@ -1,1 +1,0 @@
1 -CSS
Name
... ... @@ -1,1 +1,0 @@
1 -Container Sizing
Use this extension
... ... @@ -1,1 +1,0 @@
1 -currentPage