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.
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
.
This will enable you to access to host dynamically from different action flows and data queries.
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
.
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
.
This will enable you to access to user credentials dynamically from different action flows and data queries.
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.