Once you start using data sync your ability to deliver integration will multiply. Data Sync comes with a complete set of connectors: ODATA, Microsoft SQL Server 2000-2012, Microsoft SQL Azure, Microsoft SQL Compact 4.0 Microsoft Access 2000-2010, Microsoft Excel 7-2010, Microsoft Active Directory, Microsoft Exchange Server 2007-2010, Calendar Entries, Contacts and Tasks, Microsoft Dynamics CRM Server 4.0 (On-Premise) Entities Microsoft Dynamics CRM Server 2011 (On-Premise and Online) Entities Microsoft SharePoint Server 2007-2013 (Lists and Documents), CSV Files, Podio, XML Files, SOAP 1.1 Web Services, Oracle Database, My SQL 5.0 Database, Any ODBC Data Source, Any OleDB Data Sources
The key to an accurate and successful integration is quickly understanding 3 things:
1. What data is currently in the source system?
2. What data is currently in the target system?
3. How is the integration going to transform the source data and what changes will it make to the target?
Data Sync studio has specifically been designed to visually show you the source data, the target data and the transformation impact in real-time! This allows you to quickly make changes without guessing what the impact on the target system will be.
There is always a point where simple lookups and excel type functions run out of steam to complete that last but essential 10% of your integration. You can now break out Data Syncs 'Dynamic Columns'. Essentially you now have the full power of Microsoft .net development framework to compose new columns including Encryption,Decryption,Translations,Screen Scraping,Image processing etc etc.
With the power of the Full Microsoft .NET 4.0 Framework available including a development and integration environment nothing cannot be transformed.
Computer systems live and breathe on using identifiers and lookups. It may be the ZIP code of a company or the Account Manager of a Supplier but Data Sync can reach into that system and find it for you.
A data sync lookup can be based on any of its connectors. So you can look-up a company name in Microsoft CRM whilst writing tasks into Sharepoint from an Exchange tasks list. This is all possible whilst still using the real-time source preview, target preview, update preview abilities of Data Sync.
Once you have data sync project just right, you can then use the included automation 'Run tool' to make it run seamlessly without your intervention. There are several easy to define steps making data sync + Run tool indispensable to your business processes: