Simple Data Integrator (SDI) introduction

Simple Data Integrator (SDI) is a data integration tool (ETL) .  
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.

Agenda
SDI Overview
SDI Main functions
SDI Features
Use cases

Official site
https://sdi.ricct.com/

Transcript

1. Simple Data Integrator (SDI) introduction Research Institute of Cloud Computing Technology Sep. , 2022 https://sdi.ricct.com/ Ver. 1.2.2209.10
2. Permission is hereby granted, free of charge, to any person using this document without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, and/or sell copies of the document.
3. • SDI Overview • SDI Main functions • SDI Features • Use cases Agenda
4. Overview
5. Simple Data Integrator Overview Simple Data Integrator (SDI) is a data integration tool (ETL) . 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. http://sdi.ricct.com/ Same location Multiple locations
6. Main functions
7. Main functions RDB table, view, query => RDB table CSV,Excel, JSON => RDB table RDB table, view, query => CSV,Excel,JSON Execute SQL and Procedure Data monitoring and detection Detection of irregular data Detection of Data loss, inconsistency Workflow Result notification. Data Integration Scheduler Supported Datatype High Availability ➢ Hourly, daily, weekly, monthly, repeat job execution. ➢ Execute multiple jobs in parallel or in serial. ➢ Retry function. ➢ Source Oracle、SQL Server、MySQL 、PostgreSQL、DB2、 ODBC、CSV、Excel 、JSON ➢ Target Oracle、SQL Server、MySQL 、PostgreSQL 、CSV、 Excel 、JSON ➢ Cold Standby ➢ Hot Standby with failover function. ➢ Agent status monitoring
8. Features
9. SDI Features Simple design High performance Easily meet various requirements High Availability
10. 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.
11. High performance Adopts architectures like parallel, in-memory, and compressed transfer to achieve high- speed data transfer.
12. 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.
13. High Availability Cold standby and hot standby are supported.
14. Use cases
15. Integration of data across internal systems Integrate data in different formats between different systems.
16. Centrally managed data across multiple sites Centralized data management and data utilization for companies with multiple sites.
17. Data integration between on-premises, cloud and multiple clouds. Flexible connection design of data integration between on-premises, cloud and multiple clouds. On-premises with cloud Multi-cloud data linkage
18. Export and import CSV , Excel or JSON files regularly Export and import CSV , Excel or JSON files regularly. (File system , FTP/FTPS, SFTP, AWS S3, OCI Object Storage are supported. ) File system FTP/FTPS/SFTP AWS S3/OCI Object Storage
19. 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.
20. Thank You
21. https://www.ricct.com/