You are not logged in.
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?
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:
(ADDRESS = (PROTOCOL = TCP)(HOST = server_name)(PORT = 1521))
(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.
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.
Last edited by pedro (2012-08-12 10:57:31)