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 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 in a text editor (Notepad for example).
6 Search for DataSourceIPCustomProperties.
The default value is of this parameter is:
User ID=;Password=;Data Source=;Initial Catalog=;Location=;Mode=Read;Connect Timeout=;
7 Type the appropriate property name at the end of the value. For example, to add the property MR Init Category Names, add an entry like this:
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.
10 In the Services list, select the DataCollectionJDBCDriverService service.
11 Click Action > Start, and then close the Services dialog.
See also