Navision Database and Oracle DB under Linux

CBI
CBI Member Posts: 5
edited 2001-03-08 in Navision Financials
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

Comments

  • Skeeve
    Skeeve Member Posts: 33
    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
    CBI Member Posts: 5
    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
    Chilango Member Posts: 5
    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
    John_Tegelaar Member Posts: 159
    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
    CBI Member Posts: 5
    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
    John_Tegelaar Member Posts: 159
    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
    CBI Member Posts: 5
    John - No, Navision shall run on Windows but Internet server on Linux with Oracle DB on Linux

Categories