This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).
SmartConnect provides an alternative to Integration Manager, which is part of the Microsoft Dynamics GP Customisation Pack. While Integration Manager allows users to create and run integrations on an ad hoc basis, SmartConnect provides much more functionality, such as the ability to schedule integrations, poll a folder to load all files within and load data from many different data sources including Excel spreadsheets, transform data and provides a web service which can be called from any application.
There are three types of integration which can be created in SmartConnect:
- Bulk Data Sources – Bulk data sources are configured to look at fixed data locations (such as a particular file or folder). The SmartConnect Scheduler can be used to define a schedule on which bulk data source integrations should be run.
- Change Data Sources – A change data source will track all data changes since the map last ran successfully; based on the schedule, it will execute a SmartConnect map to integrate the data.
- Real Time Data Sources – Data is integrated in real time from any Microsoft Dynamics GP window or direct from Dynamics CRM to any destination.
Continue reading “Implementing SmartConnect: Introduction”