KNOWLEDGE BASE

Unable to connect Tableau to Oracle Hyperion HSF and HFM


Published: 16 Sep 2013
Last Modified Date: 24 Jun 2021

Issue

Unable to connect to Oracle Hyperion Strategic Finance and Hyperion Financial Management

Environment

  • Tableau Desktop
  • Tableau Server
  • Oracle Hyperion Financial Management (HFM)
  • Oracle Hyperion Strategic Finance (HSF)

Resolution

Workaround

  1.  Export Oracle Hyperion Financial Management Data into Essbase cube using Data Management first, then Tableau Desktop or Tableau Server could connect to Essbase.
  2.  Create data extracts out of Oracle Hyperion Financial Management first, then Tableau Desktop or Tableau Server connect to the extract.
  3. Use Generic ODBC to connect to Hyperion Financial Management relational database.

Cause

The ability to connect to Oracle Hyperion Strategic Finance and Hyperion Financial Management is not currently built into the product.

Additional Information

Limitations in support and compatibility with Generic ODBC data connection. 

Exporting Data Using Data Management

 Hyperion Strategic Finance contains multiple databases for storing entities. It's not feasible to connect Tableau Desktop to Hyperion Strategic Finance application via generic ODBC.
Did this article resolve the issue?