Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SAP Input and Parameters

  1. #1
    Join Date
    Mar 2017
    Posts
    4

    Question SAP Input and Parameters

    Quote Originally Posted by johanhammink View Post
    As mentioned in this post there are examples subfolder \samples\transformations\
    But here is an example getting data from BSEG with year >= 2012

    Hello Johan thank you so much for share this step, but i have a question about it, i am working with RFC in SAP and this RFC call a query, I can execute the RFC and the query send to Kettle the correct data, but i need to send an interval date, because the query give default data from 2009/05/01 to 2009/05/30, but i want the data from de last 10 days, so i dont know how can i do this?, the variant's SAP query accept params to define this interval but in the step i cant found how send it...

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    I never worked with SAP queries with params. You can try to set the OPTIONS value to something like param1=2009/05/21; param2=2009/05/31
    Then you should get the last ten days of May

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.