Configure Connection to Data Source

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Enhanced Connector Enhanced connectors add extended capabilities and require a separate entitlement in addition to your Alation platform license.

After you install the connector and create the data source, configure the connection to your SSIS Catalog database.

Follow these steps to configure the connection:

Configure the SSIS Connection

  1. On the Settings page of your Microsoft SSIS OCF Connector data source, go to the General Settings tab.

  2. In the Connection String field, enter a JDBC connection string to your SQL Server instance:

    • Format: jdbc:sqlserver://<hostname_or_ip>:<port>;databaseName=<database_name>

    • hostname_or_ip: The address of the SQL Server hosting SSISDB.

    • port: The port number for the SQL Server instance (typically 1433).

    • databaseName (optional): The name of your SSIS Catalog database. If you don’t specify this, the connector defaults to SSISDB.

  3. Click Save.

Configure Authentication

Select the authentication method that matches your environment: NTLM or Kerberos with password.

Connect Using NTLM

  1. Select the NTLM tab.

  2. Enter the Username and Password for the service account.

  3. Provide the Windows Domain Name.

Connect Using Kerberos

  1. Select the Kerberos with password tab.

  2. Enter the Username and Password for the service account.

  3. Click Upload krb5.conf File and select your Kerberos configuration file.

Configure SSL/TLS (Optional)

If your SQL Server instance requires an encrypted connection:

  1. Toggle Enable SSL/TLS to the on position.

  2. If required, click Upload SSL Certificate and provide your server’s certificate file (for example, a .crt or .cer file).

  3. Use the Disable Certificate Verification option only in trusted environments, for example, when using a self-signed certificate.

  4. Click Save.

Test the Connection

Ensure that the settings above are saved, then click Test to validate that the connector can connect to the SQL Server instance using the authentication method and credentials provided.