Connecting to a Jade Database from another Jade Database

[ConvertFromOldNGs]

by Michael Hill >> Thu, 26 Aug 2004 3:59:53 GMT

Afternoon all,

Have a little problem and was wondering if anyone has done this or has some suggestions.

The scenario is this:

We have a 3rd Party Jade database which we are unable to put code into, what we want to do is write a separate Jade application to extract data out of this database and put it in another one database (MySQL in this instance).

We have looked at ODBC but have been advised by Jade Support that we can't do Jade to Jade communication. Also looked at Access and linked tables but this is not goign to do what we require.

The only other option that I know of is using the JOM API to do it. I've looked through the posts; faq's; and documentation and have an idea of what I need to do, but I have not been able to find any examples.

My questions are, is what I'm looking at doing feasible from within Jade? And does anyone have any examples of how to accomplish this, either in Jade; VB; C or C++.

Cheers

Michael Hill
Ashburton Computer Associates

[ConvertFromOldNGs]

by Darrell Duniam >> Thu, 26 Aug 2004 4:15:34 GMT

Sounds like a good argument for Jade Web Services, but you'd need to be on JADE 6. Basically, you can expose an interface in a "Provider" system, then extract a WSDL file which you load into the "Consumer" system. JADE uses SOAP messages for both the Provider and the Consumer. Go to the following URL for more details:

http://www.jadeworld.com/downloads/webservices.pdf

regards,
darrell.

[ConvertFromOldNGs]

by allistar >> Sat, 28 Aug 2004 3:04:12 GMT

Hi Michael,
I have had experience developing external applications (in
either .exe, .dll or COM component form) using C++ and the JOMAPI. There is a steep learning curve but you are able to do everything using the JOMAPI that you can do natively in the JADE IDE itself.

We discovered a while ago that only one JADE kernel can "live" inside the process space of an exe at any one time. This is why you can't use ODBC in a JADE to JADE connection (as the jadodbc.dll and hence the database it conencts to lives inside the stack spae of the calling application). COM is a good way to get around this as the COM component cn be compiled to live as a "out-of-process" exe, which then allows you to connect one JADE database to another JADE database without any issues.

Looking at your situation (which I don't know the ins and outs of) I would suggest that you could suck the data from the 3rd party JADE database using the ODBC driver and another development language - not JADE. Interfacing to ODBC from a third party app is much much easier that coding extract routines using the JOMAPI. I would recommend using a scripting language that has easy access to both MySQL and JADE (via ODBC) such as PHP.

You haven't mentioned whether this will be a once off extract or an ongoing thing. That could determine the solution you choose. If it's a one off thing I wouldn't be too concerned over the performance of the extract process.

Regards,
Allistar.
--
------------------------------------------------------------------
Allistar Melville
Software Developer, Analyst allistar@silvermoon.co.nz
Auckland, NEW ZEALAND

Silvermoon Software
Specialising in JADE development and consulting
Visit us at: http://www.silvermoon.co.nz
*NEW* Simple web access to Jade at: www.silvermoon.co.nz/jhp.html ------------------------------------------------------------------

[ConvertFromOldNGs]

by Michael Hill >> Sun, 29 Aug 2004 8:20:44 GMT

Hi Allistar,

To answer your question as to whether it's a one off or continuing. It will be an ongoing thing each day extracting that days transactions.

What is the learning curve like on PHP?

Regards
Michael