I have some problems if I want to connect to oracle with a service name.
When I put in the connection fields for oracle
Host: s0048
Port: 1521
Database: B1.s0048.world
there exists an error. I know that the Database B1.s0048.world isn't an SID. But how can I put a servicename in front of the sid?
I tried also:
jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=s0048)(port=1521))(connect_data=(service_name=B1.s0048.WORLD)))
because that works with talend open studio but in etl server doesn't work.
Has anyone an idea to solve?
Thanks
When I put in the connection fields for oracle
Host: s0048
Port: 1521
Database: B1.s0048.world
there exists an error. I know that the Database B1.s0048.world isn't an SID. But how can I put a servicename in front of the sid?
I tried also:
jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=s0048)(port=1521))(connect_data=(service_name=B1.s0048.WORLD)))
because that works with talend open studio but in etl server doesn't work.
Has anyone an idea to solve?
Thanks