I need to change connection shared to dedicated in toracleinput.

One Star mft
One Star

I need to change connection shared to dedicated in toracleinput.

Hi,
I need to change from oracle connection shared (mts) to dedicated in toracleinput.
In tnsnames.ora we can use:
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.12)(PORT = 1521))
(CONNECT_DATA =
(SERVER=DEDICATED)
(SERVICE_NAME=db)
)
)
In jdbcthin we can use:
"jdbcSmiley Surprisedracle:thin:@(description=(address_list=
(address=(protocol=tcp)(port=1610)(host=10.10.10.12))
(connect_data=(SERVER=DEDICATED)(INSTANCE_NAME=db))
)";
But I don´t use tnsnames. I Only use a toracleinput configuration.
So, How can I put "SERVER=DEDICATED" as a parameter in toracleinput ?

Can someone help me?
Thanks
Marcio.

Re: I need to change connection shared to dedicated in toracleinput.

add it in "additional jdbc parameters" in your tOracleInput's Advanced Settings sub-tab.
One Star mft
One Star

Re: I need to change connection shared to dedicated in toracleinput.

Ok, but do you know how is the correct string.
One Star mft
One Star

Re: I need to change connection shared to dedicated in toracleinput.

Ok, but do you know how is the correct string ?
One Star mft
One Star

Re: I need to change connection shared to dedicated in toracleinput.

About :
Question: "How can I put "SERVER=DEDICATED" as a parameter in toracleinput ?"
Answer: "add it in "additional jdbc parameters" in your tOracleInput's Advanced Settings sub-tab."
Question: "Ok, but do you know: how is the correct string to write in "additional jdbc parameters" ?"

Can someone help me?
Thanks
Marcio.

Re: I need to change connection shared to dedicated in toracleinput.

sure, try entering this in the additional jdbc parameters text box. Since this is just off the top of my head, I may be incorrect--
if the code below does not work, please refer to the Oracle jdbc docs for the proper string:
http://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html

connect_data=(SERVER=DEDICATED);

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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog