5 - HP Vertica Database Intro Series

Connectivity models with the HP Vertica database You can connect to an HP Vertica database in the following ways: Interactively using the vsql client. What is VSQL? Vsql is a front-end utility based on characters that allows you to type SQL statements and see the results. It also provides a number of meta-commands and various features that facilitate the creation of scripts to automate a variety of tasks. You can run the utility vsql in any of the nodes within a database. Using the JDBC driver provided by HP Vertica. JDBC and an abbreviation for Java Database Connectivity, JDBC is an application programming interface that provides connectivity between Java programs and data sources (SQL databases and other non-relational data sources such as spreadsheets or flat files). Using the ODBC driver provided by HP Vertica. An abbreviation for Open Database Connectivity, ODBC is a standard application programming interface (API) for accessing database management systems. Using the ADO.NET driver provided by HP Vertica. The HP Vertica for ADO.NET driver allows applications written in C # and Visual Studio to read data from, update, and load data into HP Vertica databases. It provides a data adapter which facilitates reading data from a database into a set of data and then write the modified data from the set of data back to the database. Using Python and the pyodbc driver. Python is a free language, object-oriented to emphasize the rapid development and code readability.