-1

I'm new to the pentaho etl jobs .. I need to get data from excel and pass the excel sheet value to MySQL query as parameter. If it's possible in etl pentaho jobs .. any know please help me

Sridhar Lovevirus
  • 1
  • 2

2 Answers2

0

You create a transformation and use 'Microsoft Excel' as your input, make whatever transformation you need to do and add 'Table output' as you destination where you define your database connection. That's all.

Thomas Steinhaeuser
  • 21
  • 2
0

as per understanding of your problem your parameters are defined in excel file and you want to use it in sql step.

You create a transformation and use 'Microsoft Excel' as your input, use 'set variable' and then use them as part of sql query parameters dynamically

NK0709
  • 56
  • 4