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

hi ,i would like to know whether i could connect to teradata using perl on windows machine or not, if we can then please suggect me which cpan module can be used.
  • Comment on How to connect to a remote teradata machine using perl on windows machine and execute BTEQ commands

Replies are listed 'Best First'.
Re: How to connect to a remote teradata machine using perl on windows machine and execute BTEQ commands
by Corion (Patriarch) on Nov 03, 2014 at 10:05 UTC

    Have you looked at the Teradata modules available on CPAN?

[reply]
      ya i have gone through it and installed DBI trough cpan and while intalling DBD::Teradata i am getting a large bunch of errors. and at last iam getting 
        DARNOLD/DBD-Teradata-1.52.tar.gz
  C:\Dwimperl\c\bin\dmake.EXE -- NOT OK
CPAN: YAML loaded ok (v0.77)
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible

      [download]
[reply]
[d/l]

        So parts of the installation fail. You will have to look at what parts fail. This information is further up in the installation output.

        The README included with DBD::Teradata says that `The provided test suite is not suitable for normal Perl "make test"´ , so you will have to adapt your approach to that. My rough suggestion is to start a CPAN shell and then use the look command to proceed manually with the installation:

        cpan
cpan> look DBD::Teradata
> perl Makefile.PL
> make test
> make install
> exit

        [download]

        Also note that the documentation of DBD::Teradata links to http://www.presicient.com/tdatdbd/ which supposedly has a more supported and more complete version.

[reply]
[d/l]
[select]
[reply]

Back to Seekers of Perl Wisdom