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.

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.