Setting Up an Oracle-Based Translation Database

This section describes how to set up an Oracle database to use with the Connector. For information on database size requirements, see Translation Database Size Requirements.

Recommendation: Create a separate Oracle database user for Clay Tablet data. Alternatively, you can use an existing Oracle database user for Clay Tablet data.

  1. Optional. Create a Oracle database user for Clay Tablet data, using SQL statements similar to the following:

CREATE USER ctttrans IDENTIFIED BY xxxxxxxx 

DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; 

GRANT UNLIMITED TABLESPACE TO ctttrans;

GRANT CONNECT, CREATE TABLE TO ctttrans;

  1. Add a CT3Translation.Oracle connection to the Sitecore connection string configuration. Add the following to the Sitecore connection string configuration:

<add name=“CT3Translation.Oracle” connectionString=“user id=ctttrans;password=xxxxxxxx;Data Source=XE”/>

Depending on the active configuration in the user’s setup, this is one of the following:

  • Website/App_Config/ConnectionStrings.config
  • Website/App_Config/ConnectionStringsOracle.config

Note: The user specified in the connection string must have permission to modify the table structure in the database. This user must have permission to run ALTER TABLE statements.

  1. Ensure that the right version of Oracle.DataAccess.dll is in the Website/bin directory or in the right path. The DLL should match the Oracle database that the user is using. If the user is already using Oracle as the database for the Sitecore content, this should already be set up correctly.