Skip to content

Overview

Simple Data Integrator (SDI) is a data integration tool (ETL) , which extracts data from the source system, converts and processes it according to business requirements, and loads the processed data into a target system.

Same location

Multiple locations

On-premises, cloud and hybrid cloud are supported. While connecting to the cloud, it is possible to establish a secure link via the SDI web service without setting up a VPN.
Oracle, SQL Server, MySql, PostgreSql, DB2, ODBC, files (CSV, Excel , JSON) are supported. File systems, FTP/FTPS, SFTP, AWS S3, OCI Object Storage are supported for importing source files and exporting.
The scheduler is provided that lets you define the automatic data integration at a specific time.

Main functions

Data Integration

  •   Transfer data from the source DB table, view, query to target DB table.
  •    Import data from CSV, EXCEL , JSON file into the target database table.
  •    Export table, view, query data from the source database to CSV , EXCEL , JSON file.
  •    Execute SQL and Procedure .
  •    Workflow
  •    Result notification of the execution. (email or event)

Other functions

  •    Database availability monitoring
  •    Data monitoring and detection (detection of irregular data, data loss, inconsistency, etc.)

Scheduler

  •    Hourly, daily, weekly, monthly, repeat job execution.
  •    Execute multiple jobs in parallel or in serial.
  •    Retry function.

Features

1．Simple design, easy operation and powerful functions

Installation is complete with just a few clicks. Data linkage and scheduler setting are completed in just 3 steps.
It can handle everything from simple table mapping to complex queries and workflows.

2.High performance

Adopts architectures like parallel, in-memory, and compressed transfer to achieve high-speed data transfer.

3.Easily meet various requirements

It can handle any requirements such as on-premises, cloud and hybrid cloud.
While connecting to the cloud, it is possible to establish a secure link via the SDI web service without setting up a VPN.

4.High Availability

Cold standby and hot standby are supported.

Use case

Integration of data across internal systems

Integrate data in different formats between different systems.

Centrally managed data across multiple sites

Centralized data management and data utilization for companies with multiple sites.

Data linking between on-premises, cloud and multiple clouds.

Flexible connection design of data linking between on-premises, cloud and multiple clouds.

On-premises with cloud

Multi-cloud data linkage

Create and import CSV , Excel or JSON files regularly.

Create and import CSV , Excel or JSON files regularly. (File system , FTP/FTPS, SFTP, AWS S3, OCI Object Storage are supported. )

Database availability monitoring, data monitoring and detection

Database availability monitoring and data monitoring and detection(detection of irregular data, data loss, inconsistency, etc.).

  • Remote database monitoring is also possible via SDI WEB Service.

Back to top