Cloud Data Warehouse
ETL & Database Synchronization
Many mission critical systems run on-premises and across multiple locations and databases.
Is there a way to continually collect data from remote systems and build a scalable and affordable data warehouse on the cloud?
Think of Database Synchronization as way to continuously move data from on-premises to AWS and back forth, enabling a true Hybrid Cloud for your Enterprise Software.
Continually export On-Prem data from Microsoft SQL Server, Firebird, dBase, Visual FoxPro, SQL Anywhere and MySQL database to AWS.
Use Amazon Aurora (MySQL compatible enterprise-grade DB) as a centralized data warehouse.
Define extraction and transformation rules with simple transact query language.
Bi-directional sync? We got you covered, make changes right from AWS and distribute them across your stores and branches with Two-Way Sync.
Use Aurora-MySQL as a massive batch calculation engine and return data to on-prem.
- Data is also available on S3 so many other AWS products can be used: Amazon Athena, AWS Glue, Amazon Redshift.