Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Mastering Change Data Capture: Read Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-04-01 04:41 AM

Need to specify DB schema on tJDBC connections

Hi,

 

I have to use generic tJDBC components to connect to an Oracle Database.

And I also have to specify a default DB schema, other than the users schema.

 

user john (with own schema "john") has to use DB schema "mike"

 

Does anyone know to manage this within the components tJDBCConnetcion?

 

best regards

Martin

Labels (4)
Labels
152 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-04-01 04:56 AM
Author

Hi Martin,

 

     If you are having access to the other user's table, then you need to use the user prefix before table to fully qualify those tables.

 

     Another thing I would suggest is that if you are using generic JDBC, the throughput will be less compared to native components. So please have that in your mind while processing the data.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

152 Views
0 Likes