I remember 24U software sharing their plugin template a little while back. You can find it here:
There may be others as well, and I know there are a few plugins that might serve you needs already, instead of writing your own. There are also some that offer functions from other languages, like java, that might be able to be customized to do what you need.
I'd suggest you look into scriptmaster, as Java code should have ADO access:
At least that would save you from having to write and compile your own plugin.
I'm not terribly familiar with ADO/ADODB, but shouldn't it have an ODBC driver that would allow you to connect from FM that way?
Pretty much anything you can do with VB.NET or C# can be done through PowerShell. And powershell is just text, not compiled so you can generate it inside FM and then export & execute it through the Send Event script step. Or not export it and just create a long string to pass directly through Send Event.
Thanks, Let me investiagate some of these options. Unfortunately the ODBC driver for this product only allows reading of data and one cant write back.
To be honest the table structure is such a monster that the API classes are easier.
Thanks to you all..
I have decided that my best bet is to write a web service that will sit on the same box as the program I need to talk to.
I can do this fairly easily.
This webservice would accept some parameters and return a result (probably success or fail).
I believe I can call this url(web service) via the insert from URL script step but can I pass several variables to this.
a typical webservice would be "AddCustomer" so id need to pass quite a lenghty set of information.
I have decided that my best bet is to write a web service
I've done that before too, it's pretty elegant.
Keep in mind that your server restore procedures need to be updated for this new piece of middleware. Very easy to overlook.