Informatica services and clients store data and metadata in the Model repository. Configure a monitoring Model repository to store statistics for ad hoc jobs, applications, logical data objects, SQL data services, web services, and workflows. Before you create the Model Repository Service, set up a database and database user account for the Model repository. It is recommended that you use different database configuration for Model repository and monitoring Model repository.
The Model repository supports the following database types:
IBM DB2 UDB
Microsoft SQL Server
Microsoft Azure SQL Database
When you configure Microsoft SQL Server, you can choose to configure the Microsoft Azure SQL Database as the Model repository.
If you specify the Windows NT credentials for the Model repository database on Microsoft SQL Server, you must also specify the connection string syntax to include the authentication method as NTLM.
Allow 3 GB of disk space for DB2. Allow 200 MB of disk space for all other database types.
For more information about configuring the database, see the documentation for your database system.