Tag: table input in pentaho

call stored procedure using Table Input component in Pentaho

admin

Today, I will discuss about the scenario which might comes in someone’s development phase wherein we need to call procedure or function using Table input component. Here, I have created the sample function and procedure using sql server Database. See the code snippets. See the Data which is present in the TBL_DIM_CUSTOMER Now, we will call function using select statement inside Table input component. See the below SS. Here , I have passed customer_id value as 5. Click on Preview, you will get required result. In the similar Fashion, we…