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.
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.
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.
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.