how to connect Hyperion Essbase through ODBC

[Anonymous]

Hi friends,

is there any way to connect Hyperion Essbase through ODBC in Power BI ?

how to get and install Hyperion Essbase ODBC driver in windows ?

Hyerion Essbase details:

hyperion server- http://host:port/aps/Essbase

Service account username -xxxxxx

Password-XXXXX

appriciate your suggestions.

[Anonymous · Accepted solution]

Hi All,

i have analyzed about this and identified that currently Oracle Hyperion not support ODBC based data extraction.

[v-shex-msft]

HI @Anonymous,

For creating odbc driver, you can refer to the following document:

Creating ODBC DRIVER 

BTW, current power bi already provides the Essbase connector on the desktop side, why not try this one to get data from your database?

Power BI - steps to connect Essbase using Essbase Connector (beta) 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi v-shex-msft, 

am trying to create dataflow with Hyperion based ODBC based gateway. So am plannig to install ODBC drivers on gateway server. but i did not find any way to the setup of ODBC.

[v-shex-msft]

Hi @Anonymous,

AFAIK, odbc connector also availed on power bi dataflows.

Power bi ODBC connector

You need to install the driver on the gateway server and make sure it can access to the remote data source. Which steps did you confuse to finish these configurations?

Installing and Configuring an ODBC Driver in Windows 10 (32 / 64-bit) 

Regards,

Xiaoxin Sheng