Launching DB Connector

Launching DB Connector: now connect faster to your databases

Traditionally, you need to build an application layer over the app to connect to a database after which you would need to host the application as a web server, exposing API for the App to be able to interact with the database. Even for activities as simple as reading a table or inserting a record in a table you need web servers to be hosted over the database. This is where you need some connectors that can make it simpler to connect to databases.

Why DB Connectors?

We have often seen requests from our customers who need a quick and easy way to connect to databases and to be able to retrieve data, add data, and so on to the tables in the existing databases. This has prompted our team to develop an easy to use the connector for our customer.

Where are Connectors?

You can find the DB Connector under Connectors > + Connectors > Pick a Category

It is an easy process you need to follow to connect; simply configure a connection, configure a query, and you are done.

How can you use the DB Connector?

From Studio Apps you can directly access your database without hosting web servers. The process is simple and involves these few simple steps as follows. Let us take an example to connect to the MySQL database:

Configuring a Connection

  1. Under Connectors > + Connectors, first Pick a Category (the MySQL Database for this example) and click Add.

  2. Enter the Category Name and description to configure your database category.

  3. Configure the Connection strings and Test the connection

  4. Click Continue to save the connection configuration which will Finish your connection configuration steps.

Configuring Query

Once you are done configuring the connection, you need to configure the query which can run in the Studio App using BINDAPI() or configure as a workflow service task.

  1. To open the Query editor click “Add Query“ shown against the connector.

  2. Write the query and run it. Click Run or ctrl + enter (cmd + enter in X-OS).

    You can bind variables dynamically during run-time of the Studio app or workflow tasks, by adding the variable and using it in the query using double braces {{variable}}.

    This helps in binding this query to accept inputs from another task or screen.

  3. Save this query and it can now be used in a similar way as we use the Api in UI Builder and Workflow.

We are sure this makes connecting to the Databases simpler for you now. To use the connector in the Studio App, refer to this topic on API Integration . In case you have any thoughts, suggestions or feedback? We’d love to hear from you. Head to our forum to share in our Suggestions Section.