SimpleDB Connection Help
RazorSQL provides a custom Amazon SimpleDB driver that can communicate with a SimpleDB
database via Amazon Web Services (AWS). For information on the SQL support provided by
RazorSQL for SimpleDB and the SimpleDB specific tools provided by RazorSQL, click the links
SimpleDB SQL Syntax Support
Guide to SimpleDB Tools
Connecting to SimpleDB with the RazorSQL SimpleDB Driver
To connect to SimpleDB using the RazorSQL SimpleDB driver, open the Connections -> Add Connection Profile menu option and select SimpleDB (Amazon) as the database type. Click continue and select RazorSQL SimpleDB 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.
Next, enter the AWS server to use. The default server is sdb.amazonaws.com. Other options include the other SimpleDB endpoints across the globe such as sdb.us-west-1.amazonaws.com, sdb.eu-west-1.amazonaws.com, and sdb.ap-southeast-1.amazonaws.com.
Next, select whether to encrypt the data passing to and from the SimpleDB web service. To encrypt data, select TRUE in the "Secure" field.
Next, enter the max results per query value. The default is 2500. This number specifies the maximum number of rows RazorSQL will retrieve from SimpleDB for a given query.