In this Blog, I will discuss about ” How to Query the access database tables in Pentaho”. In my previous blog, where I have explained how to create Access database connection in Pentaho. Please go through this blog to have better understanding on Access database in Pentaho.
I created one sample table(Table1) in Access database(Access_Sample_DB.accdb) and inserted two records. See the below SS.
Open Pentaho using spoon.bat . Open New Transformation and drag “Table Input” Component and select the Access Database Connection.
Write the simple select Query to fetch records from Table1.