Setting up Migration Manager Database Target

Technote (FAQ)


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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Migration Manager

Software version:

7.5

Operating system(s):

Platform Independent

Reference #:

1570977

Modified date:

2013-12-30

Translate my page

Machine Translation

Content navigation