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.