Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Active Server Pages (ASP)
Expertise: Beginner
May 30, 2000

ASP Integration to Legacy Database Using XML

Question:
I am trying to develop an MSSQL ASP application that ties real-time into customer's existing databases at remote locations. The customers use everything from IBM mainframes to SQL or Oracle, and the data needs to flow both ways. Is XML the best fit for this application? Are there any software packages available that could prevent me from having to custom write each script?

Answer:

This depends very much on whether the Oracle and IBM systems themselves expose XML. If they do, then I would strongly recommend that you investigate the possibility. Oracle 8i contains extensive XML support. Also, the newer IBM DB2 implementations are moving toward XML representations.

The key would essentially be to write XSL scripts that handle the conversion between different database representations. However, these would be far easier than trying to write ASP scripts and remote procedure calls.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date