Grokbase › Groups › Hadoop › impala-user › March 2013
FAQ
I have tried to connect impala from oracle BI admin tools on Windows 7, but
can not import metadata from the impala source. I could see the impala
source, but can not get the table metadata within the oracle BI admin.
I followed the odbc instructions on the cloudera odbc web page and use the
MicroStrategy odbc connector for windows. Does anyone successfully use
impala as data source in OBIEE, please give me some help.

BTW, is there a plan for cloudera to provide a impala connector for OBIEE?
If so, and when? OBIEE is a very popular report/analyse tool, I think it
will be a big market if we can get it through.

Search Discussions

  • Gu Ping at Mar 15, 2013 at 2:03 am ⇧
    Thanks Justin, can we expect this feature before the end of June? If not,
    we should seek other solution...
    On Friday, March 15, 2013 4:43:45 AM UTC+8, Justin Erickson wrote:

    OBIEE isn't yet validated with Hive or Impala yet. We're actively engaged
    on this with the OBIEE team.


    On Thu, Mar 14, 2013 at 7:11 AM, Gu Ping <[email protected] <javascript:>>wrote:
    I have tried to connect impala from oracle BI admin tools on Windows 7,
    but can not import metadata from the impala source. I could see the impala
    source, but can not get the table metadata within the oracle BI admin.
    I followed the odbc instructions on the cloudera odbc web page and use
    the MicroStrategy odbc connector for windows. Does anyone successfully use
    impala as data source in OBIEE, please give me some help.

    BTW, is there a plan for cloudera to provide a impala connector for
    OBIEE? If so, and when? OBIEE is a very popular report/analyse tool, I
    think it will be a big market if we can get it through.
  • Gu Ping at Mar 15, 2013 at 2:03 am ⇧
    Thanks Justin, can we expect this feature before the end of June? If not,
    we should seek other solution...
    On Friday, March 15, 2013 4:43:45 AM UTC+8, Justin Erickson wrote:

    OBIEE isn't yet validated with Hive or Impala yet. We're actively engaged
    on this with the OBIEE team.


    On Thu, Mar 14, 2013 at 7:11 AM, Gu Ping <[email protected] <javascript:>>wrote:
    I have tried to connect impala from oracle BI admin tools on Windows 7,
    but can not import metadata from the impala source. I could see the impala
    source, but can not get the table metadata within the oracle BI admin.
    I followed the odbc instructions on the cloudera odbc web page and use
    the MicroStrategy odbc connector for windows. Does anyone successfully use
    impala as data source in OBIEE, please give me some help.

    BTW, is there a plan for cloudera to provide a impala connector for
    OBIEE? If so, and when? OBIEE is a very popular report/analyse tool, I
    think it will be a big market if we can get it through.
  • Jonas Kemper at May 21, 2013 at 9:17 am ⇧
    hey, any news on this? i want tp connect impala 1.0 to obiee, too!

    Am Donnerstag, 14. März 2013 15:11:47 UTC+1 schrieb Gu Ping:
    I have tried to connect impala from oracle BI admin tools on Windows 7,
    but can not import metadata from the impala source. I could see the impala
    source, but can not get the table metadata within the oracle BI admin.
    I followed the odbc instructions on the cloudera odbc web page and use the
    MicroStrategy odbc connector for windows. Does anyone successfully use
    impala as data source in OBIEE, please give me some help.

    BTW, is there a plan for cloudera to provide a impala connector for OBIEE?
    If so, and when? OBIEE is a very popular report/analyse tool, I think it
    will be a big market if we can get it through.
  • Jonas Kemper at May 22, 2013 at 7:10 am ⇧
    hi all, i tried it on my own, but now i am stuck when adding the odbc
    source.

    the provided imapla odbc driver for microstrategy is only 32bit.

    when i install it on my system and add it as a data source i can't see it
    in the BI Administration tool, there are only 64bit odbc sources...

    is there any 64bit odbc impala driver which i can use?

    JK


    Am Dienstag, 21. Mai 2013 11:17:31 UTC+2 schrieb Jonas Kemper:
    hey, any news on this? i want tp connect impala 1.0 to obiee, too!

    Am Donnerstag, 14. März 2013 15:11:47 UTC+1 schrieb Gu Ping:
    I have tried to connect impala from oracle BI admin tools on Windows 7,
    but can not import metadata from the impala source. I could see the impala
    source, but can not get the table metadata within the oracle BI admin.
    I followed the odbc instructions on the cloudera odbc web page and use
    the MicroStrategy odbc connector for windows. Does anyone successfully use
    impala as data source in OBIEE, please give me some help.

    BTW, is there a plan for cloudera to provide a impala connector for
    OBIEE? If so, and when? OBIEE is a very popular report/analyse tool, I
    think it will be a big market if we can get it through.
  • Jonathan Seidman at May 22, 2013 at 3:10 pm ⇧
    Jonas – as Justin mentioned earlier in the thread, best thing right now is
    to ping your Oracle rep on access to a driver that's compatible with OBIEE
    until we're able to provide access to a 64-bit driver.

    Thanks.

    Jonathan

    ---
    Jonathan Seidman
    Solutions Architect | Partner Engineering | Cloudera, Inc.
    773-316-9614
    @jseidman
    skype: jaseidman

    On Wed, May 22, 2013 at 2:10 AM, Jonas Kemper wrote:

    hi all, i tried it on my own, but now i am stuck when adding the odbc
    source.

    the provided imapla odbc driver for microstrategy is only 32bit.

    when i install it on my system and add it as a data source i can't see it
    in the BI Administration tool, there are only 64bit odbc sources...

    is there any 64bit odbc impala driver which i can use?

    JK


    Am Dienstag, 21. Mai 2013 11:17:31 UTC+2 schrieb Jonas Kemper:
    hey, any news on this? i want tp connect impala 1.0 to obiee, too!

    Am Donnerstag, 14. März 2013 15:11:47 UTC+1 schrieb Gu Ping:
    I have tried to connect impala from oracle BI admin tools on Windows 7,
    but can not import metadata from the impala source. I could see the impala
    source, but can not get the table metadata within the oracle BI admin.
    I followed the odbc instructions on the cloudera odbc web page and use
    the MicroStrategy odbc connector for windows. Does anyone successfully use
    impala as data source in OBIEE, please give me some help.

    BTW, is there a plan for cloudera to provide a impala connector for
    OBIEE? If so, and when? OBIEE is a very popular report/analyse tool, I
    think it will be a big market if we can get it through.
  • Justin Erickson at May 22, 2013 at 6:28 pm ⇧
    OBIEE uses their own driver to connect to CDH. With Oracle Business
    Intelligence Foundation Suite 11g, Release 11.1.1.7.0, OBIEE can now
    connect to CDH through Hive:
    http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/whats-new-bi-fs-1931213.pdf

    Sorry for partner confidentiality reasons I cannot share information about
    Impala integration. Please contact your Oracle representative as they may
    be able at liberty to share more information about the OBIEE and Cloudera
    integration efforts.

    Thanks,
    Justin

    On Wed, May 22, 2013 at 8:10 AM, Jonathan Seidman wrote:

    Jonas – as Justin mentioned earlier in the thread, best thing right now is
    to ping your Oracle rep on access to a driver that's compatible with OBIEE
    until we're able to provide access to a 64-bit driver.

    Thanks.

    Jonathan

    ---
    Jonathan Seidman
    Solutions Architect | Partner Engineering | Cloudera, Inc.
    773-316-9614
    @jseidman
    skype: jaseidman

    On Wed, May 22, 2013 at 2:10 AM, Jonas Kemper wrote:

    hi all, i tried it on my own, but now i am stuck when adding the odbc
    source.

    the provided imapla odbc driver for microstrategy is only 32bit.

    when i install it on my system and add it as a data source i can't see it
    in the BI Administration tool, there are only 64bit odbc sources...

    is there any 64bit odbc impala driver which i can use?

    JK


    Am Dienstag, 21. Mai 2013 11:17:31 UTC+2 schrieb Jonas Kemper:
    hey, any news on this? i want tp connect impala 1.0 to obiee, too!

    Am Donnerstag, 14. März 2013 15:11:47 UTC+1 schrieb Gu Ping:
    I have tried to connect impala from oracle BI admin tools on Windows 7,
    but can not import metadata from the impala source. I could see the impala
    source, but can not get the table metadata within the oracle BI admin.
    I followed the odbc instructions on the cloudera odbc web page and use
    the MicroStrategy odbc connector for windows. Does anyone successfully use
    impala as data source in OBIEE, please give me some help.

    BTW, is there a plan for cloudera to provide a impala connector for
    OBIEE? If so, and when? OBIEE is a very popular report/analyse tool, I
    think it will be a big market if we can get it through.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedMar 14, '13 at 2:11p
activeMay 22, '13 at 6:28p
posts7
users4
websitecloudera.com
irc#hadoop

4 users in discussion

Gu Ping: 3 posts Jonas Kemper: 2 posts Jonathan Seidman: 1 post Justin Erickson: 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase