Pentaho 8 - Tutorial 4 - Getting data from a database by running a query built at runtime
Pentaho 8 - Tutorial 4 - Getting data from a database by running a query built at runtime 1. Create a transformation. 2. The column that will define the order of the rows will be a named parameter. 3. Now drag a Table Input step to the canvas. Then create and select the connection to the customers's database. 4. In the SQL frame type the following statement: SELECT CUSTOMERNUMBER , CUSTOMERNAME , CONTACTLASTNAME , CONTACTFIRSTNAME , PHONE , ADDRESSLINE1 , ADDRESSLINE2 , CITY , STATE , POSTALCODE , COUNTRY , SALESREPEMPLOYEENUMBER , CREDITLIMIT FROM CUSTOMERS WHERE CUSTOMERNUMBER = ${pCUSTOMERNUMBER} 5. Check the option Replace variables in script? and close the window. 7. After saving the tranformation, we are passing value 114 and run the transformation. 8. Now try again. Press F9 to run the transformation one more time. 9. This time, change the value of the pCUSTOMERNUMBER parameter typing genre as the new value. 10. Press the Launch button. I hope you understand how we get the data from database using runtime variable in the Table Input step. Thanks For Watching the Video. Please don't forget to subscribe our channel. :)
Pentaho 8 - Tutorial 4 - Getting data from a database by running a query built at runtime 1. Create a transformation. 2. The column that will define the order of the rows will be a named parameter. 3. Now drag a Table Input step to the canvas. Then create and select the connection to the customers's database. 4. In the SQL frame type the following statement: SELECT CUSTOMERNUMBER , CUSTOMERNAME , CONTACTLASTNAME , CONTACTFIRSTNAME , PHONE , ADDRESSLINE1 , ADDRESSLINE2 , CITY , STATE , POSTALCODE , COUNTRY , SALESREPEMPLOYEENUMBER , CREDITLIMIT FROM CUSTOMERS WHERE CUSTOMERNUMBER = ${pCUSTOMERNUMBER} 5. Check the option Replace variables in script? and close the window. 7. After saving the tranformation, we are passing value 114 and run the transformation. 8. Now try again. Press F9 to run the transformation one more time. 9. This time, change the value of the pCUSTOMERNUMBER parameter typing genre as the new value. 10. Press the Launch button. I hope you understand how we get the data from database using runtime variable in the Table Input step. Thanks For Watching the Video. Please don't forget to subscribe our channel. :)