DataSync

DataSync is a powerful Extract, Transform, Load (ETL) tool that lets you seamlessly merge data from multiple sources—such as Oracle, Salesforce, and other databases—into a centralized data warehouse, such as SQL Server.

By consolidating data from across your organization, DataSync helps ensure accuracy, consistency, and accessibility for analysis and reporting. It streamlines data migration, supports large-scale integration projects, and enables you to make better business decisions from a single, reliable source of truth.

Built for performance, DataSync leverages the SEI cloud server to process queries at high speed. Its modular design allows you to automate tasks, apply transformations, and manage data flows without manual intervention, saving time and reducing errors.

Prerequisites

• Install and configure DataSync before you can use it.
• Maintain an active internet connection so DataSync can communicate with the SEI license server.
• Register at least one user account to allow sign-in.

How DataSync works

DataSync follows the ETL (Extract, Transform, Load) process to manage data efficiently:

• Extract to collect data from one or more types of sources.
• Transform to convert extracted data into the required format by using tables so the data can be processed in the data warehouse.
• Load to write the transformed data into the destination database.

Benefits of DataSync

• Consolidating data: Integrate data from multiple heterogeneous sources into a single repository.
• Optimizing performance: Improve query response times by using Nectari’s cloud processing power.
• Automating tasks: Schedule and run recurring data extractions without manual intervention.

Modules in DataSync

With DataSync, you have access to modules that let you extract, transform, and load data to meet your analysis needs. When inside any module, use the left pane to switch between features without returning to the home page.

Module	Description
Connections	Create, configure, and manage source and destination connections to be used in extractions.
Extractions	Define and manage mappings between a source and a destination, including optional transformations.
Scheduler	Schedule extractions to run automatically, either as full reloads or incremental updates.
Variables	Create and manage global variables for use across connections, extractions, and transformations.
Transformations	Apply transformations to modify imported data for migration, consolidation, or formatting before loading.
Logs	View execution logs, including detailed error and status information for scheduled or manual tasks.
Settings	Configure application-wide settings such as user management, SMTP, and other system preferences.

Scenario

You can follow this process, or the steps in the installation guide for your specific template.

1. Source connection - Create source connections.
2. Destination connection - Create destination connections.
3. Extraction - Add or import the extractions.
4. Tables - Add, edit and remove tables.
5. Indexes - Create indexes for optimized query performance.
6. Fields - Add fields to tables.
7. Validate and Build - Validate configurations and build the extraction job.
8. Run - Execute the extraction.
9. Scheduler - Schedule extractions for automated runs.

You can optionnally create variables, apply transformations, and export an existing extraction.

Server time synchronization

If DataSync is not installed on the same server as your ERP application, ensure that the time (minutes and seconds) is synchronized between both servers.

If there’s a mismatch, use the Time Offset feature (in seconds). Enter a value greater than the time difference to ensure optimal data retrieval during an Incremental Load task.