![]() ![]() Reconcile account password object properties This is either the current password or the password of the reconciliation account. The platform automatically detects the password to use for logon. Any of these variables may be specified in the connection string as optional parameters, which will only be replaced if the account property exists. These variables will be replaced during run time with the appropriate values from standard or customized account properties. The Connection String template may contain any number of the following variables enclosed with ‘%’ (percentage) sign. This parameter is required if the DSN parameter is not supplied either at platform level or password level, indicating that the connection method is DSN-Less. The SQL statement that will be used as a connection string. In order to work with 32-bit ODBC drivers on 64-bit platforms (such as the Oracle instant client that is part of the CPM installation), use the ODBC tool which can be found in the following path: c:\windows\sysWOW64\odbcad32.exe.Ĭonnect to the remote database with a connection string (DSN-less) 1.ĭisplay the ODBC platform, and in Additional Policy Settings, check the values of the following required parameter. Creating a DSN for a remote database on the CPM server may require users to work with external ODBC drivers (MSSQL, Oracle, etc…). A DSN may be required to perform management tasks on database accounts. Make sure that the DSN is a system DSN and not a User DSN. Use the testing option in the DSN to test the connection between the CPM machine and the database server. This platform supports the following connection methods to connect to remote databases:Ĭreate a System DSN for each database in the CPM machine. In the Platform Management page, make sure that the following target account platform is displayed: If the machine does not support this version of ODBC, download the latest MDAC_typ.exe from the Microsoft downloads site. The machine that runs the CPM must support ODBC, version 2.7 and higher. The CPM supports remote password management on all databases that support ODBC connections. Automatic password management is supported on databases that support ODBC connections on IPv4 and IPv6. ![]()
0 Comments
Leave a Reply. |