Creating or Updating a Connector Database on your Database Server Instance
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
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.Sqlfile in the Adobe Experience Manager
quickstartfolder for the list of SQL commands required to manually update the database.
Note about MySQL: You may need to edit the
mysql.inifile to add the following lines:
Translation Database Size Requirements
|Minimum size||1 GB|
|Recommended size||10 GB|
Recommendation: Increase the database size relative to the site content.