Dell Boomi AtomSphere

Microsoft Azure SQL Data Warehouse connector

The Microsoft Azure SQL Data Warehouse connector makes it easy to work with Microsoft Azure SQL Warehouse. This connector pre-configures the Database connector with needed settings to simplify building relational queries against structured data stored in a Microsoft Azure SQL Data Warehouse. However, as a result, execution information on process reporting, execution history on the Start Shape, the process log, as well as licensing information shows the connection as Database rather than Microsoft Azure SQL Data Warehouse.

Connector configuration

To configure a connector to communicate with the Azure SQL Data Warehouse, set up two components:

  • Microsoft Azure SQL Data Warehouse connection

  • Microsoft Azure SQL Data Warehouse operation

This approach creates reusable components which contain connection settings (such as URL, User, Password, Account) and operation settings (such as Object, Action, data definitions). After building your connection and operation, set up your connector within a process. When the process is defined properly, AtomSphere can map to and from virtually any system using this connector to retrieve data from or send data to the Azure SQL Data Warehouse.

Prerequisites

The Microsoft Azure SQL Data Warehouse connector requires the following:
  • Microsoft Azure Data Warehouse 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 Atoms, put the Microsoft sqljdbc4.jar driver in the <installation_directory>/userlib/database directory. You can do that in one of two ways:
    • Upload the JAR file into your AtomSphere account library (Setup > Account Libraries), add that file to a Custom Library component, and deploy the component to the appropriate Atom, Molecule, Atom Cloud (including the Dell Boomi Atom 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, the JAR files that it references are deployed to the /<installation_directory>/userlib/database directory. If the userlib/database directory does not exist, AtomSphere creates it.

    • Load the JAR file manually into the appropriate directory of a local Atom, Molecule, or private Atom 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 Dell Boomi Atom Cloud to connect to the Azure SQL Data Warehouse, the sqljdbc4.jar driver is installed for you.

Tracked properties

The Microsoft Azure SQL Data Warehouse connector has no tracked properties.

Related Concepts
Related References