Back in 2007 I was working as a Software Consultant in Jersey building solutions connecting SQL Tables to SharePoint Lists. It was painful boring and a slow process. I found that the work I was involved in with each client was very similar yet we had to build from the ground up each time which which was costing our clients both time and budget even for the smallest of jobs. This is when Data Sync V1 was born to facilitate data integration between SharePoint and SQL via configuration rather than code development.
Everyone at the time was either building giant spaghetti workflows with decision based logic in SSIS or other tools. Or they're paying developers/consultants to build the same integration code time and time again. This can be expensive and unreliable and a real headache when you come back a few months later to fix an issue or extend the requirements.
Data Sync was built to make Data Integration easy and without complex installation or changes to systems which you connect (looking at you change control). By using a Data Compare and Sync method we can eliminate most of the decision logic required to insert and update existing data.
By leveraging Data Sync for your Data Integration you get software which has been in use across 100s of customers for many years and proven to be both reliable and robust. You’re also getting software which has been continually developed over 15+ years all for the low annual subscription fee.
You don't need to be a Developer to use Data Sync its approachable for both Technical and non-Technical users alike. Data Sync is used by Company Owners, DBAs, Business Analysts, Project Managers, Consultants, Developers and Support Engineers.
We're not trying to take over the world here with Data Sync just work with companies that share our view that Data Integration doesn't need to be complex, expensive and something only large enterprises can afford. Together we can help each other I can offer you a comprehensive Data Integration Solution and great support in exchange for an annual subscription fee.
Analyze your potential Cost Savings: Compare hiring a Developer/Consultant @ $200/Day for 5 Days or Data Synchronisation Studio for 1 Year.
Use the Data Sync IDE to craft your Data Integration project and perfect your integration
Connect to Files, SQL, SharePoint, Dynamics, Office 365 and many other data sources
Import your data from various Data Sources quickly and easily. Apply Schema Mapping and Data Type conversion on the fly and Export your data to various formats.
Compare your Data with the target Dataset and create a difference Change set of ADD, UPDATE and DELETE actions to apply rather than drop all data and re-import.
Preview all your data before any changes are applied and select which data you wish to change. Prevent those Oops moments!
Simple and Complex transformations via Calculated Columns, Dynamic Columns and Lookup features.
Use powerful Lookups to lookup data in other Data Sources, Create Mapping Transformation tables and more.
Manage your connection configuration via the Connection Library and quickly and easily connect to data sources from the library.
Automate the execution of your Data Synchronisation Studio packages with Ouvvi, Task Scheduler, SQL Agent, Command Line or API.
Use the .NET Framework to create your own powerful Data Transformation Expressions. Execute your own code before and after the project runs and more.
Use Project Automation to hook into the process and run custom code.