We have our data on Oracle exadata in on of the Remote Oracle servers. We have two IP addresses, one Internal and one external to connect the the data base.
But when i try to add the Data source in BI Publihser, i couldn't connect.
I am using the connecting like below
I used both internal and external IP addresses here, but both didnt work. Please help.
Try to use the answer from following doc at page 12:
replace usual jdbc connection like jdbc:oracle:thin:@host:port:sid by
You can consult with your DBAs about proper content of connection string.
Drop points if helps