Talend community forum / Oracle Connection

tQ123 · 2012-06-14 16:17:51

Oracle SID – Using Oracle JDBC thin driver
Generated database URL for this type of connection: jdbc:oracle:thin:@server:1521:sid

- Oracle Service Name – Using Oracle JDBC thin driver
Generated database URL for this type of connection: jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=server)(port=1521))(connect_data=(service_name=service_name)))

Which one to use?

pedro · 2012-06-15 04:27:06

Hi

Welcome to Talend Community!

Usually we use Oracle SID. But all these two ways work fine. Choose any way you like.

Regards,
Pedro

ienax_ridens · 2012-08-10 10:33:19

Hi all, I'm doing the first attempt to connect TOS to an Oracle DB: my customer has sent me the following parameters of connection and instructions:

"
Service name (Alias) to put in the file "tnsnames.ora" is:
SAPPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server_name)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TAGETIKLKPRD)
)
)
"

Now my question is: how have I to write in TOS Oracle connection properties?

My customer talk about "service name", but in the connection string I see "SID = TAGETIKLKPRD". Obviously I think that "tnsnames.ora" file is useless for me using direct connection with Talend.

pedro · 2012-08-12 10:54:59

Hi

You might create metadata->Oracle with SID in Talend Studio as the following image.
The info above(host, port, SID) are all useful but not enough.
You also need to know the username and password at the same time.

Regards,
Pedro

Uploaded Images

Last edited by pedro (2012-08-12 10:57:31)

ienax_ridens · 2012-08-27 10:18:17

Thanks Pedro, actually I know also username and password.

I will try, thanks

Announcement

Unanswered posts

#1 2012-06-14 16:17:51

Oracle Connection

#2 2012-06-15 04:27:06

Re: Oracle Connection

#3 2012-08-10 10:33:19

Re: Oracle Connection

#4 2012-08-12 10:54:59

Re: Oracle Connection

#5 2012-08-27 10:18:17

Re: Oracle Connection

Board footer