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.batOpen New TransformationCreate Access Database Connection as per the above link.Drag Execute SQL Script component.Run…
Tag: PDI
select Query using Access database in Pentaho
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…
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…
Call Pentaho Job using Batch Script
In this post, I will discuss about the “How to call the Pentaho Job in the local Machine which is windows” . To put it differently, call the Pentaho Job using batch script. Below is the sample code of the batch script. call <local_Path>\data-integration\kitchen.bat /file:<Local-Path>\Pipe-delimited-file-variables.kjb In above command, I have mentioned Path of the kitchen.bat file and then Path of the Pentaho job along with Job Name.Below is the ETL code of above Job. This job does a very simple part to load the pipe delimited file to a Table.…