![]() ![]() Query Amazon DynamoDB Data and Select TablesĪfter establishing a connection, the wizard will close and the connection will be available in the connections panel. Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Ī typical JDBC URL is the following: jdbc:amazondynamodb:Access Key=xxx Secret Key=xxx Domain= Region=OREGON On the first screen of the add connection profile tool, you will be prompted for the type of database you wish to connect to. Use the JDBC driver to make the connection. To create a new connection profile, select the Connections -> Add Connection Profile option or use the 'Add Connection Profile' toolbar icon. Your Region will be displayed in the upper left-hand corner when you are logged into DynamoDB.įor assistance in constructing the JDBC URL, use the connection string designer built into the Amazon DynamoDB JDBC Driver. Connect to the database using the database name, user name, and password. Your AccessKey and SecretKey can be obtained on the security credentials page for your Amazon Web Services account. ![]() The connection to Amazon DynamoDB is made using your AccessKey, SecretKey, and optionally your Domain and Region. The JDBC URL begins with jdbc:amazondynamodb: and is followed by a semicolon-separated list of connection properties. (This property can also be set in the JDBC URL.) Driver Class: Set the driver class to.Based on your project reference, you are using version 4.2.0 of .CosmosDB. Driver Location: Set this property to the path to the lib subfolder in the installation directory. Angelo Peca Thanks for posting your question in Microsoft Q&A.In the Connection Wizard that appears, set the following properties:.Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.This article shows how to connect to Amazon DynamoDB using wizards in RazorSQL.Ĭreate a JDBC Data Source for Amazon DynamoDB Data The CData JDBC Driver for Amazon DynamoDB enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |