Data Validation Option Integration with Cloudera

Data Validation Option Integration with Cloudera

Step 5. Create a Connection Object

Step 5. Create a Connection Object

Before you import and schedule the workflow, you must configure connections in the Workflow Manager. Configure the connection to the repository in the PowerCenter Workflow Manager.
  1. In the Workflow Manager, click
    Connections
    and select
    Relational
    connection type.
    The
    Relational Connection Browser
    dialog box appears.
  2. Click New.
    The
    Select Subtype
    dialog box appears.
  3. Select
    ODBC
    from the
    Select Type
    list.
  4. Click
    New
    to create the connection.
  5. Select the database and click
    OK
    .
    The
    Connection Object Definition
    dialog box appears.
  6. Specify the relational connection properties. For connection string, enter the 64-bit system data source name that you provided to connect to the Hive instance installation.
  7. Click
    OK
    .
    The database connection appears in the
    Connection Browser
    list.

0 COMMENTS

We’d like to hear from you!