Microsoft Azure SQL Data Warehouse V2 Connector > Pushdown Optimization > Create an ODBC Connection
  

Create an ODBC Connection

Create ODBC connections to access Microsoft Azure SQL Data Warehouse source and target objects.
Perform the following steps to create an ODBC connection on the Connections page:
    1On the Connections page, click New Connection. The New Connection page appears.
    2Configure the following connection details in the Connection Details section:
    Property
    Description
    Connection Name
    Name of the ODBC connection.
    Description
    Description of the connection.
    Type
    Type of the connection. Select the type of the connection as ODBC.
    3Configure the following connection details in the Connection Properties section:
    Property
    Description
    Runtime Environment
    The name of the runtime environment where you want to run the tasks.
    User Name
    User name of the Microsoft Azure SQL Data Warehouse account.
    Password
    Password for the Microsoft Azure SQL Data Warehouse account.
    Data Source Name
    Enter the name of the ODBC data source name that you created for the Microsoft Azure SQL Data Warehouse database.
    Schema
    Microsoft Azure SQL Data Warehouse schema name.
    Code Page
    Select the code page that the Secure Agent must use to read or write data.
    ODBC Subtype
    Enter the value of the ODBC Subtype field as Azure DW.
    4Click OK.
    The Microsoft Azure SQL Data Warehouse ODBC connection is created successfully.

Cross-Schema Pushdown Optimization

You can use cross-schema pushdown optimization for a mapping to read or write data based on different schemas within the same database.
To use cross-schema pushdown optimization, you must create two Microsoft Azure SQL Data Warehouse ODBC connections and specify different schemas for each of the connections. Select the Enable cross-schema pushdown optimization check box in the advanced session properties of the mapping. By default, the check box is selected.
Note: Ensure that the schemas you specify in both of the Microsoft Azure SQL Data Warehouse ODBC connections belong to the same database.
Consider the following steps to use cross-schema pushdown optimization:
  1. 1Create an Azure_DW1 ODBC connection and specify DW_schema1 schema in the connection properties.
  2. 2Create another Azure_DW2 ODBC connection and specify DW_schema2 schema in the connection properties.
  3. 3Create a mapping and perform the following tasks:
    1. aSelect the Azure_DW1 connection as source to read data from the source object using the DW_schema1 schema.
    2. bSelect the Azure_DW2 connection as target to write data to the target object using the DW_schema2 schema.
    3. cSelect the Enable cross-schema pushdown optimization check box in the advanced session properties.
      4. The following image shows the Enable cross-schema pushdown optimization property:
    4. dRun the mapping.
When you run the mapping, the Secure Agent reads data from the source object using DW_schema1 and writes data to the target object using DW_schema2.