You can customize the query further by referencing other potential URL parameters.
Set the SQL query to SELECT * FROM # to parse the URL parameter table and use it as the target of the SELECT query. 
Set the Operation to 'Select with Streaming'. Configure the CData Amazon DynamoDB Connector. Your Region will be displayed in the upper left-hand corner when you are logged into DynamoDB. 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. Once the connection is configured, click Test Connection to ensure the connectivity to Amazon DynamoDB. Create a new Connection (or edit an existing one) and configure the properties to connect to Amazon DynamoDB (see below). Add a CData Amazon DynamoDB Connector to the same flow, after the HTTP Connector. Configure the address for the HTTP Connector. Add an HTTP Connector to the Message Flow. Create a new Mule Project in Anypoint Studio. The exact same procedure outlined below can be used with any CData Mule Connector to create a Web interface for the 200+ available data sources. The application created allows you to request Amazon DynamoDB data using an HTTP request and have the results returned as JSON. #DYNAMO JSON QUERY NOSQL AMAZON HOW TO#
This article demonstrates how to use the CData Mule Connector for Amazon DynamoDB inside of a Mule project to create a Web interface for Amazon DynamoDB data.
The Connector allows users to easily create Mule Applications to backup, transform, report, and analyze Amazon DynamoDB data. The CData Mule Connector for Amazon DynamoDB connects Amazon DynamoDB data to Mule applications enabling read, write, update, and delete functionality with familiar SQL queries.
0 kommentar(er)
