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…