MSSQL
To switch to an MSSQL database:
Step 1 Locate the createcachedb-mssql.sql script. The datafile sizes should match those from the Master database.
Step 2 Edit the script for datafile locations and user password. The default password is "tidalcloud888".
Step 3 Save the script.
Step 4 Execute the script in MSSQL server to create the new database.
Step 5 Locate the plugin <ClientManagerInstallDir>/config/<cache>.dsp configuration file. For example, C:\program files\TIDAL\ClientManager\config\tes-6.2.dsp.
Step 6 Add the following properties to the.dsp file.
CacheDBType=MSSQL
CacheJdbcURL= jdbc:sqlserver://myservername:1433;
databaseName=TESCache;SelectMethod=cursor
CacheJdbcDriver= com.microsoft.sqlserver.jdbc.SQLServerDriver
CacheUserName=TES
If a different password was used in Step 2, run the following command in <ClientManagerInstallDir>/script to update the password after saving the.dsp file.
cm.cmd setcmpwd <.dsp file name> tidalcloud888 NEWPASSWORD
Step 7 Copy the MSSQL JDBC driver, sqljdbc4.jar, into <ClientManagerInstallDir>/lib.
Step 8 Restart the Client Manager. The Client Manager's plugin cache database is now switched from the embeded Derby version to the MSSQL version configured here.
Oracle
To switch to an Oracle database:
Step 1 Locate the createcachedb-oracle.sql script in <ClientManagerInstallDir>/cache/<cache>/cachesql.zip.
Step 2 Edit the script for datafile locations and user password. The datafile sizes should match those from the Master database. The default password is “tidalcloud888”.
Step 3 Save the script. The user (schema) name must be TES. This cannot be changed.
Step 4 Execute the script as Oracle SYSTEM user (or equivalent).
Step 5 Locate the plugin <ClientManagerInstallDir>/config/<cache>.dsp configuration file. For example, C:\program files\TIDAL\ClientManager\config\tes-6.2.dsp.
Step 6 Add the following properties to the.dsp file. Enter the actual port number and SID from your environment for the CacheJDBCURL property.
CacheDBType=ORACLE
CacheJdbcURL=jdbc:oracle:thin:@myoracleserver:1521:TES
CacheJdbcDriver=oracle.jdbc.driver.OracleDriver
CacheUserName=TES
If a different password was used in step #2, run the following command in <ClientManagerInstallDir>/bin directory to update the password after saving the.dsp file.
./cm setcmpwd <.dsp file name> tidalcloud888 NEWPASSWORD
Step 7 Copy the Oracle JDBC driver, ojdbc6.jar, into <ClientManagerInstallDir>/lib.
Step 8 Restart the Client Manager. The Client Manager’s plugin cache database is now switched from the embeded Derby version to the ORACLE version configured here.
Note It is recommended you start the Oracle "open_cursors" setting at 2000. Use 3000 for larger systems. To speed up the release of cursors after an operation, the setting "DataCache.StatementCacheSize=1" can be added to the dsp configuration file.