3

I am trying connect SAP ERP System with Pentaho Data Integration tools by required properties. As like below image. But didn't connect with SAP ERP System. enter image description here

If I click on Test button then nothing saying. But, If I try to execute query then showing this error. enter image description here

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Badrul
  • 921
  • 1
  • 7
  • 16
  • what is the error you are getting? – Helping Hand.. Aug 10 '20 at 14:17
  • @HelpingHand.. If if click on Test button then noting saying. But, If I try to execute query then showing this error. https://user-images.githubusercontent.com/15130238/89793120-4a10d700-db47-11ea-87d1-12afa273a950.png – Badrul Aug 10 '20 at 14:24
  • looks more like JDBC error. What is the *plugin specific acces method*? what is this plugin? novum connector for Pentaho? Refer to the [official Pentaho troubleshooting page](https://wiki.pentaho.com/display/EAI/Connecting+with+SAP+Systems) for integration – Suncatcher Aug 11 '20 at 09:08
  • when you test the connection is it showing message of success ? @Badrul – Helping Hand.. Aug 11 '20 at 11:43
  • @HelpingHand.. If I click on Test button then it nothing says. – Badrul Aug 12 '20 at 02:14

2 Answers2

0

Try installing the drivers again. Below links should provide you some additional info.

https://blogs.sap.com/2014/09/04/creating-a-connection-to-sap-hana-using-pentaho-pdi/

https://www.danielpradilla.info/blog/how-to-connect-pentaho-data-integration-to-sap-hana/

cpatel13
  • 58
  • 4
0

The step in the background of your first screen shot, SAP ERP Table Input is not a standard Pentaho step, but a Plugin developed by IT-Novum. It is a product that has to be purchased (see here). But even that step doesn't allow direct queries using the table input step from Pentaho, it delivers its own input step. The reason is that SAP ERP doesn't allow direct database access at all, you have to retrieve data through RFC modules if you want to go through the SAP Netweaver server instead of accessing the database directly. This youtube video contains a demo around 7 minutes into the video, showing the plugin specific step.

You can use remote function modules like RFC_READ_TABLE to access tables and views with pentaho (and the sapjco library) alone, but it doesn't work through the regular Table Input step in Pentaho, you need to use the SAP Input step. And RFC_READ_TABLE has a number of limitations that make it pretty much useless for extended ETL tasks without a few modifications (see for instance this SCN thread)

If you only need to access a very small number of tables with few fields and ideally only in a few transformations, the SAP input step can help you do that. But if this a cornerstone of a large ETL process, start looking into commercial tools to help you. Or, if this is a viable alternative for you, access the database directly. But there are possible license limitations (the Oracle db licensed by SAP only allows access for the SAPSR3 user) as well as technical reasons (for instance security risks) to avoid doing that.

Dirk Trilsbeek
  • 5,873
  • 2
  • 25
  • 23