Skip to main content

Amazon Web Services (AWS) Relational Database Service (RDS) SQL Reference Architecture

Note: This article is intended for Amazon Web Services (AWS) administrators and serves as a preinstallation guide to ensure all required AWS Relational Database Service (RDS) SQL objects are provisioned before proceeding with the installation of Jet Analytics.

To prepare your Jet Analytics Data Integration environment in AWS, here are the steps we recommend.

Create Application Server - AWS VM

To serve the Jet Analytics Data Integration application in AWS, we recommend using an AWS EC2 instance (Virtual Machine), sized according to your solution's requirements.

Guide:Amazon EC2 Instance Types - Amazon Web Services

Considerations:

Recommended EC2 (VM) specs for moderate workloads:

  • t2.xlarge | 4 vCPU | 54 CPU Credits / hour | 16 Mem (GiB) | EBS-Only Storage | Moderate Network Performance
  • t2.2xlarge | 8 vCPU | 81 CPU Credits / hour | 32 Mem (GiB) | EBS-Only Storage | Moderate Network Performance

This VM will host the below services, and must remain running for Jet Analytics Data Integration to function:

  • Jet Analytics Ingest Service
  • Jet Analytics Execution Service

Create Storage for Ingest instance - Amazon RDS for SQL Server

AWS RDS SQL Database may be used for the storage for the Ingest instance.

Guide:Use Amazon RDS for SQL Server for Storage

Considerations:

Recommended SQL server sizing:

  • RDS Custom SQL Server instance: m5.large | 2 vCPU | 8 Memory (GiB) | EBS-Only Instance Storage | Up to 10 Network Bandwidth (Gbps) | Up to 4,750 EBS Bandwidth (Mbps)

    This is sufficient for small size databases.

Create Storage for Prepare instance - Amazon RDS for SQL Server

AWS RDS SQL Database may be used for the storage for the Prepare instance.

Guide:Use Amazon RDS for SQL Server for Storage

Considerations:

Recommended SQL server sizing:

  • RDS Custom SQL Server instance: m5.large | 2 vCPU | 8 Memory (GiB) | EBS-Only Instance Storage | Up to 10 Network Bandwidth (Gbps) | Up to 4,750 EBS Bandwidth (Mbps)

    This is sufficient for small size databases.

Estimate AWS Costs

Balancing cost and performance requires monitoring and forecasting of your services and needs.

Guide:AWS Pricing Calculator

Considerations:

  • AWS provides a pricing calculator to help you estimate your costs for various configurations.

Note: This AWS pricing calculator does not include the cost of Jet Analytics instances and usage.

Was this article helpful?

We're sorry to hear that.