Expose DB2 data as XML / Query DB2via XML
- by Anthony Gatlin
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!