Perl jdbc connection

pragovnj has asked for the wisdom of the Perl Monks concerning the following question:

Hi All,

I have been using my Excel application using Perl CGIs and connecting to Teradata or Vertica using ODBC. Recently, we have been migrating it to MS Azure and there are limitations, one of them being using ODBC. 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. I am aware that to start with, I need to install the perl modules DBI, DBD::JDBC and Convert::BER). Any help or direction would be appreciated

Comment on Perl jdbc connection

Replies are listed 'Best First'.
Re: Perl jdbc connection by marto (Cardinal) on Sep 09, 2020 at 18:38 UTC
"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.	[reply] [d/l] [select]
Re: Perl jdbc connection by Corion (Patriarch) on Sep 09, 2020 at 16:41 UTC
If you need to connect to ODBC, why not use DBD::ODBC ?	[reply]
Re^2: Perl jdbc connection by pragovnj (Acolyte) on Sep 09, 2020 at 17:25 UTC
I have been using ODBC and now looking to use JDBC.	[reply]