One Star

tOracleInput : select using dblink

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
2 REPLIES
Moderator

Re: tOracleInput : select using dblink

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tOracleInput : select using dblink

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