Skip to Content

Can it be possible to load SAP hana views data into SQL using Pentaho PDI data integration tool.

Hi Folks,

Could you please someone provide me some insight on this.

Can it be possible to load the hana Views data into SQL using Pentaho PDI (data integration tool.)

I have the option load the hana views data to sql by Using SAP BODS tool but my requirement is to load the views data through PDI only.

If it is possible through PDI then please let me know the steps.

Regards,

VaraPrasad.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 13, 2017 at 10:45 AM

    Hi Vara Prasad

    Yes, it is most likely possible. I have worked on loading the data from HANA to another DB via Pentaho kettle sometime back. If you are using the same tool, there would be a step(Table) where in we can establish the jdbc connection to SAP HANA and retrieve the data by writing SQL statements.

    So you should be able to query your view by writing SQL statements.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 11, 2017 at 01:34 PM

    Vara,

    that may be something that you may want to ask on the Pentaho site perhaps. as far as BODS, as you know it allows ETL processes on different platforms, so you may need to ask whoever on the Pentaho site if that is supported or how their tool could integrate with SAP HANA.

    Add comment
    10|10000 characters needed characters exceeded