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 the necessary settings to simplify building relational queries against structured data stored in a Microsoft Azure SQL Data Warehouse. 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.
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.
PrerequisitesThe 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 SQL Server Driver (Microsoft JDBC Driver 4.1 for SQL Server for the Java 7 JDK, or Microsoft JDBC Driver 4.2 for SQL Server for the Java 8 JDK) 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 (), 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 SQL Server JDBC driver (sqljdbc4.jar) is installed for you.
The Microsoft Azure SQL Data Warehouse connector uses the same driver as SQL Server. Drivers for local Atoms are not included. You can download the drivers from the Microsoft, Download Microsoft JDBC Driver for SQL Server page.
The Microsoft Azure SQL Data Warehouse connector has no tracked properties.