View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007019 | SymmetricDS Pro | New Feature | public | 2025-08-13 13:59 | 2025-08-25 14:14 |
| Reporter | cquamme | Assigned To | cquamme | ||
| Priority | normal | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.17.0 | ||||
| Summary | 0007019: Add support for AWS SNS (load-only endpoint) | ||||
| Description | Add support for Amazon Simple Notification Service (AWS SNS) queue as a load-only implementation. (Similar to RabbitMQ) Key points: 1. Publish: convert entire row of data into a format specified by the new parameter (also see Additional Information below) employing a utility class (TODO: research). 2. Target table name becomes a topic 3. Updates to SymmetricDS internal tables go into the local runtime database (H2 for example) 4. If topic does not exist, batch should fail with the Table not Found error. 5. The Create Table batch should create new topic. 6. Checking endpoint permissions (on SNS) should include: * Authentication * Create topic. * Publish one message to topic. * No bulk publishing supported at this time. * Delete events are not supported? | ||||
| Steps To Reproduce | * Install SymmetricDS node for SNS * Create SNS instance * Obtain AWS API key for SNS (credentials) * Send data change events or initial load to SNS node. | ||||
| Additional Information | SNS message body format: amazon.sns.publish.format=json_flat (default) { "column1_name"="value1" ,"column2_name"="value2" , ... } amazon.sns.publish.format=json_data { "id": "primary key columns as text = value1|value2" "data": { "column1_name"="value1" ,"column2_name"="value2" , ... } } amazon.sns.publish.format=csv "value1" , "value2" , ... https://docs.aws.amazon.com/sns/latest/dg/example_sns_CreateTopic_section.html | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-08-13 13:59 | cquamme | New Issue | |
| 2025-08-13 13:59 | cquamme | Status | new => assigned |
| 2025-08-13 13:59 | cquamme | Assigned To | => cquamme |
| 2025-08-13 18:16 | pbelov | Product Version | 3.17.0 => 3.16.0 |
| 2025-08-13 18:16 | pbelov | Target Version | 3.17.0 => 3.16.6 |
| 2025-08-13 18:16 | pbelov | Summary | Add support for AWS SNS => Add support for AWS SNS (load-only endpoint) |
| 2025-08-13 18:16 | pbelov | Description Updated | View Revisions |
| 2025-08-13 18:16 | pbelov | Steps to Reproduce Updated | View Revisions |
| 2025-08-13 18:16 | pbelov | Additional Information Updated | View Revisions |
| 2025-08-13 18:25 | pbelov | Description Updated | View Revisions |
| 2025-08-13 18:25 | pbelov | Additional Information Updated | View Revisions |
| 2025-08-13 18:25 | pbelov | Additional Information Updated | View Revisions |
| 2025-08-25 14:13 | cquamme | Product Version | 3.16.0 => 3.17.0 |
| 2025-08-25 14:13 | cquamme | Target Version | 3.16.6 => |