Whats the best AWS architecture/services to move data from DynamoDB to external API

Question

Hi there!

I'm brand new to the AWS world, but have developed a few iOS apps with SAP as backends. I'd like to create an iOS app that uses multiple AWS services, and the crucial part is to store data from app to DynamoDB via graphQL. The data should then be exported (maybe even from multiple tables) to a Odata interface on SAP and then save an external ID back to the AWS DB. One use case could be a sales receipt with one entry from header table and multiple from items table. Fetch the entries - create a sales order in SAP and update the entries in DynamoDB with SAP Sales Order ID, and make sure they're not sent again :)

I'm not asking for a guided answer here - just a hint for which services to utilize :)

Thanks in advance

Accepted Answer

Hi, I would look into EventBridge Pipes: https://docs.aws.amazon.com/eventbridge/latest/userguide/eb-pipes-dynamodb.html.

In this way you can decouple systems and provide scalable solution where upon update of Dynamo stream, the data can be sent towards a consumer (a lambda or a SQS with lambda) that can send data to third party and update data to dynamo.

Hope it helps ;)

Whats the best AWS architecture/services to move data from DynamoDB to external API

Relevant content