Amazon Simple Queue Service (SQS) is a fully managed message queuing service that enables you to decouple and scale microservices, distributed systems, and serverless applications. To integrate SQS with a HANA database, Advantco developed an adapter SQS for SAP Smart Data Integration(SDI). The adapter enables bi-directional data exchanges between HANA databases and AWS SQS. This blog details the steps required to replicate data from a SQS queue to a HANA real table.
Steps to configure and use the Advantco SQS adapter for SDI.
Deploy the Advantco adapter SQS adapter for SDI, this is done on the DP Agent system.
Define the structure of the message in the SQS queue. This structure will define the scheme for the table in HANA.
Create Remote Source, the source should refer to the DP agent where the adapter was deployed.
Define the replication task to create virtual and real tables. The replication behavior can be initial and/or realtime load.
Query the virtual and real tables. The virtual is a realtime connection to the SQS queue, querying the virtual does not remove the messages from the SQS queue. The real table contains the polled data from the SQS queue, these messages are no longer available in the queue.
Insert into the virtual table result into publishing a message to the SQS queue.
The Advantco SQS adapter for SDI provides a solution to replicate data from a Amazon SQS queue to HANA with minimal setup. The adapter provides bi-directional data synchronization between Amazon SQS queues and HANA tables.