I'm trying to set up an oracle extractor. It requires SID but I have HOST and SERVICENAME. Is there a way to use those instead?

i haven’t’ used the oracle extractor, but depending on the oracle client you can usually use this format to connect …

jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME

in place of a SID.

@//HOSTNAME:PORT/SERVICENAME

… is the important part. good luck !

that will not work.

no problem, was just a suggestion, i haven’t queried an oracle database for a few years 🙂