IBM Support

Setting up Migration Manager Database Target

Question & Answer


Question

Where can I find the information that is needed to set the Database URL and Driver Name needed to set up a Database Target in Manage Targets Dialog in Migration Manager Application?

Answer

The information can be found in the System Properties Application for the Target Environment.

1. Open System Properties

2. Open the Filter in Global Properties section and bring up mxe.db.url property and copy the Current Value. This will go into the Database URL or File Path

Example:


jdbc:sqlserver://;serverName=mxeam9.lab.xyz.com;databaseName=maxdb75;portNumber=1433;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;

3. Now search for mxe.db.driver and copy the Current Value. This will go into Driver Name field.

Example:
com.microsoft.sqlserver.jdbc.SQLServerDriver

4. You also need the mxe.db.user value.
5. The password is also required. You may need to ask the owner of the database for this information as it does not display.
6. The Schema Name field may or may not be required depending on your database.



Note: In version 7.5 the there is a Test button to verify the connection.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Migration Manager","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21570977