CODEWITHSUNDEEP
databasepentahokettledata-integration
Rafael Angarita
Rafael Angarita

Reputation: 787

Data Integragration with Pentaho Kettle

I have three input components:

  1. Excel Input
  2. XML Input
  3. Table Input

I would like to do some validation and verification before inserting the integrated data into a data base.

Which component should I use for the data transformation/verification?

Upvotes: 0

Views: 94

Answers (2)

t3b4n
t3b4n

Reputation: 632

There are several aproaches to achieve the verification. The easiest one is to code your validations using the "Modified java script value" step, but it's the most resource hungry, so Pentaho recommends avoiding it if you can. So you can use others steps, like the ones under the "flow" category.

Upvotes: 0

Rishu S
Rishu S

Reputation: 3968

Try using the Data Validator step in PDI. Here you can validate the rows that are coming in from the Input step either using the inbuilt validator or even using regular expressions.

Hope it helps :)

Upvotes: 1

Related Questions