Workflow Database Requirements
The Data Integration Service stores run-time metadata for workflows in the workflow database. Before you create the workflow database, set up a database and database user account for the workflow database.
You specify the workflow database connection when you create the Data Integration Service.
The workflow database supports the following database types:
- •IBM DB2 UDB
- •Microsoft SQL Server
- •Oracle
Allow 200 MB of disk space for the database.
Note: Ensure that you install the database client on the machine on which you want to run the Data Integration Service.
IBM DB2 Database Requirements
Use the following guidelines when you set up the repository on IBM DB2:
Microsoft SQL Server Database Requirements
Use the following guidelines when you set up the repository on Microsoft SQL Server:
Oracle Database Requirements
Use the following guidelines when you set up the repository on Oracle:
- •Verify that the database user has the CONNECT, RESOURCE, and CREATE VIEW privileges.
- •Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.
- •Set the connection pooling parameters.
The following table lists the connection pooling parameters that you must set:
Parameter | Value |
|---|
Maximum Connection Pool Size | 128 |
Minimum Connection Pool Size | 0 |
Maximum Idle Time | 120 seconds |
- •Optionally, configure the database for Oracle Advanced Security Option (ASO). You can activate Oracle ASO for the database if the Informatica installation supports Oracle ASO.
For information about preparing the Informatica installation for Oracle ASO, consult the following Informatica Knowledge Base article: