OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] XML into SQL and out again

[ Lists Home | Date Index | Thread Index ]

--- Neile Bermudes <Neile.Bermudes@ecb.co.uk> wrote:
> Hello all
> I have been asked to undertake a project at work: we
> have a Directory
> booklet with all the contact details for staff in
> our organization, which we
> create in Quark. I would now like to create a SQL
> database with the same
> information, and which can be searchable using ASP
> scripts from our company
> Intranet. Obviously it would be absolutely crazy to
> update both Quark and
> SQL separately every time contact details change. 
> What I would like to do: first, export all the
> information in Quark into a
> SQL database, having exactly the same information in
> both. Then, as details
> change, just update the database. Once a year, when
> we print out the Staff
> Directory booklet, I would like to then like to get
> the updated information
> into Quark so it can be printed. 
> The way to export info from Quark into a useable
> format is by using their
> product, Avenue, which exports to XML. From XML, I
> can get the info into
> SQL. Then, when I need to update Quark, I export
> from SQL into XML and then
> back into Quark. 
> My main question is can I get the XML data into SQL
> columns and fields, like
> regular SQL data? And once it's in their, can I
> query it/mess with it like
> normal data for other purposes, like accessing it on
> my Intranet via ASP?
> How is this XML data treated once in SQL??
> Any info would be appreciated, even is just a
> pointer to some good
> resources/site/books etc


ConnectTel has a product that allows access to several
using a XML interface, see site for details. It does
exactly what you described above. There is one
example using ASP.NET and MYSQL.

For more information, please visit the XQX web page

It allows SOAP/HTTP access to remote databases, as
well as
local interface using function calls.


Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS