Amazon Document DB is a document-based database. Amazon DocumentDB is a scalable, highly durable, and fully managed database service for operating mission-critical MongoDB workloads. You can use the connector to carry out various operations including querying and inserting and updating details.
Authentication Credentials: You will need specific authentication credentials to establish a connection with your Amazon DocumentDB instance.
- Endpoint of your Amazon DocumentDB instance.
- Port number for database communication.
- The designated database name within the Amazon DocumentDB instance.
- Configure your network settings to allow access from the necessary sources to your Amazon DocumentDB host.
AWS Credentials: If your use case requires AWS services in conjunction with the Amazon DocumentDB connector, ensure you have valid AWS credentials with appropriate permissions.
Configuring Connector in DronaHQ
Configure your database category using the provided details. Validate connection with
Test connection and
settings for secure database setup.
DronaHQ can Auto fill crucial connection values like host, name, password, and more from the connector's connection string.
|Enter the Host Domain or IP
|Enter the Port number
|Enter the Database name
|Enter the Username
|Enter the Password
value connection options in database configuration refer to specific settings (keys) and their corresponding values that dictate how the application connects to the database
|Connect using SSL
|Securely access the database using an encrypted SSL connection, ensuring data integrity and confidentiality.
|Use a Self-Signed Certificate
|Implement secure authentication and encryption using a self-signed certificate along with the CA, client key, and client certificate options.
|Enable SSH Tunneling
|Securely access the database through encrypted SSH tunneling.
|Enhance security by restricting database access to specific whitelisted IP addresses.
Adding Database Queries
Once you have successfully configured the Amazon DocumentDB connector, you can manage your database queries through the Connector Library. Follow these steps to create and manage queries for your Amazon DocumentDB:
Name your Query: Assign a unique name to your query for easy identification and access.
Select a Collection: Choose the specific collection within your Amazon DocumentDB instance on which you intend to execute the query. This ensures that your query is targeted to the correct dataset.
Choose an Action: Amazon DocumentDB supports a range of actions, each with distinct parameters. Select the appropriate action from the available options. For instance, if you opt for the
Findaction, you'll have parameters such as Filter, Projection, Sort, Limit, and Skip at your disposal. If you go with
InsertOne,the parameters will transform into a Key: Value string for insertion.
Set Parameters: Based on the chosen action, provide the required parameters. For example, if you're executing a
Findaction, define the filter criteria and other pertinent details. In the case of an
InsertOneaction, input the data you wish to insert.
|Criteria to match documents. Specify conditions to filter and retrieve specific data from the collection.
|Fields to include/exclude from results. Define which fields should be included or excluded in the query results.
|Sorting order for results. Specify how the query results should be sorted based on one or more fields.
|Number of documents to skip. Set the offset for the query results, skipping a certain number of documents.
|Maximum number of documents to retrieve. Set a limit on the number of documents returned by the query.
|Modifications to apply. Define the changes you want to make to the selected documents in the collection.
|Data to be inserted. Provide the document or data that you want to insert into the collection.
|Array of stages for aggregation pipeline. Define a series of processing stages to transform and analyze data in the collection.
|Field for which distinct values are sought. Specify the field from which you want to find distinct values.
|Stages for aggregation pipeline. Define various stages such as grouping, filtering, and transformation to perform data aggregation.
- Run the Query: Once you've configured the action and parameters, you can execute the query by clicking
Test QueryThe response will be displayed based on the provided parameters, allowing you to review the retrieved data or the outcome of the query.
Utilize double curly brackets for incorporating dynamic variables. Prior to saving, test with sample values. Associate dynamic variables with controls/actions for real-time utilization.
Your saved queries will be visible beneath your connector within the Connector Library.
|Retrieve documents from a collection based on specified criteria.
|Retrieve a single document from a collection that matches a specified filter.
|Insert a single document into a collection.
|Insert multiple documents into a collection.
|Update a single document in a collection that matches a specified filter.
|Update multiple documents in a collection that match a specified filter.
|Delete a single document from a collection that matches a specified filter.
|Find distinct values for a specified field in a collection.
|Perform aggregation operations on a collection, such as grouping, sorting, and computing aggregates.
|Count the number of documents in a collection that match a specified filter.
Using Amazon DocumentDB Connector
Access Data Bind Section or Control Action:
- Navigate to the data bind section of the control.
Select Amazon DocumentDB Connector from
Data Bind Options -> Quick Select -> Database Queries:
- Choose Amazon DocumentDB Connector from the available options.
- Select the specific connector query that will retrieve the desired data.
- Click on "Continue" to proceed.
By following these steps, you'll seamlessly integrate the Amazon DocumentDB Connector into your application and efficiently execute queries to retrieve the desired data.