In this Blog, I am going to discuss about “How to delete data from Access Database using Pentaho ETL tool”. In order to understand how to setup Access Database connection in Pentaho, you can use this link for the same.
In order to delete data from Access table, consider a table Table1 in a Access Database (Access_Sample_DB.accdb) having two rows .
Follow below steps in order to delete record from Table1 Access table.
Open Pentaho workspace using spoon.bat
Open New Transformation
Create Access Database Connection as per the above link.
Drag Execute SQL Script component.
Run the below Command
delete from Table1 where id=2
Check the same in Access itself.