Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: How to call SQL Server procedures - SE

  1. #1

    Thumbs up How to call SQL Server procedures - SE

    Hi,

    Can anybody give me step by step guidance for calling the sql server procedures in pentaho data integration (Kettle).

    I tried, but i don't know where i can pass the parameters.

    Please help me

    Regards,

    Elaya

  2. #2
    pstoellberger Guest

    Default

    use the "Call DB Procedure" step in a transformation
    you can define IN/OUT/INOUT parameters in there

    btw, if you want to call stored procedures remove the content of the "result name" textbox. otherwise it's trying to call a function

  3. #3

    Default

    Hi,

    Thanks for ur reply. I did what u said in tis. But still i'm not getting any output while running.

    As per ur suggestion i removed result name, result type i mentioned "string"

    under that in parameters grid i specified like tis below

    #parameters
    Name Direction Type
    1 @empno IN Numeric
    2 @empname IN String


    After that i clicked OK button, then i execute the transformations.

    Is tis the right way to calling the DB Procedures.

    Please help me...

  4. #4

    Default

    Quote Originally Posted by elayaraja_apd View Post
    ....

    #parameters
    Name Direction Type
    1 @empno IN Numeric
    2 @empname IN String

    Is tis the right way to calling the DB Procedures.
    ...
    If you have declared *all* the parameters (IN/OUT/INOUT), you should have no probs.

    Have you tried running it?
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

  5. #5
    pstoellberger Guest

    Default

    could you choose the correct stored procedure in the list you can retrieve in this step?
    are there any errors in pdi shown?
    please provide more details on that...
    for example a screenshot of this step

Tags for this Thread

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.