Skip to Content

Sometimes it is required to load data to a system working based on webservices.

For example for a requirement, where the downstream system is Oracle File Based Loader which demands a file from the storage Server as an
input, Web Services will be the preference for most of the users as it can handle multiple files from a single zip /archive file and load to many tables.

We would like to help you understand the simple steps to invoke web services through Data Services.

Steps involved.

  1. Create a Data Store for web services.

            Provide the link of the web services and its credentials as in below sample.

/wp-content/uploads/2014/03/1_410389.jpg

2.     Import the function to WS data store

A web service will usually comprise of many functions. The function which is needed for a particular requirement has to be imported to the
data store created for web services under its functions segment

/wp-content/uploads/2014/03/2_410408.jpg

3.     Create the Job

Create a job which will take care of the following things

/wp-content/uploads/2014/03/3_410410.jpg

The input details required for the web services can be declared as global parameters and prepare the customized columns as per the requirement. The below columns are the required columns for the sample given.

/wp-content/uploads/2014/03/4_410417.jpg

Create a nested /unnested column structure which is equivalent to the web services input data structure.

/wp-content/uploads/2014/03/5_410418.jpg

In order, to get the column structure of the web services, do the below steps.

Right click on the output schema -> New Function Call -> Select the Web services Data Store -> Select the web services function from the list which you need to invoke.

/wp-content/uploads/2014/03/6_410419.jpg

/wp-content/uploads/2014/03/7_410423.jpg

Drag and drop or key in the Input Schema name to the text box in the Input parameter Definition pop up

The success or failure of the function call can be verified using the return codes of the web services function. According to the error handling design you can divert the results to error tables.

/wp-content/uploads/2014/03/8_410424.jpg

Default return code for a successful web service call is 0.

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Lars Anderson

    Good article. I was wondering is there any documentation or samples available on how to load stream of data using a soap webservice or a REST webservice?

    (0) 
  2. Anderson Fernandes Attizano

    When I try to execute my job, I get the error:

    RUN-248005     6/11/2012 12:35:25 PM     There is no response for the web service Ensure that the network, web server, and service are running properly. Also ensure that the service client call time out is set properly.


    The webserver is not https and there is no SSL certificate.


    Can someone help me please?

    (0) 
    1. Abraham Varghese

      Hello Anderson Fernandes Attizano

      I am also getting same error.  Did you find any solution to fix this error.

      8620 5724 RUN-248005 29/09/2016 15:07:08 There is no response for the web service <upsertAccountAndContact>. Ensure that the network, web server, and service are
      8620 5724 RUN-248005 29/09/2016 15:07:08 running properly. Also ensure that the service client call time out is set properly.

      Regards,

      Vasuda.

      (0) 
  3. Vyacheslav Afonin

    Hello.
    Can you explain, how can I load data set (for example 10 rows) ┬áto soap web services. I don’t want call web service 10 times, i want to transfer 10 rows in one message.
    May be i should use option “Repeatable” or smth else?

    (0) 

Leave a Reply