Ever found yourself struggling to get data in and out of Salesforce?
With Data Sync you can do this within a few easy steps. To export data simply connect to Salesforce, connect to a target (for example this can be a new SQL table from our quick-start functions.) Map your columns, compare and sync. To import just swap your connections: Connect to your source, connect to Salesforce as your target, map the columns, compare and sync.
Take your data further and add lookups to other applications to enhance your Salesforce Data.
You can create a lookup just by dragging and dropping the source onto your connecting column, and then map the fields to your Salesforce objects.
Why not also transform your data with calculated columns, so that it is in the right format from the start. You don't need to edit your source data before starting: Work with what you have, to get what you want.
Moving from an old system to Salesforce?
With Data Sync you can move your data in a matter of minutes. We've done all the hard work, so all you need to do is figure out how you want your data mapped and to configure the project.
It's as simple as Connect, Map, Compare and Sync.
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.
Make use of our preview buttons to check that the data has been correctly loaded from your source and target. You may even want to use these to check what data is available.
When you compare, you can view the data changes that are going to be made before you sync. Adding another layer of security and piece of mind that it will be right.
Once you've run your sync, either preview the target data to verify that the data was successfully synchronised, or run the compare again (if it worked you'll see 0).
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 we will send you a renewal reminder with a link to renew. Alternatively you can purchase a new subscription to continue using the product.
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 email us at support@simego.com to create a ticket and one of our support team will get back to you.
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 we aim to get back to you within 3 hours.
Where do I go if I have more questions?
If you have any general questions please contact us at hello@simego.com or for sales related questions please contact us at sales@simego.com .
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.