Connect DB2 (by ODBC) to Mysql

Highlighted
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 ?
Highlighted
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 GARTNER 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

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads