Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 282 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Navision 2.60 and ORACLE Warehouse Builder 10g
hipogrito
Member Posts: 13
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
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
0
Comments
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