An active Bridge agent. Refer here to install and configure Bridge.
Create the necessary Credentials for the applications to be connected by DB Engine.
For more details about the DB Engine module in Bridge, the keys, and its description click here.
For associating a DB Task to a circuit:
In Builder View, drag and drop the DB Engine state from the left pane into your circuit or click the required DB Engine state in your circuit.
Under the Configuration tab, update the common state field attributes.
The Bridge ID field should capture the details of the bridge to be used for this task. Click and select the required bridge from the drop-down list.
Under Add Configuration, in Credential Name field, click and select the credential from the dropdown list. The Credential IDs of all the credentials created for the DB Engine module type will be displayed in the list.
Under Query Message, fill in the following fields:
Database - Enter the name of the connecting database in which the query has to be executed.
Query - Enter the query that has to be executed in the database.
Port - Enter the port in which the MySQL server is running. The default port is 3306.
Query Timeout - Specify the time limit (in seconds), within which the query must be executed.
Host - Enter the hostname of the machine in which the database query has to be executed. Enter the hostname as localhost, if the query is executed on the same Bridge-installed machine.
Database Type - Select the database type from the dropdown list.
Connection Timeout - Specify the time limit (in seconds), within which the connection to the specified server must be made.
In Code View, the JSON to configure the DB Engine state to pass a query and retrieve data from a database table is given below:
"Add User in Legacy Database": {"type": "db_engine","next": "End","bridge_id": "bridge-employee onboarding","payload": {"credential_id": "db_cred_2","query_timeout": 100,"host": "localhost","database_type": "MySQL","connection_timeout": 100,"port": 3306,"database_name": "user_db"}}
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.