Hi all, It's my first time using Meltano and I'm ...
# troubleshooting
d
Hi all, It's my first time using Meltano and I'm trying to do a PoC using Oracle as an origin. Tried to config the tap-oracle but found out it only works with SID? The actual user we have access with works out only with Service Name in stead of SID. Do you know if there is any way to make the tap work with this? Or would it be necessary to modify the tap? For reference, this is the tap I'm using (The pipeline-wise tap) https://github.com/transferwise/pipelinewise-tap-oracle#readme Thanks in advance
I guess what I need is changing this here to named argument service_name
s
Have you tried looking from memory at v$database or v$instance to get the name of the instance. We normally connect by a service name but I have been able to successfully connect to tap-oracle via the instance name as well.