[en] You can connect Acrolinx to a database other than the freely distributed database formats that come with the Acrolinx Platform.
[en] To configure the connection, you should be familiar with the operating system in use, Kubernetes, TCP/IP networks, client-server systems, and the necessary communication protocols.
[en] To connect to an external Targets database, confirm that Acrolinx supports your database format. After that, you can create a new database and database user for Acrolinx and adjust database credentials in your Acrolinx installation.
[en] If you need to migrate an existing Targets database, make sure to back up your data first.
[en] To connect to an external Targets database, follow these major steps:
[en] If you’re migrating Targets from a native Acrolinx Targets database, export all your Targets to a backup file.
[en] If you’re installing the Acrolinx Platform on a new computer, install Acrolinx and guidance packages according to the standard installation procedures under Install Acrolinx for the First Time.
[en] Prepare the external Targets database.
[en] Change the database credentials in your Acrolinx installation.
[en] If you’re migrating Targets from a native Acrolinx Targets database, import your database backup file.
[en] For an up-to-date list of supported database formats, visit the Standard Stack Compatibility Guide.
[en] To prepare an external Targets database for Acrolinx, follow these steps:
[en] Create a new empty database on your database server with the name of your choice.
[en] We recommend that you select UTF-8 encoding for the database. This encoding type guarantees that you can store terms in any language.
[en] Configure a user that has full write permissions on your new database.
[en] If you use an Oracle database to store Targets data:
[en] Make sure that the user for the Targets database is different from the users for the other databases. In Oracle databases, usernames are associated with a specific database schema.
[en] You also need the following user permissions for an Oracle database:
grant create session to <USER>; grant create table to <USER>; grant create sequence to <USER>; grant create view to <USER>; grant create procedure to <USER>; grant execute on SYS.DBMS_LOCK to <USER>; grant select on SYS.GV_$LOCK to <USER>; grant select on SYS.GV_$SESSION to <USER>;
[en] The credentials for all databases (reporting, Terminology, Analytics, Targets, Reuse) are kept in a separate section in the helm configuration of the Acrolinx Platform and can not be edited separately.
[en] Please visit [en] Set Custom Database Credentials for details.