Integration problem coding nonJava services for IS

, ,
1

Hi,
I’m from a Java background, and need some advice about coding and executing non-Java services in IS.

I’m currently trying to work out the greatest number of popular file formats that webMethods can produce for a disparate group of back end systems. The goal of my current webMethods application is to produce proprietary formats, which require Java coding, popular flavours of XML (IDOC, etc.) and CSV.

I’m curious as to whether or not it’s possible to produce a .xls (Microsoft Excel) and/or a .mdb (Microsoft Access) file, from a UDM/Canonical running in the my webMethods app… Visual Basic can handle the conversion, I’m told, from a CSV to .xls or .mdb.

Will a Visual Basic service in webMethods execute on Integration Server, running in a Unix environment?

It would be preferable if C++ could be used to produce such formats, but in any case, it dies involve embedding a Microsoft binary of some sort, into a webMethods service. Can this sort of webMethods service execute in a UNIX environment?

Thanks,
Nick Faiz.

2

Hey Nick - Hi Nick – There was a discussion on the openitx lists – Joe Fair suggested using POI [url=“Apache POI - the Java API for Microsoft Documents”]http://jakarta.apache.org/poi/[/url]

From the POI website:

Purpose
The POI project consists of APIs for manipulating various file formats based upon Microsoft’s OLE 2 Compound Document format using pure Java.
OLE 2 Compound Document Format based files include most Microsoft Office files such as XLS and DOC.

Sonam Chauhan

3

Thanks Sonam. I’m reading up on POI now.

Looking forward to the wMUG (if that is the proper acronym).

Nick