Import, Export and Integrate Data from Microsoft Dynamics CRM, Sharepoint and other Database systems


 

Work with the data you want to.

 

Achieve more, together. Escape migration pain and integration chaos with DS3.

 

  DOWNLOAD


Perfect Fit Business Data Import, Export and Synchronisation

  • Advanced Windows application fits perfectly into your IT systems (64 and x86).
  • Implementing a import/export takes minutes and can easily be changed later. 
  • Industry leading transformation capability that allows you to use the full .NET framework.
  • Simple lookups make importing easy.
  • 'Run Tool' included for no-touch scheduled imports/exports.  
  • Fourtune 500 companies and 4000+ users use Simego's solutions to master their data daily.
Import and Exporting data from CSV to Microsoft SQL Server

Connectors for Dynamics CRM 2011, Online, Sharepoint, MS SQL Server, Podio

A complete set of connectors for your systems

Once you start using data sync your ability to deliver integration will multiply. Data Sync comes with a complete set of connectors:  ODATAMicrosoft SQL Server 2000-2012, Microsoft SQL Azure, Microsoft SQL Compact 4.0 Microsoft Access 2000-2010, Microsoft Excel 7-2010, Microsoft Active DirectoryMicrosoft 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


Visual mapping and real-time 'Data + Transformation Preview'

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.

Updating Data in a CSV file from a Microsoft SQl Server products table

Unrestricted Transformation with Dynamic Columns

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.


Lookup data in other systems

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.


No -Touch Automation

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:

  • Send Email based on Success or Failure
  • Run a SQL Command
  • Run an external windows application
  • Download/Upload/Copy/Delete File
  • Logging to Windows Event Log
  • Schedule via Windows Task Schedular

"This is the swiss army knife of data synchronisation which offers great value, flexibility and top notch support."

Simon Jackson, Technical Director at Prosperity247

inRecommend