# Assistance connecting to SAP BO Data warehouse with .jar file

**URL:** <https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578>\
**Category:** KNIME Analytics Platform\
**Created:** [November 15, 2011, 10:17pm UTC](https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578 "2011-11-15T22:17:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![TonyC](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/cdc98d/32.png) [@TonyC](https://forum.knime.com/u/TonyC)\
**Post date:** [November 15, 2011, 10:17pm UTC](https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578/1 "2011-11-15T22:17:12Z")

</div>

I would like to connect to a SAP BO data warehouse running on an Oracle 10. db. Can anyone help me wiht what .jar files I need to setup in Knime from the BO folder 4.0\common folder.

Seems that SAP business objects supplies needed .jar files. Any help would be greatly appreaciated.

&nbsp;

Thanks

Tony

---

<div class="post-metadata">

**Author:** ![Ergonomist](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ergonomist/32/2122_2.png) [@Ergonomist](https://forum.knime.com/u/Ergonomist)\
**Post date:** [November 17, 2011, 12:38pm UTC](https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578/2 "2011-11-17T12:38:59Z")

</div>

Hi Tony,

The way I read this is that you expect to be able to access the BO universes instead of the unterlying DB tables? I'd be delighted if that worked, but I must say I have my doubts that it will. Maybe via JavaSnippets, but given that BO universes are no standard JDBC data sources I guess a DB reader integration is highly unlikely to work out of the box.

You best bet is probably the connection to the underlying Oracle DBs, skipping the business logic layer BO provides. Please correct me if I'm wrong, though.

Cheers  
 E

---

<div class="post-metadata">

**Author:** ![TonyC](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/cdc98d/32.png) [@TonyC](https://forum.knime.com/u/TonyC)\
**Post date:** [November 17, 2011, 8:08pm UTC](https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578/3 "2011-11-17T20:08:41Z")

</div>

E.&nbsp;

You might be correct, but BO has a Java front end to build query via web login, so this may be all possible using the right jar files. Would be very slick if I can figure out how to get it all to work. I believe I need to setup knime to use the jar files under the data connections of preferences. I have been trying 1 by 1 to get loged in and still have afew to go between waiting for querys to run.

Tony

---

<div class="post-metadata">

**Author:** ![Ergonomist](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ergonomist/32/2122_2.png) [@Ergonomist](https://forum.knime.com/u/Ergonomist)\
**Post date:** [November 18, 2011, 1:38pm UTC](https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578/4 "2011-11-18T13:38:45Z")

</div>

Makes me wonder: Are these JARs JDBC-compliant? Does the query follow an SQL syntax? If the answer to any of these two is "no", I would bet that at least some node customisation is needed. It'd be neat to get it to work, though.

E

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:16pm UTC](https://forum.knime.com/t/assistance-connecting-to-sap-bo-data-warehouse-with-jar-file/1578/5 "2023-06-23T20:16:38Z")

</div>


