MS Dynamics NAV SQL
MS 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 WebService.
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 RapidiOnline 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)
- 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 you license conditions for this.
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 WebService.
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.
- In order for RapidiOnline to connect to your local database server, you need to download and install a small service, that we call the
MS Dynamics NAV Client Installation & Configuration
- You need to have a MS SQL Client installed on the computer/server where the RapidiConnector is installed. The SQL Client is automatically installed if you have a MS Dynamics NAV client installed so this is recommended.
The fields of the MS Dynamics NAV SQL Data Source Card 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.
Test and Read Design
- You can Test that the access to a Connection works using the Test button on the Connection.
- Login to MyRapidi. Click the
- Read Design is the way to read the layout - the information about tables and fields - from a Connection. Reading the design is