Skip to main content

Amazon DocumentDB

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.


  1. Authentication Credentials: You will need specific authentication credentials to establish a connection with your Amazon DocumentDB instance.

  2. Connection Details:

    • Endpoint of your Amazon DocumentDB instance.
    • Port number for database communication.
    • The designated database name within the Amazon DocumentDB instance.
  3. Network Configuration:

    • Configure your network settings to allow access from the necessary sources to your Amazon DocumentDB host.
  4. 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 Save settings for secure database setup.


DronaHQ can Auto fill crucial connection values like host, name, password, and more from the connector's connection string.


HostEnter the Host Domain or IP
PortEnter the Port number
Database NameEnter the Database name
UsernameEnter the Username
PasswordEnter the Password
Amazon DocumentDB with Sample details.
Amazon DocumentDB with Sample details.


Advanced OptionDescription
Connection OptionsThe key and 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 CertificateImplement 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.
Whitelist IP 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:

  1. Name your Query: Assign a unique name to your query for easy identification and access.

  2. 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.

  3. 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 Find action, 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.

  4. Set Parameters: Based on the chosen action, provide the required parameters. For example, if you're executing a Find action, define the filter criteria and other pertinent details. In the case of an InsertOne action, input the data you wish to insert.

FilterCriteria to match documents. Specify conditions to filter and retrieve specific data from the collection.
ProjectionFields to include/exclude from results. Define which fields should be included or excluded in the query results.
SortSorting order for results. Specify how the query results should be sorted based on one or more fields.
SkipNumber of documents to skip. Set the offset for the query results, skipping a certain number of documents.
LimitMaximum number of documents to retrieve. Set a limit on the number of documents returned by the query.
UpdateModifications to apply. Define the changes you want to make to the selected documents in the collection.
DocumentData to be inserted. Provide the document or data that you want to insert into the collection.
StagesArray of stages for aggregation pipeline. Define a series of processing stages to transform and analyze data in the collection.
FieldField for which distinct values are sought. Specify the field from which you want to find distinct values.
AggregationStages for aggregation pipeline. Define various stages such as grouping, filtering, and transformation to perform data aggregation.
  1. Run the Query: Once you've configured the action and parameters, you can execute the query by clicking Test Query The response will be displayed based on the provided parameters, allowing you to review the retrieved data or the outcome of the query.
Add Query
Add 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.

Supported Actions

FindRetrieve documents from a collection based on specified criteria.
FindOneRetrieve a single document from a collection that matches a specified filter.
InsertOneInsert a single document into a collection.
InsertManyInsert multiple documents into a collection.
UpdateOneUpdate a single document in a collection that matches a specified filter.
UpdateManyUpdate multiple documents in a collection that match a specified filter.
DeleteOneDelete a single document from a collection that matches a specified filter.
DistinctFind distinct values for a specified field in a collection.
AggregatePerform aggregation operations on a collection, such as grouping, sorting, and computing aggregates.
CountCount the number of documents in a collection that match a specified filter.

Using Amazon DocumentDB Connector

  1. Access Data Bind Section or Control Action:

    • Navigate to the data bind section of the control.
  2. 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.
Find query
Find query
3. Test and Finalize

By following these steps, you'll seamlessly integrate the Amazon DocumentDB Connector into your application and efficiently execute queries to retrieve the desired data.