Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

Load Data into Oracle from web service call

Please check my scenario below and recommend options to load data into Oracle 10g database.

I have a external vendor that will provide data via a web service call. Which means i can access data residing on a extranet website by making a web service call. I need to know how to integrate this call into Oracle ? I mean I want a feature within Oracle 10g that accepts a web service call and "somehow" pulls that data from the web service call and import that data into our oracle table ( 1 table for now).

Your answers are much appreciated.
0
vemi007
Asked:
vemi007
  • 2
1 Solution
 
gatorvipCommented:
There's no single answer to this, as there are many different approaches. What kind of web service do you deal with? Is the "call" supposed to insert data into a single table?

Here are a couple articles describing how to consume data via SOAP
http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php
http://www.oracle-base.com/articles/10g/utl_dbws10g.php
0
 
vemi007Author Commented:
I do not have many details yet, I am expecting that the web service provides functionality to pull data from the remote site. Data will be sent in an XML format which is accompanied by an XSD document to parse the document.
0
 
vemi007Author Commented:
Lists part of the options that  am looking for hence grade B.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now