Building the Connection URL
Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba DynamoDB JDBC Driver:
jdbc:dynamodb:[Property1]=[Value];[Property2]=[Value];...
[Property] is any one of the connection properties supported by the connector. For a list of the properties available in the connector,
For example, to connect to a DynamoDB database in the us-west-1 region on AWS, authenticate the connection using IAM credentials, and use the schema definition stored in a local file with the path Environment/DynamoDB_JDBC_Schema.json, you would use the following connection URL:
jdbc:dynamodb:Host=dynamodb.us-west-1.amazonaws.com;Region=us-west-1;LocalMetadataFile=Environment//DynamoDB_JDBC_Schema.json;AccessKey=ABCABCABC123ABCABC45;SecretKey=abCD+E1f2Gxhi3J4klmN/OP5QrSTuvwXYzabcdEF
Important:
- Properties are case-sensitive.
- Do not duplicate properties in the connection URL.
- To make sure that the connection URL is compatible with all
JDBC applications, it is recommended that you escape the backslashes (
\) in your file paths by typing another backslash.