How to run a select on Pentaho

Asked

Viewed 124 times

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:

Table Input

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.

Editando table input

Then click PREVIEW. If Pentaho returns a list, the configuration is valid and the Input Step has been built effectively.

Example of PREVIEW:

Exemplo 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).

Source

Browser other questions tagged

You are not signed in. Login or sign up in order to post.