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
Allow 200 MB of disk space for the database.
Ensure that you install the database client on the machine on which you want to run the Data Integration Service.