Microsoft Access input Component in Pentaho

Today, I will discuss about the Microsoft Access input component in Pentaho. There are many times we as developers comes across the scenario where we need to write the Sql to join the multiple tables in Access db. So, we tend to use either table input or Sql component to achieve the same by creating database connection for Access db. I tried this multiple times but it didn’t worked for me.

Second way to handle the multiple table joins in Access db is  to write the Sql query in Access db itself and you can convert that query into table. Fetch  the data from this derived table  using Microsoft Access input component. But what if you as a developer does not have permissions to change  or create any table in Access db. Then above mentioned solution will not work as well.

Now, we will use Microsoft Access input component multiple times to achieve the same. See the below image.

Here, I have created two tables in Access. one is emp_details and another is emp_salary_Details. Below is the image for the same.

Now, use Microsoft Access input  twice to get data from these tables. After that  sort component is added to sort the data on emp_id. Eventually use merge join (use INNER JOIN ) on condition Emp_details.Emp_id=Emp_salary_Details.Emp_id.  Hence we join the two tables in Access db using Microsoft Access input and Merge join component.

Added the Microsoft Access db file and ktr in git. Below is the path for the same.

Hotels [CPS] IN

Mircosoft Access


Related posts

7 Thoughts to “Microsoft Access input Component in Pentaho”

  1. la idea muy buena
    [url=]Rexuiz FPS[/url]

  2. I have been browsing online greater than three hours today, yet I by no means discovered any attention-grabbing article like yours. Its lovely price sufficient for me. In my view, if all site owners and bloggers made good content as you did, the internet will be a lot more helpful than ever before.

  3. Im impressed, I need to say. Really rarely do I encounter a blog thats both educative and entertaining, and let me tell you, you have hit the nail on the head. Your concept is outstanding; the difficulty is something that not enough people are speaking intelligently about. I am very glad that I stumbled across this in my seek for something regarding this.

  4. Concesso, questo ГЁ meraviglioso informazioni
    [url=]katie kox naked[/url]
    [url=]lezbian heels[/url]
    [url=]crack nympho[/url]

  5. Merci immense pour l’explication, maintenant je n’admettrai pas une telle erreur.
    [url=]uk massage parlour[/url]
    [url=]baby gay freeporn movie[/url]
    [url=]imagenpornos con mujeres pochos grandes[/url]
    [url=]arab kim[/url]
    [url=]tight anal mpegs[/url]

Comments are closed.