Hi Community,
is it possible to directly connect DB2 Tables with the MashZone? At the moment I am creating Data Feeds manualy for each flat file which I copied for testing from the server. It would be great to directly connect our Data Warehouse with MashZone.
Best regards,
waltzba
Stephan Freudl on
Hi,
DB2 -- or in more general JDBC -- connectivity has been requested before. We are currently evaluating such a data source.
In mean time I suggest to create a simple web service which converts a SQL statement's result into a XML file. An argument specified by URL could contain info about the table name to query. This way the service was somewhat generic.
Please note, since MashZone 1.0.1 introduces Dynamic data source parameters you could even specify values to consider in your where-clause at runtime.
Regards
Stephan