This content has been marked as final. Show 4 replies
I am using QlikSense desktop v2.1.1 and I am trying to create a new connection in Data Load Editor. I am doing the following:
Create new connection > OLE DB > Provider as 'Oracle Provider for OLE DB' and then entering the credentials in the following format:
Data source (file path or server name) as <hostname>:1521/<service-name>
Then entering the username and password.
But on testing the connection, I am getting a Test Failed.
On the other hand the same details are working just fine in my Oracle SQL Developer.
Any help will be highly appreciated.
Thanks n Regards