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"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21570977