Preparing an empty database (or schema) for EA Infoport metadata

To install Infoport, you need to have an empty schema created in the database that you want to use for application metadata. 

 

The created schema must have an assigned user with owner rights and a collation that will be "case insensitive" (indicated by CI in the collation name) and Accent-insensitive (indicated by AI in the collation name).

 

For example:

 

Mssql: Czech_CI_AI

 

MySQL (MariaDB): utf8mb4_0900_ai_ci

You will use the created schema in the configuration manager where you will reference it.
When you first start Infoport, the necessary database tables are created in the schema for the application to run correctly and the default application settings are also created.