Knowledge Base
Setting up an Integration to Dynamics NAV OData
Browse Common Categories
- Using a Restriction
- Adding a Run Map Task
- Adding an Email Task
- Defining Remaining Options
- Using a Custom Rolling Column
- Using a Translation
- Using a Date Calculation
- Using a Calculation
- Performing the Field Mapping
- Determining Source Grouping
- Defining an Integration Target
- Defining an Integration Source
- Populating the Integration Details
- Using an OData Field Lookup
- Setting up an Integration to Dynamics NAV OData
- Creating a Dynamics NAV OData Bulk Data Source
- Setting up a Dynamics NAV OData Connection
- Using a MultiList Option Lookup
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Lookup
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics CRM
- Setting up a Dynamics CRM Connection
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Using a Relationship
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using an Odata Field Lookup
- Creating a Dynamics 365 Business Central Change Data Source
- Creating a Dynamics 365 Business Central Real-time Data Source
- Setting up a Dynamics 365 Business Central Connection
- Connecting to Dynamics 365 Business Central using an OAuth Token
- Using a Page Field Lookup
- Using a Page Key Field Lookup
- Setting up an Integration to Dynamics 365 Business Central
- Creating a Dynamics 365 Business Central Bulk Data Source
- Using an Activity Party
- Using an Entity Lookup
- Connecting to Dynamics 365 Customer Engagement using an OAuth Token
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Setting up an Integration to Dynamics 365 Sales
- Creating a Dynamics 365 Sales Real-Time Data Source
- Creating a Dynamics 365 Sales Change Data Source
- Creating a Dynamics 365 Sales Bulk Data Source
- Setting up a Dynamics 365 Sales Connection
- Using an Entity Reference
- Using a MultiList Option Lookup
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics CRM
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
Setting up an Integration to Dynamics NAV OData
1. Click on the Target tab.
2. Target – Select Microsoft Dynamics NAV OData.
3. Destination – Select a Dynamics NAV OData connection.
4. Company – The default company will automatically be set, but any company can be selected.
5. Entities to Process – Select the name(s) of the web service(s) to be used.
6. Include linked entities – Mark to include any entities that are linked to the ones selected.
7. Run to file – Mark to have data send to a file instead of the destination.
8. Target Lines – Displays the lines that will be available to be mapped on the Integration tab.
9. Once the required fields have been populated the Integration tab becomes active.
10. Click on the Integration Tab.
Integration Tab
1. Target Lines – From the dropdown list, select the lines that will be mapped.
2. For Delete – When this checkbox is marked, records from the destination that are in the source will be removed.
3. Update Existing – When this checkbox is marked, records that already exist will be updated with any changes.
4. Update Blank Data – When this checkbox is marked, data that is blank in the source will update the corresponding records in the destination to blank if the destination record has data.
5. Source Grouping tab – Select which source(s) to group by and the function for the source.
6. Target Integration tab – This is where the Source data is mapped to the Target data.
7. Additional Columns tab – Note: there will be a separate section for each type of Additional Column.
8. Once the Target field(s) are mapped to a Source(s), the Save button becomes active allowing the user to save the Integration Process.