Skip to main content

Dynamic Database Configurations

DronaHQ supports connecting to Postgres, MySQL, MSSQL and MongoDB, and other databases with a dynamic database configuration. Usually, for every database, connecting string is required and we write their dedicated queries, but with dynamic database configurations users can access different hosts, databases and db users from a single connector and also write queries respected to the them.

DronaHQ allows you to configure dynamic host, dynamic database and dynamic credentials.

NOTE

While using dynamic database configurations, the schema of the database should be the same.

Configure Dynamic Host

To configure dynamic host, Go to Connectors -> + CONNECTOR -> Select Supported DB, in this case MySQL and enable this toggle named Use dymanic database host.

Dynamic host
Dynamic host

This will enable you to access to host dynamically from different action flows and data queries.

Data query
Data query

In the above image, we have the option to set our host to fetch the database due to toggling. Each time the data will change with respect to the different hosts provided.

Configure Dynamic Database

To configure dynamic database name, Go to Connectors -> + CONNECTOR -> Select Supported DB, in this case MySQL and enable this toggle named Use dymanic database name.

Dynamic DB Name
Dynamic database

This will enable you to access to database dynamically from different action flows and data queries.

Configure Dynamic Credentials

To configure dynamic host, Go to Connectors -> + CONNECTOR -> Select Supported DB, in this case MySQL and enable this toggle named Use dymanic database credentials.

Dynamic credentials
Dynamic credentials

This will enable you to access to user credentials dynamically from different action flows and data queries.

Creds query

In the above image, we have the option to set our user credential to fetch the database due to toggling. Each time the data will change with respect to the different users provided.