Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
en:process_steps:sql_connection [2022/03/09 10:37] levi |
— (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/ | ||
| - | * **Password** (Optional): The password which we want to use to connect to the server/ | ||
| - | * **Options** (Optional): No additional options available at the moment. | ||
| - | |||
| - | Notes: | ||
| - | * If we won’t fill the username and password parameters Djeeni will use Windows Authentication if possible. | ||
| - | * If fill the username field, but not the password, in this case during execution Djeeni will ask for a password trough a pop up window. | ||