Vertica gives a top-tier, unified analytics platform that will always be free of the hidden framework. Connecting DronaHQ to Vertica lets you construct UIs rapidly on top of your Vertica information. For instance, you could fabricate an instrument to adjust metadata tables. You can peruse information from Vertica and afterward compose information back to it either straightforwardly, or through a different API.
Authentication Requirements: To establish a connection with your Vertica instance, you will require specific authentication credentials. You have the choice of either of the following two credential options:
- Vertica database username and password.
- Alternative authentication methods (excluding AWS IAM authentication).
- Hostname of the Vertica database.
- Port number for database communication.
- The designated database name within the Vertica host.
- Set up your firewall settings to permit DronaHQ's IP whitelist for access to your Vertica host.
Configuring Connector in DronaHQ
Configure your database category using the provided details. Validate connection with
Test connection and
settings for secure database setup.
|Enter the Host Domain or IP
|Enter the Port number
|Enter the Database name
|Enter the Username
|Enter the Password
value connection options in database configuration refer to specific settings (keys) and their corresponding values that dictate how the application connects to the database
|Use Dynamic Database Host
|Dynamically determine the host for the database connection.
|Use Dynamic Database Name
|Set the database name dynamically, allowing easy switching between databases.
|Use Dynamic Database Credentials
|Enable dynamic database credentials for secure and convenient management.
|Enhance security by restricting database access to specific whitelisted IP addresses.
Adding Database Queries
After configuring the connector, access it in your Connector Library.
Add query once the connection is established. Create queries, run them, and view responses.
Use double curly brackets for dynamic variables. Test with sample values before saving. Link dynamic variables to controls/actions for runtime use.
Saved queries appear under your connector in Connector Library.
Supported Query Operations
|Raw SQL Query
|Execute various SQL operations directly, e.g.,
SELECT * FROM TableName;
|Stored Procedure Call
|Call stored procedures, e.g.,
EXEC usp_GetInfo; to perform specific tasks or retrieve data from the database.
Using Vertica Connector
Data Bind using Data Query
Read/Display Data Query for Vertica:
Begin by constructing an SQL query to extract data from your Vertica database. For example, let's consider a scenario
where you want to retrieve all data from the
Persons table. The SQL query is:
SELECT * FROM Persons;
This SQL query retrieves all rows and columns from the
Persons table within the Vertica database.
Integrate the fetched data into your application's interface.
a. Access the Controls section and introduce the Table grid control.
b. Navigate to
Data Bind Options -> Quick Select -> Database Queries.
c. Opt for the Vertica connector and choose the query that aligns with your data presentation goals.