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.
In the Workflow Manager, click
Connections
and select
Relational
connection type.
The
Relational Connection Browser
dialog box appears.
Click New.
The
Select Subtype
dialog box appears.
Select
ODBC
from the
Select Type
list.
Click
New
to create the connection.
Select the database and click
OK
.
The
Connection Object Definition
dialog box appears.
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.