Updating the JDBC Service Driver to support custom connection property prefixes
By default, custom connection properties that are prefixed by MR or MR Init are not supported in the connection string. If you want to specify these custom connection properties, they must be manually declared in the JDBC Service Driver's configuration:
1 After installing the JDBC Service Driver, go to the Windows Control Panel > Administrative Tools > Services.
2 In the Services list, select the DataCollectionJDBCDriverService service.
3 On the Action menu, click Stop.
4 Navigate to the \cfg directory in the JDBC Service Driver installation path.
The default path is:
[INSTALL_FOLDER]\UNICOM\Intelligence\<version>\DDL\JDBC Server
5 Open the file oadm.ini with a text editor (Notepad for example).
6 Search for the keyword DataSourceIPCustomProperties; the default value is:
User ID=;Password=;Data Source=;Initial Catalog=;Location=;Mode=Read;Connect Timeout=;
7 Append the appropriate property name at the end of the value. For example, if you want to add the property MR Init Category Names, the value should be written as:
User ID=;Password=;Data Source=;Initial Catalog=;Location=;Mode=Read;Connect Timeout=;MR Init Category Names=;
8 Save the oadm.ini file.
9 Go back to the Services dialog box.
10 In the Services list, select the DataCollectionJDBCDriverService service.
11 On the Action menu, click Start, and then close the Services dialog box.
See also