DB Engine is used to connect with the database in the client's machine or client's network and perform READ/INSERT/UPDATE operations in the database. The DB Engine configured in bridge can be utilized in the following two distinct modules within Qntrl.
Request data
{"task_name": "db_task","credential": {"name": "<CREDENTIAL_NAME>"},"task_details": {"database": "<DATABASE_NAME>","db_query": "<SELECT NAME FROM <table>>","port": 3306,"query_timeout": 10000,"host": "<HOST_NAME>","sql_type": 1}}
Keys | Description |
task_name
| A system-defined name for the respective module.
|
credential | A JSON object that contains details of the JDBC credential. |
name | Name of the DB credential. |
task_details | A JSON object that contains details of the DB task. |
database | Name of the client database. |
db_query | DB query to be executed (SELECT/INSERT/UPDATE). |
port | The port used by the DB, by default, MySQL runs in port 3306, SQL Server in 1433, and PostgreSQL in 5432. If your database runs on a different port number, update this field accordingly. |
query_timeout (optional) | Time to wait for an SQL request to complete. |
host | Host name of the machine in which DB resides. |
sql_type | The database used. For MySQL - 1, for SQLServer - 3, for PostgreSQL - 4 |
allow_multiple_columns (optional) | Specifies the columns in SQL Query to be considered for data retrieval.
If not specified it takes the default value as 'false'. |
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.