Configuring the ODBC data source

Before installing the Contenta software, you must configure the Oracle or Microsoft SQL Server ODBC Data Source.

Configuring an Oracle ODBC data source

Refer to the Oracle documentation for instructions on configuring the Oracle ODBC data source.

Note the following Contenta-specific considerations when completing the configuration.
  • Select the Oracle 64-bit ODBC driver (for example, Oracle in OraClientxxx_home1).
  • The TNS Service Name is the name specified in the tnsnames.ora file when Oracle is configured for Contenta.
  • In the Oracle UI, ensure that the Enable LOBs options is not selected.
  • After configuring the data source, log in as xyadmin, or ask your Oracle DBA for a user name and password to test the connection. The default password for xyadmin is manager. However, if the default password does not work, it may have been changed by your DBA for security purposes.

Configuring a Microsoft SQL Server ODBC data source

Refer to the Microsoft SQL Server documentation for instructions on configuring the MSSQL ODBC data source.

Note the following Contenta-specific considerations when completing the configuration.
  • Select the Microsoft ODBC Driver version_# for SQL Server.
  • In the MSSQL UI, under How should SQL Server verify the authenticity of the login ID?, select With SQL Server authentication using a login ID and password entered by the user.
  • In the MSSQL UI, ensure that Perform translation for character data is enabled.

Configuring unixODBC configuration files on Windows

The following configuration files are delivered to the Contenta_home/bin directory by the Contenta Server installation program.
  • odbcinst.ini
  • odbc.ini
These files must be modified to support unixODBC.
Modify the odbcinst.ini file to specify the available drivers as in the following example, which shows the file configured for ODBC drivers named "Oracle" and "MSSQL".
[Oracle]
Description=Oracle Driver
Driver=[ORACLE_HOME]/bin/sqora32.dll
Setup=[ORACLE_HOME]/bin/sqoras32.dll

[MSSQL]
Description=ODBC Driver 17 for SQL Server UNIXODBC
Driver=C:/Windows/System32/msodbcsql17.dll
Setup=C:/Windows/System32/msodbcsql17.dll
Modify the odbc.ini to specify the available DSNs as in the following example, which shows the file configured for Oracle ODBC with a data source named "ora19cwin".
[ora19cwin]
Description=Oracle DSN
Driver=Oracle

[mssqlserver]
Description=MSSQL Server DSN
Driver=MSSQL

After modifying these configuration files, verify that the environment variable ODBCSYSINI is set to their location (such as Contenta_home/bin).