Skip to Content

Hadoop multi-source connection in IDT 4.2

Hoping someone can help me out or point me in the right direction with issues related to a multi-source UNX universe on top of Hadoop.

I'm trying to create multi-source universe in IDT having two different data sources, one pointing to oracle and other to Hadoop.

While creating a new data foundation layer for these two connections, I’m getting error for Hadoop connection alone as: "This data source is not supported in multi-source enabled data foundations".
Below is the version used:
BO Environment : BI 4.2 SP3
Database Middleware : Cloudera Impala 2.0 - Simba JDBC

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 18, 2017 at 08:45 AM

    check sap note 1930855 - Cannot create Multi Source Universe on Hadoop 0.9 in BI 4.1 IDT.

    Your version is higher but you can try with mentioned steps in note.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2017 at 09:27 AM

    Yes, I've already tried those options but didn't work. I'm also not able to identify whether latest fix is available in my version.

    From the link:https://wiki.scn.sap.com/wiki/display/BOBJ/Apache+Hadoop+Hive+Connection+With+Information+Design+Tool, I got a document on list of supported Hadoop hive versions. But I couldn't see BI 4.2 version itself.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2017 at 06:19 AM

    I've raised a ticket with SAP and got reply that Hadoop multi-source universe is not supported in BI 4.2 SP3. Even it's not available in next patch and also not sure on the fix with future releases.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2017 at 07:15 PM

    Hi,

    We have created a relation connection through Cloudera Impala 2.0 - Simba JDBC driver on Cloudera Hadoop Impala and we have seen some performance issues so I am just checking if any optimized configuration parameters can be used in the IDT connection.

    Add comment
    10|10000 characters needed characters exceeded