Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import Manager and ODBC (DB2) as source

Hello,

MDM training and documentation seems to depend on using files which is cumbersome. We would like to use an ODBC source instead as we have many large data sources to import.

We are on MDM SP6 MDMIMS55006P_3-10003641.ZIP

DB2 version 9.1 locally on windows

We have created the ODBC DSN and specify the database and can test connection ok

When specifying the ODBC as source, there is then a drop down list for remote system, MDM BW, MDM SCM...MDM

I select MDM. What is this for?

I specify the system DSN name, dbo userid and password.

I get one of two situations depending on the day it seems

1. Cannot connect to source

2. Import manager opens and the source list on the left is empty - no tables

Any ideas are greatly appreciated

Lee Lewis

Tags:
Not what you were looking for? View more on this topic or Ask a question