Data Sources

<< Click to Display Table of Contents >>

SmartConnect 2017

Data Sources

SmartConnect can draw data from a number of different sources.

 

The data sources used by SmartConnect can be divided into three base groups:

•Bulk Data Load - loading data from a source that contains a quantity of data.
•Changes Only - loads only the changes in the data since the last integration run.
•Real-Time Event - user action triggers an integration using the data that has been added, edited or deleted.

 

 

The Dynamics GP data source information has been divided into the following topics:

 

SmartConnect Data Sources

Bulk Data Load

•Extender Bulk Data Source
•Folder Data Source
•InfoPath XSD
•Microsoft Dynamics CRM Query
•Microsoft Dynamics GP Query
•Microsoft Dynamics GP Service
•Microsoft Dynamics NAV
•Microsoft Excel 2003
•Microsoft Excel 2007
•Microsoft Excel 2010
•Microsoft Excel 2013
•Microsoft Excel 2016
•Multi Data Source
•ODBC Data Source
•OLEDB Data Source
•Salesforce Query
•SmartList Data Source
•Text file
•Web Service Query
•Xero Query
•XML
•XML Query

 

Changes Only

•Extender Change Data Source
•Microsoft CRM Change Data Source
•Microsoft Dynamics GP Change Data Source
•MSSQL Table Change Data Source
•Salesforce Change Data Source

 

Real-Time Event

•Extender Real-Time Data Source
•Microsoft CRM Real-Time Data Source
•Microsoft Dynamics GP Real Time Data Source
•MSSQL Real-Time Data Source
•Salesforce.com Real-Time Data Source

 

Change Data Source Maintenance