Connect DB2 (by ODBC) to Mysql

One Star

Connect DB2 (by ODBC) to Mysql

When I connect DB2 to MySQL for extract table, i have this messge.

Starting process Hiearchie at 14:21 27/09/2006.
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: D:\Talend\plugins\org.talend.designer.codegen.perlmodule_0.9.0.20060919-1637-beta\perl\ D:\Talend\workspace\.Perl D:/Perl/site/lib D:/Perl/lib .) at (eval 7) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
at D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie.pl line 181

Copyright (c) 2005-2006, Talend SA

This source code has been automatically generated by talend
OpenStudio / ProcessDesigner (CodeGenerator version 0.9.0.20060919-1637-beta).
You can find more information about talend products at www.talend.com.
You may distribute this code under the terms of either the GNU General
Public License or under the Artistic License just like Perl itself.

tsInfo> Running process with context: D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl (./tUser/parameters_D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl.pl)

Process Hiearchie ended at 14:21 27/09/2006. [exit code=2]

And when connect DB2 to Output file, I have this message

Starting process Hiearchie at 14:23 27/09/2006.
install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC contains: D:\Talend\plugins\org.talend.designer.codegen.perlmodule_0.9.0.20060919-1637-beta\perl\ D:\Talend\workspace\.Perl D:/Perl/site/lib D:/Perl/lib .) at (eval 7) line 3.
Perhaps the DBD::ODBC perl module hasn't been fully installed,
or perhaps the capitalisation of 'ODBC' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
at D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie.pl line 229

Copyright (c) 2005-2006, Talend SA

This source code has been automatically generated by talend
OpenStudio / ProcessDesigner (CodeGenerator version 0.9.0.20060919-1637-beta).
You can find more information about talend products at www.talend.com.
You may distribute this code under the terms of either the GNU General
Public License or under the Artistic License just like Perl itself.

tsInfo> Running process with context: D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl (./tUser/parameters_D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl.pl)

Process Hiearchie ended at 14:23 27/09/2006. [exit code=2]

Drive ODBC and mysql aren't installed ?
Employee

Re: Connect DB2 (by ODBC) to Mysql

You must install the following module perl to activate perl's connection perl with mysql and Odbc.

In console, type the following command :

ppm -install DBD-ODBC
ppm -install DBD-mysql

Regards.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog