Dynamic Database Configuration

Use dynamic database host

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

Now when you are configuring the database connectors, Studio allows you to Use dynamic database host for all databases.

NOTE: While using dynamic database host, the schema of the database should be the same.

You can toggle this option which will enable you to access to host dynamically from different action flows and BINDAPI.

In the above image, we have the option to set our host to fetch the database due to toggling

Use dynamic database host
.
Each time the data will change with respect to the different hosts provided.

Use dynamic database name

DronaHQ Studio supports connecting to Postgres, MySQL, MSSQL and MongoDB, and other databases with a dynamic database name facility. Usually, for every database connector, their connecting string is required and we write their dedicated queries for their respective database name/table, but with dynamic database name, users can access different database names/tables from a single connector and also write queries respected to the databases name/table.

Now when you are configuring the database connectors, Studio allows you to Use dynamic database names for all databases.

NOTE: While using dynamic database name, the schema of the database should be the same.

You can toggle this option which will enable you to access databases with different names, dynamically from different action flows and BINDAPI

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

Use dynamic database credentials

DronaHQ Studio supports connecting to Postgres, MySQL, MSSQL and MongoDB and other databases with a dynamic database credentials facility. Usually, for every database connector, their connecting string is required and we write their dedicated queries for their respective and user credentials are required to access them, but with dynamic database credentials, users can access different database names/tables from a single connector by providing credentials for each and also write queries respected to the databases name/table.

Now when you are configuring the database connectors, Studio allows you to Use dynamic database credentials for all databases.

You can toggle this option which will enable you to access to databases with different names, dynamically from different action flows and BINDAPI by providing different credentials for each.

In the above image, we have the option to set our username and password to fetch the database due to toggling Use dynamic database host.
Each time the data will change with respect to different credentials provided.