Connectors in Qntrl | Qntrl | Bridge | Online Help

Connectors

Connectors serve as a repository for storing and organizing the necessary parameters to establish a database connection. The connectivity parameters stored within a connector are utilized to establish a secure connection between the bridge and an in-house database.

When retrieving values from a remote machine's database, it is essential to use both Connectors and the Bridge in conjunction. This combined usage ensures secure access to the client's database.

A connector can be reused in any bridge to communicate with a remote database.

Create a Connector   

To create a new connector:

  1. Click the settings gear iconat the left pane.

  2. Navigate to Advanced >> Bridge >> choose Connectors.

  3. Click New Connector.

  4. Fill in the new connector details.

    1. Name: Provide a unique name for the connector.

    2. Type: Select the Type of connection. Currently Qntrl supports only JDBC.

    3. Credential: Select the credential name that has the credentials to connect to the intended database.

    4. SQL Type: Select the type of your SQL database

      1. SQL Server

      2. MySQL

      3. PostgreSQL

      4. Oracle

    5. Connection Timeout: Specify the maximum timeout limit beyond which the connection will expire.

    6. Query Timeout: Specify the maximum timeout limit beyond which the query execution will be suspended.

    7. Host Name: Enter the hostname in which the DB is hosted.

    8. Port: Enter the port number in which the DB runs.

    9. Database Name: Enter the database name to be connected.

    10. Instance: This field appears if the SQL Type is SQL Server. Enter the DB instance name.

  1. Click Save. 


Edit a Connector   

To update the details of an existing connector:

  1. Navigate to (settings) >> Advanced >> Bridge >> select Connectors.

  2. In the Connectors list page loaded, click on the connector name you want to edit.

  3. Make modifications and click Save. 

Delete a Connector   

To remove a connector from Qntrl,

  1. Navigate to(settings) >> Advanced >> Bridge >> select Connectors.

  2. Hover over the name of the connector you want to delete, click the mouse over action menu, and select Delete.

  3. Confirm your delete action.

 

 

 


    • Related Articles

    • Custom Function: Post_Messages_to_Zoho_Cliq_Channel

      This custom function can be used to post predefined messages to existing Zoho Cliq channels. Prerequisites Sign up for Zoho Cliq and create a channel with the required users. Only the members of this channel will receive messages. Business Scenario ...

    • Advanced Fields

      Lookups Lookups are fields used to obtain a subset of options from available values in fields, tables, webhook API responses, or database query responses. Existing data available in the organization can be reused using lookups. Lookups usually return ...

    You are currently viewing the help articles of Qntrl 3.0. If you are still using our older version and require guidance with it, Click here.