XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Art ZegarekSubject: Can Stylus Studio be used to map XML to load Oracle
Author: Art Zegarek
Date: 10 Feb 2007 11:31 PM
I am looking for a tool to map XML data to load into various Oracle relational schema's. Can Stylus Studio map from XML to the database? I was looking at Altova Mapforce - which was getting terrible reviews. Stylus Studio seems like a very well received product, but I do not see where it can be used to update/load into a relational DB.

Postnext
swarooparani srSubject: Can Stylus Studio be used to map XML to load Oracle
Author: swarooparani sr
Date: 13 Feb 2007 07:39 AM
Originally Posted: 13 Feb 2007 05:41 AM
even i have the same problem

Can anyone guide me I have the following problem

our project is already developed one

source data is in xml

and a tool(with xml parsing) converts xml(selected data) into text format

then text format is taken as source data for my oracleDB...

from there onwards everything is ok

here starts my questions

1. I want to directly load this xml data into my Oralce database(form of tables and columns) and i want to make reporting..(with what ever tool doesnt mind)..

can anyone guide me how can I do that and...i have some idea that i can load xml data into OracleDB by oracle xml db....but not so clear..

2.Is there any other choices to make my program easy

hope u will help me

i know how to insert XML data into XML type tables and XML type columns(in oracleDB)....but i can just see it is as again xml data...not like text data...its all confusing....i am trying to do ..hope u will help me

Posttop
Ivan PedruzziSubject: Can Stylus Studio be used to map XML to load Oracle
Author: Ivan Pedruzzi
Date: 13 Feb 2007 10:20 AM
Hi Art,

Stylus Studio exposes SQL UPDATE capabilities in the current version through SQL/XML

Here is the video tutorial
http://www.stylusstudio.com/videos/dbtoxml2/dbtoxml2.html

In future versions our XQuery implementation will introduce update capabilities superseding SQL/XML


Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.