Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Calling webservices in pentaho

  1. #1

    Default Calling webservices in pentaho

    Hi gurus,

    I am new to pentaho. Currently we have requirement in our project to call webservices and publish the results to oracle table. Below is the detail requirement:

    we are getting State,Zipcode details as csv format from source. Now we need to populate the longitude, latitude details using webservices corresponding to that state, city and store it in table.

    I tried to understand the existing transformation in sample folder but is giving me error.

    This is urgent requirement. Please help.

    Thanks in advance.

  2. #2
    Join Date
    Jul 2009


    About a year ago, I tried to geocode addresses with a web service, and it worked, but we never implemented it. I checked the attached sample transformation, and it still works for me, so it might help you.
    Attached Files Attached Files

  3. #3


    We use an internal Webservice to read BLOB stored data from our application databases, by sending calls in a 'Web services lookup' It is an ASMX style service with a single repeating element. Works quite well.. If you need an example, then let me know..

  4. #4



    Please share the example.

  5. #5


    Hi Robj,

    Thanks for sharing example.

    While running i am getting below error...unknownhost

    Please let me know if any setting needs to be done for resolving this issue.

  6. #6
    Join Date
    Dec 2009


    Check if you can ping from your Pentaho-Machine.
    I assume your machine is not able to resolve the hostname or cannot access internet...

  7. #7


    I am not able to ping but i can access internet. can please suggest if any changes needs to be done.

  8. #8
    Join Date
    Dec 2009


    Check with your network-admins

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.