This section details requirement examples of connections to AWS using our connectors for S3 Delimited Text, and Relational Databases in an EC2 instance.
To connect to RDS, create a Datastore as follows;
Type: SQL Server
Where is your data: On an internal network
Agent: Select the Agent installed in your EC2 environment
Connection String: Server = [ServerName],[Port];Database=[DatabaseName];User Id=[UserID];Password=[Password];
EC2 — Inbound ports 3389 - no outbound rules
RDS — Inbound ports 1433 - no outbound rules
There is also a rule that allows the EC2 group to access the RDS group so the agent on EC2 can connect to RDS via the SQL Native Client (port 1433).
To connect to S3, create a Datastore as follows
Type — S3 Delimited Text
Where is your data? — In the Cloud
Agent — Not required
Bucket Name — Secret Key - Access Key - AWS Region - Path
Please refer to AWS documentation with regards to applying security to the AWS S3 Bucket.
For Eightwire to interact with the AWS bucket the suggested actions required to browse, read, overwrite and insert are;