Creating or Updating a Connector Database on your Database Server Instance

Note: This section is not applicable to the AEM Cloud Connector.

The Connector requires one of the following databases for its database engine:

  • MySQL version 5.0 or higher
  • Microsoft SQL Server version 2012 or higher
  • Oracle 11g and 12c
  • PostgreSQL

For new Connector installations, create a database container, such as CTCTRANSLATION. The Connector will automatically create all tables and columns.

When upgrading from a previous version, the Connector automatically updates all tables and columns.

Note: If the automatic upgrade of the database fails while upgrading your version of the Connector, for example, because of insufficient permissions, the Errors and SQL Scripts buttons are displayed in the JDBC SQL Connection section of the Configuration page. Click Errors to view the related error messages. Click SQL Scripts to download the generated SQL scripts. A DBA can then run the scripts. Refer to the ct_db_update.Sql file in the Adobe Experience Manager quickstart folder for the list of SQL commands required to manually update the database.

Note about MySQL: You may need to edit the mysql.ini file to add the following lines:
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8

Translation Database Size Requirements
Minimum size 1 GB
Recommended size 10 GB

Recommendation: Increase the database size relative to the site content.