Use of NAV Source Component

The NAV Source Component is an SSIS data flow pipeline component that can be used to read / retrieve data from the Microsoft Dynamics NAV server.

The NAV Source Component includes the following two pages to configure how you want to read data from Microsoft Dynamics NAV.

  • General
  • Columns

General page

The General page of the NAV Source Component allows you to specify the general settings of the component. 

NAV Source Editor

NAV Connection Manager

The NAV source component requires a NAV connection in order to connect with the Microsoft Dynamics NAV server. The NAV Connection Manager option will show all DynamicsNAV connection managers that have been created in the current SSIS package.

Batch Size

The Batch Size option allows you to specify how many records you want to retrieve each time. The default value is 2000. For performance reasons, this parameter should not be too small.

Source Object

The Source Object option is only available after a NAV Connection Manager is selected. After you select a NAV Connection Manager, the component will retrieve a list of all available NAV pages & objects.

NOTE : You will only be able to see those page objects that you have enabled for integration. If you don't see a page object in the list, you would have to add a new Web Service entry for that page object in Dynamics NAV application by going to Web Services module.

Page Filtering

The Page Filtering text box lets you specify filter criteria to help retrieve only the records you specify. The following is a sample of such filter.

<filter>
	<Field>Name</Field><Criteria>ABC*</Criteria>
</filter>
<filter>
	<Field>AccountNumber</Field><Criteria>C002*</Criteria>
</filter>

Please see http://msdn.microsoft.com/en-us/library/hh879066(v=nav.71).aspx for more info on NAV filters.

Page Filtering now supports the use of User and System Variables. Simple select a variable under the Insert Variables drop down menu, and a placeholder value will be inserted into the filter text.

Supplementary Parameters

When working with specific object, there may be special parameters required in order to read from these objects (ex. General Journal object). These input values will be specified in the Supplementary Parameters area. The general format looks something like this:

<CurrentJnlBatchName>CASH</CurrentJnlBatchName>

Refresh Component Button

Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.

Columns page

The Columns page of the NAV Source Component shows you all available columns from the object that you specified on the General page. 

NAV Source Editor