I am trying to create a new data server in ODI.
When I look at the JDBC tab,it gives me: jdbc:odbc:thin:@host:port:sid. Can I use the service name value I have in my tns entries for the sid over here?
What is the difference between the two?
I think you cannot use service name in the JDBC URL, because the driver is designed in that way to communicate with database through ODI.
SID is an unique name of a Instance and service name is an alias to an instance.
Using Service name in the driver should work .