Solved

Load Data into Oracle from web service call

Posted on 2010-11-22
3
670 Views
Last Modified: 2012-05-10
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
Comment
Question by:vemi007
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
gatorvip earned 125 total points
Comment Utility
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
 

Author Comment

by:vemi007
Comment Utility
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
 

Author Closing Comment

by:vemi007
Comment Utility
Lists part of the options that  am looking for hence grade B.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now