Connection to Oracle

Highlighted
One Star

Connection to Oracle

Hi,

How to connect to an Oracle database with Oracle thin DB type ?

I've tried many times but it doesn't works and i don't understand why because I have the good database setting.
Employee

Re: Connection to Oracle

Talking about the tDB* components, the Oracle connection is made with DBD:Smiley Surprisedracle driver, no "thin" driver in Perl.
Employee

Re: Connection to Oracle

Oracle was not available yet in the beta version.

This will be available in Talend 1.0.0

Nicolas
One Star

Re: Connection to Oracle

I understand that we don't have an ORA driver within talend* but...

I was able to see the ORA table structure and was able to estabilish DB connections to ORACLE. However, when I tried to execute the process to convert the table to XML file, it keeps on running but not outputing anything in the target xml file. Why? Please help!

Starting process testing at 16:48 02/10/2006.

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: C:\Data\tos\TOS-Win32-20060919-1637-beta\workspace\.Perl\FIRSTTEST.process_testing_Default.pl (./tUser/parameters_C:\Data\tos\TOS-Win32-20060919-1637-beta\workspace\.Perl\FIRSTTEST.process_testing_Default.pl.pl)

Connecting to talendStudio on port 4334 ...ThreadStat started...
Connecting to talendStudio on port 3334...connected.

connected.
Employee

Re: Connection to Oracle

kewlpics wrote:
I was able to see the ORA table structure and was able to estabilish DB connections to ORACLE. However, when I tried to execute the process to convert the table to XML file, it keeps on running but not outputing anything in the target xml file. Why? Please help!

How do you configure your tDBInput? what is the database type you select?
One Star

Re: Connection to Oracle

For DB type I selected mysql but the host, port, database, user name and password are all ORACLE information.
One Star

Re: Connection to Oracle

I have installed RC1. Used ORACLE SID as the driver for the DB Connection. I was able to create schema based on the tables availabe from the database. However, I was not able to successfully convert the DB data to fiels. I got the following errors.

install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: C:\Data\TOS-Win32-20061002-2251-RC1\plugins\org.talend.designer.codegen.perlmodule_0.9.0.20061002-2251-RC1\perl\ C:\Data\TOS-Win32-20061002-2251-RC1\workspace\.Perl C:/Perl/site/lib C:/Perl/lib .) at (eval 7) line 3.
Perhaps the DBD:Smiley Surprisedracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
at C:\Data\TOS-Win32-20061002-2251-RC1\workspace\.Perl\FIRST.process_testing.pl line 469

Am I missing some drivers? Thanks.
One Star

Re: Connection to Oracle

Nevermind. I got it. I need to install DBD ORACLE via ppm.

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