Knowledge Base
Creating a Dynamics NAV OData Bulk Data Source
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
Creating a Dynamics NAV OData Bulk Data Source
1. On the left side options column expand Data Sources, expand Bulk Sources, and click on Query.
2. On the Query Data Sources page click the Create Bulk Query button.
3. On the New Query Data Source page click the Microsoft Dynamics NAV OData Query button.
4. The page to configure the Dynamics NAV OData Query opens.
5. Enter a Description for the query.
6. Connection – Select the NAV OData connection to be used from the dropdown list.
7. Click Validate. If the connection is successful, the Company field becomes active.
8. Company – Select the company to be used from the dropdown list, this will activate the Services button.
9. Services – Click the Add Service button to select the name of the web service to be used in the query. A filter can also be applied at this time if the data needs to be filtered down.
10. After a service has been selected, the save and preview buttons will be enabled.
11. If multiple services have been selected, then click on Edit Query to join the services together.
12. Preview button – Allows the user to preview the data that will be returned with the query.
13. Click Save to save the query source.