SAP MDM Import Problems with Oracle

[Former Member]

Hi,

I've installed the MDM 5.5 today in my system landscape. Server and Tools are all installed, no problem.

After importing data from MSAccess-databases, XML-sheets and excel-sheets, i tried to import data from a oracle-database. But the ImportManager couldn't establish a connection to the dbms.

Probably i got the wrong configuration values in the "connect to source" dialog.

DBMS Server: 192.168. *. * //Server ip where Oracle is installed

Database: addressesdb

User: * //has all rights

Password: * //verified it

Maybe somebody can help and tell me whats wrong. Do I have to add a port or complete Database URL?

I didn't find an example in the Import Manager Reference Guide.

Thx a lot.

[Former Member]

In import Manager while trying to put source as Oracle,I'm getting error

ORA-06401: NETCMN : Invalid Driver Designator

Entries I'm doing on the screen are:

Database Server : HOSTNAME:PORT

Database: ORACLE_SID

Username: VALID USER

Password: VALID PASSWORD.

I've tried giving only HOSTNAME i.e. NO PORT in database server but then I get an error ORA: 12637: Packet Receive failed.

Otherwise the same connection is working fine at SQL Prompt.

thanks for the help.

[Former Member]

Hi Andreas,

You have to configure the oracle service and provide that service name in DBMS Server instead of IP/Machine Name. Here I assume that you already know that how to create the oracle service.

Hopefully this will work.

Regards

Shahid Nadeem

[Former Member]

I have the same issues, and tried your suggestion to put the service name in the DBMS Server field, but then get the error message

ORA-01435 user dose not exist.

I can connect use other client tool.

Jan

[Former Member]

Try to right click on the server name in the console, and select DBMS settings. Give the database name, login and password, and try connecting. Does that work?

[Former Member]

I'm having the same problem as Andreas. I can connect to a specific Oracle database using several different client applications, but get the same errors Andreas did when attempting to connect via MDM Import Manager.

I also tried using the ODBC connector, but that has been just as fruitless. I have a dsn file that I use to connect to the above Oracle database from other client apps, but MDM IM gives the following error message when I ty to connect:

Login Error:[Microsoft][ODBC Driver Message]Data source not found and no default driver specified.

I do not get this error in any other client apps. I tried both with and without the .dsn extentsion. I also tried giving the full path to the dsn file, but then I get a "source name too long" message.

Has anyone else successfully imported from Oracle -- either directly or through an ODBC connection?

Thanks,

Vince Moore

[Former Member]

I can connect to the ressource with DBVisualizer and view the database. I can add new tables, i have full access to the database, everything looks fine, except the connection via the Import Manager.

[Former Member]

what happens with you connect to Oracle? Do you get any error message or it just hangs? If it only hangs then it might be you're using too powerful user and the ImportManger in the very beginning tries to list all available tables. If so it can take LOTS of time.

Please explain your error message. In general what you do is absolutely ok and should work.

[Former Member]

The error message is rather simple:

"Cannot connect to source". That's all.

In my oracle database are only a few tables, so loading should not take too long but thx for the hint, even if the problem is another.

Thx for the Reply.

[Former Member]

do you succed to connect to the database from the computer where the import manager is? try sqlplus and supply the same settings as you do in the import manager. It should work unless you have connection problems in general (client libraries for instance)