Database Management Systems

The following tables list the database management systems that CA SDM r12.9 supports.

Important! Consider the following information:

For UNIX/Linux Oracle implementations, set the Oracle environment variables before you install or migrate CA SDM.
To resolve some known issues with Oracle 11g, you must force case sensitivity by setting the NX.env variable as NX_ORACLE_CASE_INSENSITIVE=0. We recommend that you also set NX_DSSORT to BINARY to make the domsrvr sort case sensitive. After upgrading to the latest release of Oracle 11gR2 (which must include Oracle patch 10248523), you can reset NX_ORACLE_CASE_INSENSITIVE=1 for case insensitivity support.
If you want to use a remote MDB, the database client (Oracle or SQL Server) must be installed on the same computer where you install CA SDM.

CA SDM supports the following Microsoft SQL Server - Database releases:

CA SDM supports Oracle 11g R2. 32-bit ORACLE client must be installed on all CA SDM servers.

Note: We support remote MDB on HP UNIX with Oracle 11g R2.