Skip to main content
Feedback

Microsoft Azure SQL Database connector

The Microsoft Azure SQL Database connector makes it easy to work with Microsoft Azure SQL Database.

This connector pre-configures the Database connector with the necessary settings to simplify building relational queries against structured data stored in the Azure SQL Database. As a result, run information on process reporting, run history on the Start step, the process log, as well as licensing information, shows the connection as Database rather than Microsoft Azure SQL Database.

Connector configuration

To configure a connector to communicate with Azure, set up two components:

  • Azure SQL Database connection

  • Azure SQL Database operation

This approach creates reusable components that contain connection settings and operation settings (such as Object, Action, and data definitions). After building your connection and operation, set up your Azure SQL Database connector within a process. When you define the process correctly, Integration can map to and from virtually any system using this connector to retrieve data from or send data to the Microsoft Azure SQL Database.

Prerequisites

The Microsoft Azure SQL Database connector requires the following:

  • Microsoft Azure Database connection information, including server host, IP address and port, user name, and password. The user name and password configured on the database must have sufficient permissions to access the objects required by the integration. For more information, refer to the documentation for your database.

  • If you use local basic runtimes, put the Microsoft SQL Server Driver appropriate for your runtime environment in the <installation\_directory\>/userlib/database directory. You can do that in one of two ways:

note

For more information about SQL Server drivers, compatibility, and available downloads, see the Microsoft JDBC Driver for SQL Server support matrix and Download Microsoft JDBC Driver for SQL Server pages from the Microsoft help.

  • Upload the JAR file into your account library (Setup > Account Libraries), add that file to a Custom Library component, and deploy the component to the appropriate basic runtime, runtime cluster, runtime cloud, or environment.
    For JAR files that support a connector, you create a Custom Library component with a type of Connector and select a connector type — in this case, Database. When you deploy the component, it deploys the referenced JAR files to the /<installation_directory>/userlib/database directory. If the userlib/database directory does not exist, creates it.

  • Load the JAR file manually into the appropriate directory of a local basic runtime, runtime cluster, or private runtime cloud. After you load the JAR files, a restart is required. If the userlib/database directory does not exist, you must create it.

  • If you use a runtime cloud to connect to the Azure SQL Database, it installs the SQL Server JDBC driver sqljdbc4.jar for you.

The Microsoft Azure SQL Database connector uses the same driver as SQL Server. It does not include drivers for local basic runtimes. You can download the drivers from the Microsoft, Download Microsoft JDBC Driver for SQL Server page.

Tracked properties

The Azure SQL Database connector has no tracked properties.

On this Page