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…
Tag: Access database in Pentaho
Create Access Database Connection In Pentaho
In this Blog, I will discuss about “how to establish Access Database Connection in Pentaho”. In order to achieve this, Please follow the below steps.STEP-1 : Create Access Database in your local Machine. Go to Access->Blank Database . Give an appropriate name to the database. See the below SS for the same. Once you click on Create Button, Accesss_Sample_DB.accdb will be created. NOTE : You need to have a minimum one table in Access database. STEP-2: Download the access database JDBC Drivers from the below location. Unzip the file and…