Skip to Content
avatar image
Former Member

SAP MDM Import Problems with Oracle

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Aug 11, 2005 at 01:27 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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)

  • avatar image
    Former Member
    Aug 29, 2005 at 10:00 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 14, 2005 at 05:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 14, 2005 at 08:32 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2005 at 06:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 13, 2007 at 07:17 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded