Install Data Quality on Docker with Informatica Deployment Manager

Back Next

Set Up Databases

Before you install

Data Quality

, you must set up some databases for the repositories and application services associated with

Data Quality

. The databases store data, metadata, and run-time results of the repositories and application services.

When you set up a database, you must ensure that the required disk space is available on the database and create the database with parameters required by

Data Quality

. You must also create user accounts for the databases and install the database clients.

For more information about the disk space, parameters, user accounts, and clients for the databases, see the

Installation for PowerCenter and Data Quality

guide for the

Data Quality

version that you want to install.

To install

Data Quality

with all its supported application services, you must set up the following databases:

Domain configuration repository database: The domain stores configuration and user information in the domain configuration repository. You can create the domain configuration repository on an Oracle, PostgreSQL, or Microsoft SQL Server database.
Model repository database: The Model repository stores information about the metadata for the data objects and mappings in a relational database.
You can create the Model repository on an Oracle, Microsoft Azure SQL, Microsoft SQL Server, or PostgreSQL database.
Reference data warehouse database: The reference data warehouse stores the data values for reference table objects that you define in a Model repository. You can create the reference data warehouse on an Oracle, Microsoft SQL Server, or PostgreSQL database.
You can use a PostgreSQL database only for
Data Quality
10.5.1.
Profiling warehouse database: The profiling warehouse stores profiling and scorecard results for the Data Integration Service. You need a profiling warehouse to perform profiling and data discovery. You can create the profiling warehouse on an Oracle or Microsoft SQL Server database.
Workflow database: The workflow database stores run-time metadata for workflows using the Data Integration Service. You can use an Oracle or Microsoft SQL Server database as the workflow database.
Exception management database: The exception management database stores exception records for
Data Quality
. You can use an Oracle or Microsoft SQL Server database as the exception management database.

You can either create an on-premises database or use a managed database for each repository and application service. When you run the Docker image, you must provide information about the databases.

Rename Saved Search

Table of Contents

Install Data Quality on Docker with Informatica Deployment Manager

Install Data Quality on Docker with Informatica Deployment Manager

Set Up Databases

Set Up Databases