Amazon DynamoDB Connection Help
RazorSQL provides a custom Amazon DynamoDB driver that can communicate with a DynamoDB
database via Amazon Web Services (AWS). For information on the SQL support provided by
RazorSQL for DynamoDB, click the link
below.
DynamoDB SQL Syntax Support
Connecting to DynamoDB with the RazorSQL DynamoDB Driver
To connect to DynamoDB using the RazorSQL DynamoDB driver, open the Connections -> Add Connection Profile menu option and select DynamoDB (Amazon) as the database type. Click continue and select RazorSQL DynamoDB Driver as the connection type.
Next, enter a connection profile name. This will be the name used to identify the connection for connecting again in the future.
Next, enter the Amazon AWS security credentials. These include the AWS Access Key and the AWS Secret Key. These credentials are provided to you when signing up for Amazon Web Servies. You can look up your AWS security credentials by logging in to your AWS account and selecting the Security Credentials section.
If using the Amazon STS service to receive security credentials, the AWS Access Key, AWS Secret Key, and AWS Session Token will be needed to connect. RazorSQL also provides the option for specifying the location of the AWS Credentials File if you have one on your machine. The AWS Credentials File is the file used by the AWS command line process to authenticate. The file is in a specific format and can have multiple "profiles" in the file for different sets of credentials. If providing RazorSQL the location of the AWS Credentials file, RazorSQL needs to know the profile to use to connect if there is more than one profile configured in the file.
Next, enter the AWS server to use. The default server is dynamodb.us-east-1.amazonaws.com. Other options can be found by clicking on the "AWS Server" link on the add connection profile screen.
Next, select whether to encrypt the data passing to and from the DynamoDB web service. To encrypt data, select TRUE in the "Secure" field.
Next, enter the max results per query value. This number specifies the maximum number of rows RazorSQL will retrieve from DynamoDB for a given query.
