Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Using Kettle as SQL Workflow Tool

  1. #1
    Join Date
    Dec 2016
    Posts
    1

    Default Using Kettle as SQL Workflow Tool

    Hi, we are trying to automate a workflow of several stored procedures that execute in a defined order and have different parameters to pass into each. We are finding this to be very problematic and are finding using parameters with the stored procedures very clunky and error prone. Is there a set way to achieve this in kettle? Should we stick with SSIS to do this as kettle appears to be better with traditional ETL rather than RDBMS ELT activity. Thanks in advance for any input.

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    You can pass variables into steps like the SQL step in a job, so you could string together several stored procedures as steps in a job, passing the parameters into each of them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.