User Tools

Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
en:process_steps:sql_connection [2022/02/25 17:23]
levi created
— (current)
Line 1: Line 1:
-====== SQL Connection ====== 
  
-The SQL Connection step is give us the possibility to connect to a SQL server which we can use with the Ws Import SQL step to get data from the server. The step has the following parameters: 
-  * **Connection Djeeni name: ** This name identifies the connection in the process. 
-  * **Server type: ** The server type we wish to connect. Possible connections: 
-    * MS SQL Server 2019 
-    * Oracle 21c 
-    * MySQL 8.0 
-  * **Server name: ** The name of the server we wish to connect. 
-  * **Database name: ** The name of the database we wish to connect. 
-  * **Username** (Optional): The username which we want to use to connect to the server/database used above. 
-  * **Password** (Optional): The password which we want to use to connect to the server/database used above. 
-  * **Options** (Optional): No additional options available at the moment. 
- 
-Note: If we won’t fill the username and password parameters Djeeni will use Windows Authentication if possible.