Expose DB2 data as XML / Query DB2via XML

Posted by Anthony Gatlin on Stack Overflow See other posts from Stack Overflow or by Anthony Gatlin
Published on 2010-06-05T18:35:51Z Indexed on 2010/06/05 18:42 UTC
Read the original article Hit count: 999

Filed under:
|
|
|
|

I have a client who has a sort of data warehouse stored in DB2. For a variety of reasons, the data must remain on this platform.

The client is considering implementing an open-source CMS (Drupal) which runs in MySQL. The client needs to be able to execute a bunch of pre-defined queries against the DB2 database from the remote application.

Drupal appears to interact well with XML data from other systems. It was suggested that we use something like XML-RPC to execute the queries against DB2.

I am very familiar with SQL Server and pretty familiar with MySQL, but I have no experience with DB2 and no understanding of its capabilities or limitations.

Is there any way that we can use something like XML, XML-RPC, or even http to initiate queries against a DB2 database?

Any ideas are appreciated!

Thank you!

© Stack Overflow or respective owner

Related posts about Xml

Related posts about drupal