Data Synchronisation Studio for Data Integration and ETL
Data Synchronisation Studio
- Data Synchronisation via Fast Reconciliation Data Compare Engine
- Automatic Data Source Schema Discovery
- Export to Flat Files
- Calculated Columns for NO CODE Transformations
- Connection Library with Drag and Drop
- Lookups via Drag and Drop and Calculated Column Expressions
- Dynamic Columns for Advanced Data Transformation with .NET C#
- Grouping Analysis Data Provider
- Write custom code to execute during the Sync process
- Create Custom Data Providers with .NET SDK
- SQL Server, OleDb, ODBC, MySQL, Oracle, Access
- Flat files - CSV, TXT, XML, RSS, Excel, Open XML
- Active Directory - Users
- Dynamics CRM - System and Custom Entities, N:N, OptionSets
- SharePoint - Lists and Document Libraries
- Amazon - S3
- Azure - Blob Storage and Table Storage
- Exchange - Calendars
- Exchange - Email Messages
- Podio - App Data, Space Members
- OData Protocol V2
- FX Rates
- Data Generator
Import + Export
Easily and Quickly Import and Export data from a variety of Data sources. Use the Import and Export functionality to convert data into different formats.
Supports many different systems SharePoint, Dynamics CRM, MS SQL Server, ODBC, OleDB, Podio, Exchange Server, CSV, XML, OData and many more.
Data Sync uses a powerful reconciliation engine to discover differences between systems. ADD/UPDATE/DELETE Actions discovered automatically by defining Unique Key Column(s).
The reconciliation detects column level changes and only sends the individual changes to the Target eliminating system downtime.
This makes it incredibly easy to synchronize data between systems without having to understand complex data synchronization requirements.
Data Sync uniquely offers a NO-CODE and for those who want it a CODE option.
Build Powerful Transformation Expressions with Excel like Calculated Columns.
Write .NET C# Code in the powerful designer when you need to create something really complex.
Data Migration + Integration does not need to be a Black Box, Data Sync displays the results of a Data Comparison right in the UI so you can easily see what Data Changes are going to be applied to the Target before it happens.
This Agile approach to integration gives your testers rapid feedback and reduces the cost of integration.
- Integration Project Management
- Connection Library Management
- Create multiple isolated instances
- Date and Time Scheduler
- Trigger based on External Events
- Version History with Restore
- Audit Project changes
- Read-Only Users
- Parallel Project Execution
- Automatic Retry on Failure
Ouvvi is Web Based and runs On-Site on a Microsoft Web stack including web server (IIS) and Database (Microsoft SQL). The familiarity with web interfaces reduces the training requirement and the Active Directory Authentication ensures security remains within your control.
The Automation Server is designed to scale redundantly across multiple servers and sites enabling Active-Active, disaster recovery scenarios and high performance distributed integrations.
The separation of Testing and Live environments ensure clean change control in combination with detailed Audit Trails.
Ouvvi manages the execution of your Integration Tasks via Triggers. These Triggers can be simple Time Based Schedules or Integration into other systems to detect changes when they happen and create near real-time data Synchronization.
Use the Powerful Reporting features to see quickly and easily the State of your Integration and Track down any problems quickly and easily.
Failures can automatically send emails to the correct operations team allowing for quick resolution. Detailed debugging logs are also retained linked to the execution instance for root cause analysis.
"Data Synchronisation Studio is a powerful data tool that my team uses every day and I have recommended to several other colleagues. Also, their technical support is excellent."
"Data Sync Studio made a huge difference to our integration and migration projects removing the need for expensive code writing. This is an essential in any software toolkit and highly recommended."
"This is the swiss army knife of data synchronisation which offers great value, flexibility and top notch support.It is completely reliable and easy to use"
"Great product. In two minutes I accomplished something I had been trying to do in SharePoint for ages!