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

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads