[en] Connect to an External Reuse Database

[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, make sure you're familiar with the operating system in use, Kubernetes, TCP/IP networks, client-server systems, and the necessary communication protocols.

[en] Major Steps

[en] To connect to an external reuse 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.

Tipp

[en] If you need to migrate an existing reuse database, make sure to back up your data first.

[en] To connect to an external reuse database, follow these major steps:

[en] If you’re migrating phrases from a native Acrolinx reuse database, export all your replacements 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 reuse database.
[en] Change the database credentials in your Acrolinx installation.
[en] If you’re migrating phrases from a native Acrolinx reuse database, import your database backup file.

[en] Supported Database Formats

[en] For an up-to-date list of supported database formats, visit the Standard Stack Compatibility Guide.

[en] Create a Database Backup from an Existing Reuse Database

[en] Want to migrate an existing Acrolinx reuse database to an external database? To get started, create a database backup from your existing Acrolinx Platform instance.

[en] To create a database backup, follow these steps:

[en] On the Reuse page, click the Export replacements button.
[en] Confirm the export in the dialog window that appears.

[en] The file that contains all replacements will download with a file name like replacements-export-YYYY-MM-DD.csv.

[en] Prepare an External Reuse Database

[en] To prepare an external reuse 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.
Hinweis

[en] If you use an Oracle database to store reuse data:
- [en] Make sure that the user for the reuse 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] Change the Reuse Database Credentials in Your Acrolinx Installation

[en] The credentials for all databases (reporting, Terminology, Analytics, Targets, Reuse) are kept in a separate section of the Acrolinx Platform's Helm configuration and can't be edited separately.

[en] For more details, visit Setting Custom Database Credentials.

[en] Restore Your Database Backup

[en] Want to use existing Reuse phrases in a newly configured database? You can easily restore a backup from your original database.

[en] To restore a database backup, follow these steps:

[en] On the Reuse page, click the Import replacements button.
[en] Click Select File to locate the database backup file.
[en] Click Import.
[en] Click Close in the import result dialog.

Wie können wir helfen?

Suche