Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SAP Input with paremeters

  1. #1

    Default SAP Input with paremeters

    Hello,

    I want to use SAPInput with from date and to date parameters and output data in json format.
    For this i have added sapjco libs, connection is working fine.

    In SAP input, I put my function ZRFC_FETCH_COLLECTIONS,
    After that input populated as follows,

    Code:
    Field             SAP Type    Table/Struct    SAP Parameter Name    Type
    DATE_FROM            Single                           DATE_FROM             Date
    DATE_TO                Single                           DATE_TO                Date
    and output populated as follows

    Code:
    SAP Field    SAP Type    Table/Struct    New Name    Type
    TYPE          Structure    RETURN             TYPE    String
    CODE          Structure    RETURN             CODE    String
    MESSAGE     Structure    RETURN           MESSAGE    String
    LOG_NO        Structure    RETURN          LOG_NO    String
    LOG_MSG_NO    Structure    RETURN     LOG_MSG_NO    Integer
    MESSAGE_V1    Structure    RETURN     MESSAGE_V1    String
    MESSAGE_V2    Structure    RETURN     MESSAGE_V2    String
    MESSAGE_V3    Structure    RETURN     MESSAGE_V3    String
    MESSAGE_V4    Structure    RETURN     MESSAGE_V4    String
    DOMESTIC    Table    COLLECTION       DOMESTIC    String
    EXPORT      Table      COLLECTION          EXPORT    String
    OTHERS     Table      COLLECTION        OTHERS    String

    from output i removed all other and kept only three domestic,export and others as I need only these field as out put

    I have taken json output after this field for Json format output and given file name.

    When I run this transformation. I got blank data json.

    Code:
    {"data":[]}
    And it never asked to pass values for input parameters DATE_FROM and DATE_TO.

    I want to know how it can be used. Here is my transformation diagram.

    Name:  tranformation diagram.jpg
Views: 94
Size:  8.7 KB



    I am newbie at Kettle transformations.

    Thanks,

    Swapnil

  2. #2

    Default

    Please help. No one knows this?
    Last edited by swapnilwarekar; 07-18-2012 at 01:45 AM.

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.