Search our Wiki
MS Dynamics NAV SQL
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.
The following versions of Navision are supported
- Microsoft Dynamics 365 Business Central (Microsoft Dynamics NAV 2017)
- MS Dynamics NAV 2016
- MS Dynamics NAV 2015
- MS Dynamics NAV 2013
- MS Dynamics NAV 2009 (also R2)
System requirements
- RapidiOnline will take up 1 session (user) on MS SQL Server when running transfers.
- You might need additional Web Access or External access licenses from Microsoft - please check your license conditions for this.
Considerations
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.
Additional Installation
Installing the RapidiConnector
MS Dynamics NAV Client Installation & Configuration
- You need to have an MS SQL Client installed on the computer/server where the RapidiConnector is installed. The SQL Client is automatically installed if you have an MS Dynamics NAV client installed so this is recommended.
Rapidi Configuration
The fields on the MS Dynamics NAV SQL Connection should be filled in as follows:
- Description: Enter a text describing the Data Source.
- Server Connect: Specify the name of the SQL server hosting the NAV database.
- Database: Specify the name of the SQL database.
- Account: Enter the NAV Account/Company name here. PLEASE NOTE: Account is CASE SENSITIVE.
- Use Windows Authentication: If you use the same UserID and Password to access the database as for when logging on to your Windows, you can mark this field. Please note that it is the windows user that you installed and run the RapidiConnector under, that will be used. If you do this then the fields UserID and Password are ignored.
- UserID: If you are not using Windows Authentication above, then specify the UserID here.
- Password: If you enter a UserID the corresponding Password is applied here.
NOTE: If you have multiple ODBC drivers installed, you would need to specify the ODBC driver name in the connection string in the field Server Connect. The connection string would be the following:
Server Connect: ODBC Driver=ODBC Driver 12 for SQL SERVER; SERVER=SQLTest02.
Copy, Test, Activate Changes and Read Design
Copy Connection
Connection Test
Activate Changes
Read Design