0

I am trying to remove DB Connection from ktr file and I am trying to connect to DBConnection by using the properties file which contains information about the connection. I used this link as reference;

Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel.

I followed all the steps but I am not able to get the required output.

I want to connect to the database using properties file and have to excute the SQL using the DB defined in the properties file and the output has to be transfered into the output(Excel,csv,output-table etc).

Community
  • 1
  • 1
Mohan Kumar N
  • 1

1 Answers1

0

Try something like this:

1- A Index job for start all (is my way)

This job call a transformation whose job is to load the connection data to the database

Index

2- The transformation that load the connection data pass this variables like parameters

Variables

3- The middle job is only for repeat the process if is necessary, only work like a bridge, pass the parameters

Middle

4- In this transformation does all DB work

Select

5- The datasource look like this.

datasource

PS: sorry for my poor english :(

Andrés
  • 175
  • 1
  • 3
  • 9