CODEWITHSUNDEEP
insertpentahokettlepdi
Rojin
Rojin

Reputation: 365

Pentaho: Insert a set of dynamic records into a database

Using Pentaho, I would like to SELECT a number of records from a database and INSERT them into another one. I have no problem with the first part and using Input Table step, I have selected my desired records. But I have no idea about how to develop a step in Pentaho that takes care of inserting these records into the second database. Can anyone please guide me with that?

Upvotes: 1

Views: 695

Answers (1)

Venkatesh Panabaka
Venkatesh Panabaka

Reputation: 2154

Dynamic records we can easily insert in to another database. By using parameters.

=> Database join step:- Write one sql like based on your requirement. Eg:- select * from table_name where column_name = ?

=> Table output step:- Here create another database connection. And then select map the fields.

Note:- You can't use table input step for dynamics record (i.e you can't write parameter based sql's).

Thank you.

Upvotes: 1

Related Questions