in reply to Perl jdbc connection

"I am looking to use JDBC but with Perl,I am not sure how to install the Perl package and set up the connections,including drivers."

DBD::JDBC hasn't been updated since 2009, has 12 issues and zero passing builds on the matrix. You can see all this on the left hand side of the metacpan page. A good place to start when looking a module is to check the open issues and passing builds. This module may not be a good choice.

You don't say which OS you are running or which perl version you are on. Generally cpan Module::Name or cpanm Module::Name is a reasonable starting point, after you've read and understood the module documentation as it may detail non perl dependencies. See also Perl with Teradata ODBC & Vertica documentation both mention the use of ODBC drivers.