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.