Data Synchronisation Studio

Data Synchronisation Studio is a powerful application for publishing business data directly to SharePoint Lists from variety of Data sources such as SQL Server Tables and Views, Oracle, MySQL, Active Directory and Exchange Server.

Import and Export data between multiple Line-of-Business Applications such as SQL Server and SharePoint without making system or configuration changes to these systems.

Quickly and easily publish LOB Data to your SharePoint Environment with no configuration changes (no webparts or solutions to install). Data Synchronisation Studio uses SharePoint’s public Web Services to read and write data therefore we can update remote hosted SharePoint as well as on-premise SharePoint installations.

Experience full SharePoint list functionality, custom views, filtering, grouping, search, workflows etc.   Whereas other technologies such as the BDC or BCS limit your SharePoint list capabilities once they are connected to your data sources.

Very Fast change detection via a custom Synchronisation engine capable of working with large datasets. Our Synchronisation Engine detects column level changes and only applies these individual changes to the target data source eliminating downtime on the destination system.

Use Data Synchronisation Studio as a Migration Tool to compare and synchronise data between LOB systems. Detect column level changes and select rows to apply to destination system.  

Directly connect to SQL database Tables, Views or for the ultimate flexibility specify your own SQL Queries.

Schedule automatic updates via Windows task Scheduler, SQL Agent or for more advanced workflow use Ouvvi to manage multiple synchronisation schedules with multiple steps, RSS Reports  and Notifications.

Easily connect multiple data sources

• Microsoft SQL Server 2000-2008 R2
• Active Directory User Accounts
• OLEDB Data sources
• ODBC Data sources
• Oracle Databases
• SOAP 1.1 Web Services
• Simple Http Services (CSV Data)
• CSV Files (CSV, TAB)
• Access MDB Files
• Microsoft Excel 2003 and 2007 Format Files
• SharePoint Server Lists 2007-2010
• SharePoint Document Libraries 2007-2010
• File System Directories
• Exchange Calendar Entries 2003-2007
• Exchange Tasks 2003-2007
• Exchange Contacts 2003-2007
• OData (read/write) (Experimental in Beta build)
• .NET Xml DataSet (read/write) 

Additional Tools

• Create Microsoft SQL Server Databases Tables directly from source data schema.
• Create SharePoint Lists automatically from source data schema
• Add additional columns to SharePoint Lists (includes data types not possible from SharePoint UI).
• Export data as CSV, Excel or XML
• Create Test data by using the Data Obfuscating feature 

Examples

• Import/Export Data between SharePoint and Microsoft SQL Server
• Import/Export Data between SharePoint and MySQL Server
• Import/Export Data between SharePoint and Oracle
• Import/Export Data between Microsoft SQL Server and Oracle
• Import User Data from Active Directory to SharePoint
• Import Exchange Calendar Items to SharePoint, SQL Server, Oracle or MySQL
• Import Exchange Contacts to SharePoint, SQL Server, Oracle or MySQL
• Import Exchange Tasks to SharePoint, SQL Server, Oracle or MySQL

Solutions

• Create an Intranet Staff/Telephone Directory with SharePoint and Active Directory. Data Sync Studio Synchronises the Data between the two systems and can also be used for self service Active Directory Account updates.
• Assist migrations to SharePoint from Legacy Systems by Synchronising the Data between the systems.
• Use SharePoint Workflows with your Business Data.
• Export Data from SharePoint for Reporting purposes.
• Expose your data to SharePoint for Easy Update Maintenance.
• Quickly Publish Data to SharePoint and then Synchronise back later.
• Quickly and Easily keep multiple systems in Sync such as DEV, UAT and LIVE.
• Quickly and Easily import large result sets of Data to SharePoint without manual input or custom development.
• Publish MS CRM Views to SharePoint

Add-on Providers

Guides & FAQs