Knowledge Base
Creating an ODBC Bulk Data Source
Browse Common Categories
- Setting up a Dynamics CRM Connection
- Setting up a Dynamics CRM Connection
- Creating a Dynamics CRM Bulk Data Source
- Creating a Dynamics CRM Change Data Source
- Creating a Dynamics CRM Real-Time Data Source
- Setting up an Integration to Dynamics CRM
- Using an Entity Lookup
- Using an Entity Lookup
- Using an Activity Party
- Using a Multi Lookup
- Using a List Option Lookup
- Using a Relationship
- Using a MultiList Option Lookup
- Connecting to Dynamics 365 Business Central using an OAuth Token
- Creating a Dynamics 365 Business Central Bulk Data Source
- Creating a Dynamics 365 Business Central Change Data Source
- Creating a Dynamics 365 Business Central Real-time Data Source
- Setting up an Integration to Dynamics 365 Business Central
- Using an Odata Field Lookup
- Using an Entity Lookup
- Using an Activity Party
- 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
- Creating a Dynamics CRM Bulk Data Source
- Creating a Dynamics CRM Change Data Source
- Creating a Dynamics CRM Real-Time Data Source
- Setting up an Integration to Dynamics CRM
- Using an Entity Lookup
- Using an Activity Party
- Setting up a Dynamics CRM Connection
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
- Using a MultiList Option Lookup
- Setting up an ODBC Connection
- Setting up an OLEDB Connection
- Creating an ODBC Bulk Data Source
- Creating an OLEDB Bulk Data Source
- Troubleshooting ODBC Data Source Errors
- Creating a REST Service Definition
- Adding a REST Service Connection
- Configuring OAuth2 Authentication
- Configuring Exchange Token Authentication
- Creating a Service Data Source Definition
- Adding a Bulk Service Data Source
- Configure Data Source Paging
- Creating a Service Destination Definition
- Setting up an Integration to a REST Service
- Creating a Service Lookup
- Configuring Service Entities for Data Sources
- Configuring Base Settings
- Using a Service Lookup
- Using Service Variables
- Using Error Handling
Creating an ODBC Bulk Data Source
- On the left side options column click Data Sources >> Bulk Sources >> Query.

- On the Query Data Sources page click Create Bulk Query button.

- On the New Query Data Source page click the ODBC Query Data Source button.

- The page to configure the ODBC Data Source opens.

- Enter a Name for the query.
- Connection – Select the connection to be used from the drop-down list.
- Click Validate. If the validation is successful, the Edit Query button becomes active.
- Click Edit Query – Opens the Query Builder to create a new query or edit an existing query.
Support