search

rvalyi / terminatooor

Brute force your OpenERP data integration with OOOR inside the Kettle ETL (aka Pentaho Data Integration - PDI)
Other
38 stars 10 forks source link

Use variables or transformation parameters in Start Script? #6

Closed sdepablos closed 13 years ago

sdepablos commented 14 years ago

I'd like to use some variables passed from the previous step in the Start Script, but every time I try it it says that the variable does not exist, so I could only use them on the Transformation Script. How should I pass to Terminatooor then the connection parameters (user / pass / host) for the Ooor.new?

rvalyi commented 13 years ago

Steps have their own Ruby variable scopes. The reason is that steps are potentially multi-threaded so you don't want a mess.

What you should do is to define new output step fields in Ruby in the first step (just like Javascript transfos) than you can then reuse in a later transfo, that's a common technique. Does it fit your requirement?

sdepablos commented 13 years ago

Ok, I think it solves it.