Install Data Quality on Docker with Informatica Deployment Manager

Back Next

Step 9. Configure the Workflow Database Connection

The Data Integration Service stores run-time metadata for workflows in the workflow database. On the

Workflow Connection

page, you can set up the workflow database and configure the connection for the Data Integration service to access the workflow database.

In the

Workflow connection database information

section, enter a name for the workflow database connection.

When you specify the name for the connection, consider the following guidelines:

The name of the connection must be unique within the domain. It must not exceed 128 characters or begin with the special character

. It must also not contain spaces or the following special characters:

` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [

You cannot change the name of the connection after it is created.

Select the database type for the workflow database and specify the user ID and password for the database.

Specify the database parameters.

If you selected

Microsoft SQL Server

, enter the schema name for the database. If you selected

Oracle

, the installer creates the tables in the default schema.

Enter the JDBC connection string.

You can use the following syntax in the JDBC connection string to connect to a secure database:

Oracle: jdbc:informatica:oracle://<host name>:<port number>;ServiceName=<service name>
Microsoft SQL Server: jdbc:informatica:sqlserver://<host name>:<port number>;SelectMethod=cursor;DatabaseName=<database name>

Enter the data access connection string.

Click

to configure additional services, or run the Docker image.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.