Writing to Navi tables using SQL

greg@mesa
greg@mesa Member Posts: 2
edited 2000-10-17 in Navision Financials
Can it be done?

I assume there are issues with flowfields, but is it possible to use SQL to put data directly into a Navision table? What does it take? Is this a recommended practice? My client will be using SQL7 with Nav2.50.

-Greg

Comments

  • mfabian
    mfabian Member Posts: 187
    Yes, it can be done.

    For example you can link MS-Access 97/2000 via ODBC to a Navision Table and use queries to insert/modify data in the Fin DB. I tied that already and it works fine.

    Marcus


    Marcus Fabian
    m.fabian@thenet.ch
    +41 79 439 78 72
    With best regards from Switzerland

    Marcus Fabian
  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    Yes, it's quite possible.

    We did this for a client where it was needed to synchronize the Customers with the central SAP database in Paris (FR), the Ship-to addresses with an Oracle database in Houston (USA) and the Items (their web-catalog) with the Oracle system in The Hague (NL). All replications are done through Stored Procedures on SQL 7 Server, updating/inserting the various tables of Navision 2.5 directly with SQL queries.

    John

Categories