Database Connections
You can connect to a Vertica database in the following ways:
-
Interactively using the vsql client, as described in Using vsql in the Administrator's Guide.
vsql is a character-based, interactive, front-end utility that lets you type SQL statements and see the results. It also provides a number of meta-commands and various shell-like features that facilitate writing scripts and automating a variety of tasks.
You can run vsql on any node within a database. To start vsql, use the Administration Tools or the shell command described in Using vsql.
-
Programmatically using the JDBC driver provided by Vertica, as described in Programming JDBC Client Applications in Connecting to Vertica.
An abbreviation for Java Database Connectivity, JDBC is a call-level application programming interface (API) that provides connectivity between Java programs and data sources (SQL databases and other non-relational data sources, such as spreadsheets or flat files). JDBC is included in the Java 2 Standard and Enterprise editions.
-
Programmatically using the ODBC driver provided by Vertica, as described in Programming ODBC Client Applications in Connecting to Vertica.
An abbreviation for Open DataBase Connectivity, ODBC is a standard application programming interface (API) for access to database management systems.
- Programmatically using the ADO.NET driver provided by Vertica, as described in Programming ADO.NET Applications in Connecting to Vertica.
The Vertica driver for ADO.NET allows applications written in C# and Visual Studio to read data from, update, and load data into Vertica databases. It provides a data adapter that facilitates reading data from a database into a data set, and then writing changed data from the data set back to the database. It also provides a data reader (VerticaDataReader) for reading data and autocommit functionality for committing transactions automatically. -
Programmatically using Perl and the DBI driver, as described in Programming Perl Client Applications in Connecting to Vertica.
Perl is a free, stable, open source, cross-platform programming language licensed under its Artistic License, or the GNU General Public License (GPL).
-
Programmatically using Python and the Vertica Python Client or the pyodbc driver, as described in Programming Python Client Applications in Connecting to Vertica.
Python is a free, agile, object-oriented, cross-platform programming language designed to emphasize rapid development and code readability.
OpenText recommends that you deploy Vertica as the only active process on each machine in the cluster and connect to it from applications on different machines. Vertica expects to use all available resources on the machine, and to the extent that other applications are also using these resources, suboptimal performance could result.