topic Re: tOracleInput : select using dblink in Talend Studio

tOracleInput : select using dblink

_AnonymousUser — Wed, 27 Feb 2013 16:46:44 GMT

Hi,
I created a dblink on Oracle. I checked the dblink with a select query using that dblink. It works fine on Oracle SQL developer.
On TOS I've copy the same query (with the dblink) in a tOracleInput component. I got an error.
Then I tried to get through a view (view with the select query using the dblink) in order to avoid using the dblink syntax in the tOracleInput component. I got more or less the same error.
I finaly tried with a materialised view doing the same thing and it worked.
My question is : is it possible to use a db link in a tOracleInput component ? Do I have to use another kind of component ? (tOracleRow?) Is it a problem if the tOracleInput is connecting to a database through a tOracleConnection ?
Best regards,
CR

Re: tOracleInput : select using dblink

Anonymous — Thu, 28 Feb 2013 02:37:18 GMT

Hi,
For your question, when you drag your DB connection from Repository to Designer, there will poped up a Components window in which you can choose one component to create. see pic for details.
In addition that could you upload your screenshot about the error as you description

On TOS I've copy the same query (with the dblink) in a tOracleInput component. I got an error.
Then I tried to get through a view (view with the select query using the dblink) in order to avoid using the dblink syntax in the tOracleInput component. I got more or less the same error.

I have a little confusion about that, thanks a lot.
Best regards
Sabrina

Re: tOracleInput : select using dblink

Anonymous — Thu, 28 Feb 2013 10:17:10 GMT

Hi CR,
I think you can create functions to get data from your database link. So, because in Talend Metadata we can not get all elements in database.
Regar,
Luan