AWS Integration

Deploy and integrate the Synthesized platform with Amazon Web Services.

Overview

The platform integrates with AWS services:

  • Amazon RDS: PostgreSQL, MySQL, SQL Server, Oracle

  • Amazon Aurora: MySQL-compatible, PostgreSQL-compatible

  • AWS Secrets Manager: Credential management

  • Amazon ECS/EKS: Container deployment

  • Amazon S3: Backup and data export

RDS/Aurora Connection

data_sources:
  input:
    url: jdbc:postgresql://mydb.abc123.us-east-1.rds.amazonaws.com:5432/mydb
    username: ${aws:rds/credentials#username}
    password: ${aws:rds/credentials#password}

AWS Secrets Manager

Store credentials securely:

data_sources:
  input:
    url: jdbc:postgresql://mydb.rds.amazonaws.com:5432/mydb
    username: ${aws:prod/database#username}
    password: ${aws:prod/database#password}

Configuration:

export AWS_REGION=us-east-1
export AWS_ACCESS_KEY_ID=your-key-id
export AWS_SECRET_ACCESS_KEY=your-secret-key

ECS Deployment

Deploy the platform on Amazon ECS:

{
  "family": "tdk-backend",
  "containerDefinitions": [{
    "name": "tdk-backend",
    "image": "synthesizedio/tdk-backend",
    "memory": 4096,
    "cpu": 2048,
    "environment": [
      {"name": "SPRING_DATASOURCE_URL", "value": "jdbc:..."}
    ]
  }]
}

IAM Permissions

Required IAM permissions:

{
  "Version": "2012-10-17",
  "Statement": [{
    "Effect": "Allow",
    "Action": [
      "secretsmanager:GetSecretValue",
      "rds:DescribeDBInstances"
    ],
    "Resource": "*"
  }]
}