Navision Database and Oracle DB under Linux

CBI

I need a solution to bring Datas from a Navision (native) DB to a Oracle DB under Linux (and back) - Does somebody know a solution?

Thank you for help

Skeeve

How frequently do you want to update the data ?
Just a few tables or all tables ?
Should Trigger's be executed while reading or writing data?

If it's just a few tables I'd simply use flat-files.

You could also check out http://info.strengur.is. They have a BORKER solution where you get access to Navision Data from any platform because there's a Java-Applet.

---

--
Skeeve
Navision Developer

[This message has been edited by Skeeve (edited 02-03-2001).]

CBI

Thank you for answer - no there is no need for an execution of triggers. Datas in Oracle and Navision DB should just be the same because Oracle DB on Linux shall be used as base of an Intranet - Applicaton with actual datas from Navision DB

Chilango

I have made a ODBC connection.

But the only solution was a BASIC program.

Have anyone a idea how it was posible to write a programm with
the ADO libary you con use in the automation control.

John_Tegelaar

Is running Navision on SQL Server not an option? Then you could fairly easy connect to other platforms with the help of some stored procedures.

If it has to be native Navision, then probably the quickest way is writing a Visual Basic program to do the actual data transfer. You can call this program from C/AL with the SHELL command.

John

CBI

Hi John

SQL 7 is not a option for this customer. In this company all Servers are under Linux and they don't want to change

Best regards

Christoph

John_Tegelaar

Christoph,

Do you mean the Navision server will have to run on Linux as well? Don't think that's a supported platform at the moment...

And if they have to install a Windows server to run Navision, then taking the SQL option could be justified for doing the interfacing.

John

CBI

John - No, Navision shall run on Windows but Internet server on Linux with Oracle DB on Linux