Data Synchronisation Studio Feature Tour
A visual tour of Data Synchronisation Studio's features with screenshots
Connect to Microsoft Dynamics CRM Online and On-Premise
Connect Data Sync to your Dynamics CRM Entities supporting both built in Entities like Accounts and Contacts as well as Custom Entities.
Data Sync can also connect to Option Sets and N:N relationships
For Dynamics CRM Data Sync supports options for Batching and Threading to maximise the Import performance.
Connect to Microsoft SharePoint and SharePoint Online
Connect Data Sync to SharePoint Document Libraries and Lists. Import Files from the File System or Import and Export Data to SharePoint Lists from SQL Databases or other Data Sources.
Connect to SQL Databases
Connect Data Sync to your SQL Databases with support for Microsoft SQL Server, SQL on Azure and other Databases like MySQL, Oracle, Postgres via ODBC and OleDB support.
Connect to Excel, CSV, XML and more
Connect Data Sync to many Text based file formats.
CSV and XML supports Wild cards so multiple documents can be combined together.
CSV files can also be read from Http endpoints.
Data Sync can connect to many other systems such as Active Directory, Exchange, OData, Azure, Amazon and Podio where Data Sync does not have a connector you can also build your own with Microsoft.NET and our Connector SDK.
Design the Mapping relationship between the two systems, transform your Data with Lookups, Calculated and Dynamic Columns, Preview the Data and Test the Integration.
System Schema Mapping
Create the Mapping between the two systems with our rich designer with support for Drag and Drop.
Map the Columns from the Source to the Target and choose the Data Type. Data Sync automatically provides Data Type conversion based on the type.
Select the Key Column(s) that define the record identifier and Data Sync automatically creates the ADD/UPDATE/DELETE actions based on the Key selection.
Create 'New' Columns
Use the Calculated or Dynamic Columns features to add new Columns to the row based on calculations, transformations, lookups or static values.
Calculated Columns allow you to apply EXCEL like functions in a NO-CODE scenario, where as Dynamic Columns provide all the power of the Microsoft.NET Framework and C# to build columns based on your data.
Compare the data between the two systems
Data Sync's power comes from the powerful Data Comparison Engine battle tested over many years. When you compare your Data the data is loaded from each system and compared on a Field by Field basis. Data Sync then produces a Change Set to make the target match the source.
The Data Sync comparison engine is fast uses little system memory and can load many millions of rows.
Preview the results before making changes in data
Before any changes are committed to the Target System you can review all the changes visually and selectively choose which changes to apply.
Synchronise your change set
Once you have your Change Set you can Synchronise the Changes with the Target right within Data Sync with real-time progress feedback and the control to stop the synchronisation.
Any Errors or Messages from the Target are listed in the Log window.
Data Sync also features a Project Automation capability where you can hook into the process at different points and write your own Microsoft.NET C# code to control the flow or implement specific requirements.
Ouvvi is your Operations Management Centre, from Ouvvi you upload your Integration Projects and then define the Execution Schedule and Monitor the Integration over time.
Ouvvi supports multiple instances where you can create multiple isolated Ouvvi instances on a single server for individual line-of-business separation or to create isolation between DEV/UAT/PROD.
Create Projects and Steps
Ouvvi projects contain multiple steps, each step can be a Data Sync project or one of the many in-built step types.
Each Step is executed in a Sequence with Flow Control to handle Errors.
The Project can be run manually or Triggered via a Schedule or other External Events such as a Data Change in an External System.
Projects run in Parallel and can be defined so that only one instance is ever running to prevent projects running over each other.
Multiple step types for end-to-end integration
Ouvvi has many different step types to allow you full control of your integration and execute different tasks as part of the project execution.
Create your own Step Types in Microsoft Visual Studio with the Ouvvi SDK.
Real-time monitoring of all integration projects
Each Project Execution is linked to a specific instance run and you can visually see the results from the Reporting Dashboard.
The length of the block defines the duration of the project relative to all the other projects in the report.
Any Errors are displayed as Red blocks and you can link directly to the Log for the Error from the Dashboard.
Quickly review how integration projects are progressing
The Reporting Dashboard also shows the performance over-time of your integration projects and steps allowing you to see how everything is running.
Define Date and Time Schedules to reliably execute your integration Projects.
Triggers can also be defined to look at external Data sources and create a Trigger based on time changes for real-time synchronisation scenarios.
Create your own Triggers in Microsoft Visual Studio with the Ouvvi SDK.
Review Logs for each Project Execution, each Step Execution is listed with a Start Time, End Time and Duration. Any Error from the Steps are shown in the Log and this all links back to a specific execution run.
The Logs are stored in the Ouvvi SQL Database which can also be queried for further analysis.
Ouvvi maintains a copy of each step configuration, when changes are made a new version is created automatically.
You can review the history, open and restore previous versions.
Ouvvi can be used to Document your Integration processes, the Output Documentation details the Projects, Steps and Data Sync Mappings of the Individual Data Sync projects.
Documenting each project and step in your Ouvvi environment enables comprehensive reference documentation to be output for regulatory or audit compliance.
Ouvvi is deployed as a Web Application in IIS 7.5+ requires a Microsoft SQL Server 2008+ Database and uses a Windows Service to run your projects. Ouvvi Users are authenticated via Windows Integrated Security, read-only users can view and run projects.
"Complex, complicated and difficult ... are other tools. Not Data Synchronisation Studio! It is intuitive, impresses with its flexibility and simplified our lives in the construction of many complex interfaces. If time is money, then the Data Synchronisation Studio is worth every penny to save your money and to give you more free time."
"We have used Data Synchronisation Studio now for a number of years, bringing together all our LOB information systems. It is now central to our data information gathering and can honestly say we could not have done without this product"
"It's very easy and quick to get results with Data Sync Studio and the price is right. I use the CRM 2011 and SQL connector to interface between ERP and CRM and have tested the SharePoint integration as well. Super tool for batch interfaces. "
"Our organization has complex business rules that most companies would charge tens to thousands of dollars to work out for us in the background. We were introduced to Data Sync from Simego and this is one of the BEST tools we could have asked for. Not only is the product fast and easy to use but also our 'non-tech' people can use it. In a short few words, Data Sync has made advancements in our organization that has saved us a great deal of time, effort and money. "