lunedì 6 maggio 2013

Tip: How to specify Service Name in JDBC Connection

I needed to specify a new Oracle Database Connection in ODI. I have always used SIDs to configure JDBC connections.


Changing the SID for Service Name requires a minor syntax change. You have to replace the semicolon with a slash:

jdbc:oracle:thin:@<hostname>:<port>/<Service Name>

Nessun commento:

Posta un commento