You have seen how you can add Relational Databases like MySQL, Microsoft SQL, PostgreSQL to your apps. Studio also offers the connector to connect to different NoSQL DB such as Amazon Document DB.
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.
Configuring Amazon DocumentDB connector
To add a third-party DB connector, under Studio > Connectors, click (+) Connector. Select Amazon DocumentDB connector.
The most important part of the process is to provide connection configuration details.
You can provide the Connection string or provide the respective parameters.
In this case, note that to connect to the DocumentDB database/dataset you would need a few parameters or fields.
The connection parameters that are required are Host and database name. You also can enter the respective username, password, and port number.
Connecting to Amazon DocumentDB from outside of the Amazon virtual private connection is a bit tricky, to successfully make a connection you need to perform SSH tunneling in your AWS account.
You will then have domain/IP of your secure server along with SSH port number, provide these details after toggling on the Enable SSH tunneling option.
You can refer to our community article and AWS article to know more about SSH tunneling.
You can whitelist our IP addresses - 54.164.199.220, 34.233.152.191 by toggling on the Whitelist IP to allow DronaHQ connect to your database.
Once these configurations are done, you need to Test the request and connection. If the authentication is successful you would get the response accordingly. Click Save.
Adding queries to Amazon DocumentDB connector
Now that you have configured the connector you will find it under the Custom Database connectors list. Further to fetch data or undertake any other action, click the Add query option available after your connection is ready.
Here you can add your queries by simply clicking add query.
So click Add Query and create a query. Enter a Query name and select your query Action and click Run or press Ctrl + enter to run the query . The rows returned from the database are shown in the Response section.
