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

    • Bridge agent settings

      Once the Bridge agent is set up, you can log in to the bridge agent to view and modify the allowed configuration as needed. To do this: In Qntrl, navigate to (settings) >> Advanced >> Bridge, then select your bridge. Hover your cursor over the bridge ...

    • DB Engine

      This state enables a connection with the database hosted on a private or local network and executes the defined SQL query in the database. Prerequisite An active Bridge agent. Refer here to install and configure Bridge. Create the necessary ...

    • Install Bridge

      Follow the below step-by-step procedures to configure and use Bridge in Qntrl. Step 1: Download the Bridge agent Only one Bridge agent can be installed per machine. To download a bridge agent in Qntrl: Navigate to (settings), under Advanced click ...

    • Credentials

      The Credential module provides a streamlined solution for storing and managing authentication credentials for databases, remote machines, and application servers. Organizations dealing with multiple databases or APIs often face repetitive credential ...

    • Configuring Additional Components

      Early Access Circuit Templates in Qntrl Studio is not enabled for all users. If you’d like to try it out, please email our support team for early access. Webhooks Create a Webhook To create a new Webhook: Click Webhooks in the left pane and click New ...

    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.