With Data Sync you can quickly and easily import your data into SQL tables from other sources. Whilst your importing new data you can also update any records you may have in your table already.
Make use of the full provider list to connect to all your business applications.
Got multiple jobs that need running again and again? Use the Run Tool or Ouvvi to automate the process whilst logging how your projects are running.
Need to get data out of your SQL tables? With Data Sync you can have your data exported within a moments.
Export your data to another business application or simply export into a CSV, XML or Excel file.
You choose how you want it, we make it happen.
Use Data Sync to enhance existing SQL Tables with data from other data sources.
Use lookups to pull in useful data within the same project from multiple sources, to expand your dataset in one go.
Make use of the calculated column functions to apply data transformation to make batch changes to existing data, so you don't have to edit rows one by one.
Data Integration is an iterative process and in an ideal world you should be able to see the data changes before they happen.
With Data Sync you start with the basics and then build on that, updating more data as you go rather than trying and failing to get it right on the first run. With Data Sync you can just as easily update existing data as you can add new records.
The SQL Query Tool built in to Data Sync enables you to run SQL queries on your MS SQL Server, MariaDB, MySQL and PostgreSQL Databases directly from Data Sync.
Make edits to your SQL table or database without having to hop between applications.
The tool also allows you to preview the data in your tables and directly edit it from Data Sync.
Don't waste time creating a table from scratch, adding in all the columns you think you need.
With Data Sync's quick start function you can create a new SQL table based on your source data. So everything you want included is added straight away.
But don't worry if you need to make edits: Add any columns you need to the table and just refresh the connection.
Any reasonable Data Integration project needs the ability to schedule and automate each project so that you don't need to be there.
Data Sync comes with the ability to schedule and run tasks built in. The Run Tool make use of windows task scheduler, and is great for small integration projects.
However, it's likely you want to run more complex integrations and for those we bring you Ouvvi. Ouvvi provides the ability to set triggers on each of your projects. These can be time based triggers, to run on your schedule, or event based so that your project runs every time there is an update to your system.
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.
What is a Server License?
A server is where you would normally install Data Synchronisation Studio and Ouvvi, as there are no limits to the number of external systems you can connect to from a single server. A server license can be activated on 1 machine/server and can be used by a maximum of 2 concurrent users on the same machine at a time.
Is it a requirement that Data Synchronisation Studio (Data Sync) and Ouvvi are installed on a server?
No, Data Sync can be installed on a workstation/local machine and Ouvvi can be installed on Windows 10 Pro if you do not have a server.
What happens at the end of the subscription?
At the end of the subscription simply purchase a new subscription to continue using the product. We will send you renewal reminders nearer to the time so then you know when the license is due to expire.
How many instances of Ouvvi can I have per Server?
You can run 3 instances of Ouvvi per Server.
What is a Server Plus License?
A server plus license is the equivalent of 3 Server Licenses. You can activate Data Sync and Ouvvi on 3 machines/servers.
Where can I find information on how to connect to my various data sources?
You can find the technical documentation on the products at our documentation site which can be found here.
Where can I find training for how to use Data Sync?
You can find our training for Data Sync here. If you have never used the software before it is best to start here to get you familiarised with the product and it's features.
Where can I find training for how to use Ouvvi?
You can find our training for Ouvvi here. If you have never used the software before it is best to start here to get you familiarised with the product and it's features.
Where do I go for technical support?
If you need any technical support, please visit our helpdesk and create a ticket and one of our support team will get back to you. You can access our helpdesk here.
How long does it take to hear a response?
We guarantee to get back to you within 1 business day. However, during UK working hours our typical response time is 30 minutes.
Where do I go if I have more questions?
If you have any general questions please contact us at firstname.lastname@example.org or for sales related questions please contact us at email@example.com .
I want to try the product. Can I try before I buy?
Yes! We have a 14 day free trial you can activate and use which is available here. After the 14 days this will turn into a monthly subscription and can be cancelled at any time.
How do I get a copy of the software?
You can download Data Sync and Ouvvi at our download page.
Can you see my data I am moving?
No, as the software is installed on your own network only those with permission can view your projects and data. Simego does not have access to any of your systems and so cannot view any of your data.