Connection Settings

Enter the credentials needed to connect to and authenticate with the source.

  1. Go to Connection Settings.

  2. Enter the SQL Account Login Name used to connect to the Microsoft Azure SQL Database.

  3. Enter the Password for the associated with the Microsoft Azure SQL Database login name.

  4. Enter the Database URL to connect to the Microsoft Azure SQL Database. The format is jdbc:sqlserver://<server_name>:<port_number>

    Where:

    • jdbc:sqlserver:// - Known as the sub-protocol and is constant. This is required.

    • server_name - The address of the server to connect to.

    • port_number - The port to conect to the server. The default is 1433.

  5. Enter the fully qualified name of the Driver Class supported by JDBC. For example, com.microsoft.sqlserver.jdbc.SQLServerDriver

  6. Select Save.