Introduction to DataSync

DataSync allows you to merge data from different sources (Oracle, Saleforce, etc.) into a data warehouse (such as SQL Server).

Important

In order to work properly, an active internet connection is required for DataSync to remotely communicate with the Nectari License server.

DataSync works under the principle of ETL.

ETL or Extract, Transform and Load are processes with which you can perform tasks from databases. In this case:

  • Extract (or read in other words) consists of collecting data from one to different types of sources.
  • Transform consists of converting those extracted data into the format it needs to be through the use of tables in order to be processed in the data warehouse.
  • Load (or store in other words) consists of writing the converted data into the destination database.

Use DataSync to migrate and consolidate your data easily and take benefits from the Nectari cloud server for its speed in dealing with query requests.