Skip to content
slogan

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

Simple Data Integrator (SDI) supports on-premises, cloud, and hybrid cloud environments. When connecting to the cloud, a secure connection can be established via the SDI Gateway Service without the need for a VPN.

It supports various data sources including Oracle, SQL Server, MySQL, PostgreSQL, DB2, Azure Synapse, Google BigQuery, Snowflake, ODBC-compliant databases, and file formats such as CSV, Excel, JSON, and XML. For file import and export, SDI is compatible with file systems, FTP/FTPS, SFTP, AWS S3, OCI Object Storage, and Azure Blob Storage.

SDI also enables data retrieval and integration from web services and web APIs.

A built-in scheduler allows you to automate data integration tasks at specified times or based on file changes.

Main functions

Data Integration

  •   Transfer data from the source DB table, view, query to target DB table.
  •    Import data from CSV, EXCEL , JSON , XML file into the target database table.
  •    Export table, view, query data from the source database to CSV , EXCEL , JSON , XML file.
  •    Execute SQL and Procedure .
  •   Integration with Web Services and Web APIs
  •    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 a schedule when the specified file is created, modified, or deleted.
  •    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 Gateway 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 , JSON or XML files regularly.

Regularly create and import CSV, Excel, JSON or XML files. Supports file systems, FTP/FTPS, SFTP, AWS S3, OCI Object Storage, web services, and web APIs.

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 Gateway Service.