2
I would like to know how I execute sql commands on So, I need to search certain data giving select but I already used table input and sql query and it didn’t work.
1 answer
1
1 - Insert a STEP Table Input
As an example below:
2 - Edit STEP Table Input
In this step we need to configure the database (it is also important to test connectivity). The configuration of the bank is outside the scope of the question, however it is very intuitive. Eventually it may be necessary to install a driver for connection.
The SQL field must contain the query you have assembled.
Then click PREVIEW. If Pentaho returns a list, the configuration is valid and the Input Step has been built effectively.
Example of PREVIEW:
3 - Table Output To effectively perform some interaction with the data, you must add subsequent Steps, which manipulate the data or generate some output (outside the scope of the question). I suggest a Table Output or File Output (just to illustrate).
Browser other questions tagged pentaho job transform
You are not signed in. Login or sign up in order to post.