• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query to Connect to Oracle Database

Hi,

Below is the URL I use to connect to Oracle database in Squirrel SQL. What is the Server name that I need to give for connecting to Oracle Database from Power Query. Kindly help here. I have installed Oracle Addin and Power Query add in.

URL : jdbc:eek:racle:thin:mad:(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = qa-skyhawk-sc01.abcd.com)(PORT = 19123))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = edmsqa.abcd.com)))
 

Chihiro

Excel Ninja
There are few things you need to be aware of...
1. You should have "Oracle.DataAccess.Client" installed. There may be legacy connector present, but that's been deprecated by MS.
2. Bitness of connector/client and PowerQuery/Excel must match. I.E. 32 bit or 64 bit.

Then there are few things you can try for your Sever:
1. ServerName/SID
2. ServerName/ServiceName
Where service name is alias used when connecting.
3. If still having trouble, use following string (replace values).
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_num))(CONNECT_DATA=(SERVICE_NAME=service_name)))
 
Top