Microsoft Dynamics NAV can be accessed in different ways depending on which version you are using. For NAV2009 or earlier you can use C/Front to access MS Dynamics NAV on the database level (with support for Flow Fields etc.) or you can use this MS Dynamics NAV SQL connector to access NAV on the database level (for NAV2009 and NAV2013 and later) or you can use our NAS Connector or finally you can use our MS Dynamics NAV Web Services.
A very common scenario is to use two connectors in combination - for example, this NAV SQL connector and the NAV Web Service connector. This is included in the Rapidi subscriptions and we highly recommend this as you get the best of both worlds: You get speed when reading from NAV through the database based connector and you get a high level of integration with NAV Code and validation when writing data through the NAV Web Service connector.
Please note that support for reading FlowFields is limited when working directly with the SQL database.
For inserting new data in NAV2009R2 or NAV2013 or later we recommend the use of our MS Dynamics NAV Web Services.
For reading a large amount of data from NAV - including Customers, Contacts, Invoices, InvoiceLines, LedgerEntries, etc. we recommend the use of this connector as it is fast and support using timestamp as SourceControl (to transfer changed/added records only).
This connector automatically combines the company name chosen with the NAV table name to find the correct SQL table. It also accepts Table and field names as they are shown in NAV (and used with the C/Front based connector) - i.e. field names like "No." and "Country/Region Code" are accepted and transformed into the correct names used in the SQL database.
The fields on the MS Dynamics NAV SQL Connection should be filled in as follows: