Pentaho

Dear All,

Kindly suggest whether Pentaho can write \ push data from source files to SAP BW. Data needs to be staged first and then processed into SAP Data Warehouse.

Thanks in advance.

I quick read of SAP BW it seems to be in memory backed by SAP HANA.
https://help.sap.com/doc/saphelp_nw74/7.4.16/en-us/b2/e50138fede083de10000009b38f8cf/content.htm?no_cache=true

You can use their driver and PDI to connect to Hana through strandard JDBC.
https://blogs.sap.com/2014/09/04/creating-a-connection-to-sap-hana-using-pentaho-pdi/

Normally these default JDBC drivers are fine for SELECT but really suffer on insert.  Since your use case mentioned staging and movment to DW you would likley benefit from the SAP HANA bulk loader in the EE version.

Dear All,

Kindly suggest whether Pentaho can write \ push data from source files to SAP BW. Data needs to be staged first and then processed into SAP Data Warehouse.

Thanks in advance.