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.