Create a Model repository to store information about the metadata for the data objects and mappings in a relational database. If you want to generate monitoring statistics, you must create a dedicated monitoring Model repository to store run-time monitoring statistics.
You can create the Model repository and the monitoring Model repository in one of the following databases:
Microsoft Azure SQL
The Microsoft Azure SQL database is certified by Informatica to create the Model repository. Complete the following tasks to prepare the Microsoft Azure SQL database for the Model repository and for the monitoring Model repository or to create a container database:
You can use an Oracle database if you can ensure proper connectivity between the database and the Kubernetes cluster. Complete the following tasks to prepare an Oracle database for the Model repository and for the monitoring Model repository or to create a container database:
Install compatible versions of the Oracle client and Oracle database server. You must also install the same version of the Oracle client on all machines that require it.
PostgreSQL
You can use a PostgreSQL database if you can ensure proper connectivity between the database and the Kubernetes cluster. Complete the following tasks to prepare a PostgreSQL database for the Model repository and for the monitoring Model repository or to create a container database:
You do not need to install the PostgreSQL client software, as the installer bundles it with the image.
Microsoft SQL Server
You can use a Microsoft SQL Server database if you can ensure proper connectivity between the database and the Kubernetes cluster. Complete the following tasks to prepare a Microsoft SQL Server database for the Model repository and for the monitoring Model repository or to create a container database: