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.
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.