Skip to main content
Feedback

SQL server connection

Prerequisites

You must create a new user for Data Integration in your database by copying the following commands:

CREATE LOGIN [ <Data_Integration Username>] WITH PASSWORD='< myPassword >'

Note: Set up your password following the review of the Microsoft Password Policy.

Use the database from which you want to pull data. Replace <database> with the name of your current database:

USE [< database >]

Enable the new user you created above to access the database:

CREATE USER [< Data_Integration Username >] FOR LOGIN `<database>`

Grant the table or schema you want to extract data from to the new user you just created. Change the <database>, <schema>, and <table> to your existing databse, schema, and table names:

GRANT SELECT to [< Data_Integration Username >]

Use the following syntax to grant a SELECT operation to a specific schema:

GRANT SELECT on SCHEMA :: [< schema >] TO [< Data_Integration Username >]

Grant Data Integration view permissions to the metadata of the tables to get the correct mapping of the tables in the schema or database:

GRANT VIEW ANY DEFINITION to [< Data_Integration Username >]

If you want to connect using Azure Active Directory, make sure you configure and manage Azure AD authentication with Azure SQL.

Establishing a connection

You can connect to SQL Server using one of three methods:

  • SQL Server Authentication
  • Azure Active Directory
  • SSH Tunnel

SQL server authentication

Whitelist our IPs.

Procedure

  1. Navigate to the Data Integration Account.

  2. Click Connections and select + New Connection.

  3. Choose SQL server.

  4. Choose your Connection Name.

  5. Enter Host.

  6. Fill in the Port Number.

  7. Enter your Database.

  8. Select SQL Server Authentication method.

  9. Enter your Username and Password

  10. Click Test Connection to verify if your connection is up to the task. If the connection succeeded, you can use this connection in Data Integration.

Azure active directory

Whitelist our IPs.

Procedure

  1. Navigate to the Data Integration Account.
  2. Click Connections and select + New Connection.
  3. Choose SQL server.
  4. Choose your Connection Name.
  5. Enter Host.
  6. Fill in the Port Number.
  7. Enter your Database.
  8. Select Azure Active Directory authentication method.
  9. Enter your Username and Password
  10. Use the Test Connection function to see if your connection is up to the task. If the connection succeeded, you can now use this connection in Data Integration.

SSH tunnel

To connect via SSH tunnel, follow our step-by-step tutorial.

On this Page