Navision 2.60 and ORACLE Warehouse Builder 10g

hipogrito
hipogrito Member Posts: 13
edited 2005-12-01 in Navision Financials
Hi:

I'm trying to read Navision 2.60 data into ORACLE Warehouse Builder 10g (OWB). The system was quite difficult to set up because the ORACLE database is in a Linux machine. But we managed to make all the connection thru an OpenLink ODBC-ODBC bridge. We test the connections in OWB, with an Oracle Link, and it works... I can read the metadata from Navision so I see the tables and its columns.

Now, I want to make the real thing, move data, so I made the suitable mapping in OWB but when I went to deploy it I found some errors in the connections. Why? Because in deployment phase the connection need a Database name... and what is this name in Navision? I tried with different options (Navision DSN of the ODBC Driver which I thought was the one, name of the database file (weird!), and several more, but none of them worked.

So the question is: does anybody know what name do I have to put there?

Thank you very much,

Best regards
Fran

Comments

  • mploschiavo
    mploschiavo Member Posts: 6
    if i recall correctly....
    rather than using the file name for the db, which in some cases could be multiple files, and there is no way that it could work

    you should try using the company name in navision....

    cheers.

    Matthew Loschiavo
    Navision Consultant
    www.jackshigh.com

Categories