0

Is there a way to connect to an Oracle Essbase Server using Power Query for Excel to extract data?

1

From here:

  • In the POWER QUERY ribbon tab, click From Database > From Oracle
    Database.
  • In the Oracle Database dialog box, in Server Name specify the Oracle Server to connect to. If a SID is required, this can be specified in the form of “ServerName/SID”.

  • If you want to import data using native database query, specify your query in the SQL Statement box.

  • Click OK.
  • If the Oracle server requires database user credentials:
    • In the Access a Database dialog box, enter your username and password.
    • Click Save.
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.