QuestionQ20

VerifiedData Ingestion and Transformation

An ecommerce company runs a complex order-fulfilment process across several operational systems hosted in AWS. Each operational system has a Java Database Connectivity (JDBC)-compliant relational database that captures the latest processing state.

The company must enable an operations team to track orders hourly throughout the entire fulfillment process.

Which solution meets these requirements with the LEAST development overhead?

Explanation

AWS Glue provides JDBC connectivity for relational data integration and can load a consolidated Amazon Redshift analytics store. Amazon QuickSight natively supports Amazon Redshift as a data source, enabling dashboards over the consolidated order-state data. AWS DMS supports specific source database engines rather than arbitrary JDBC-compliant databases, while DynamoDB is not listed as a native Amazon QuickSight relational data source.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!