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

    • 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 ...

    • Bridge Agent Configuration

      The Bridge Agent serves is the local management console for your Bridge installation. It provides access to service configurations, execution logs, messages, credentials, and communication settings. The Agent UI is accessible only from within the ...

    • Install and Configure Bridge

      Bridge is a lightweight agent that enables secure communication between Qntrl and your on-premise systems. This article provides step-by-step instructions to install Bridge across supported platforms. Supported Platforms Operating System Zip ...

    • 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 Webhooks enable automated HTTP notifications that are sent to third-party applications ...

    • Credentials

      The Credential module provides a streamlined solution for storing and managing authentication credentials for databases, remote machines, and application servers. Instead of entering usernames, passwords, or API keys repeatedly across multiple tasks, ...