Enterprise Gateway Manager

Posted in 2007

Keith Simmons — Wed, 28 Nov 2007 08:58:39 — source: IIUG Forums & Mailing Lists

Apologies for double posting but this seemed to get lost going to c.d.i. ! Anyone out there using this product in anger on live servers? I'm trying (with assistance) to get this setup to communicate between IDS 10 on Solaris and/or AIX and $QL $erver 2OO5 on W2K. Any tips/gotchas. Keith

↪ replying to Keith Simmons

Manoj Vakeel — Wed, 28 Nov 2007 14:43:23 — source: IIUG Forums & Mailing Lists

Yes, My clients are using EGM to query against SQL Server 2005 and Oracle in a production environment but not in anger. We have been using it for a few years now and have had no issues, it keeps working just like the engine. It's on AIX 5.3 with IDS10. We also have a few other production setup's on Solaris 10 but going only against oracle. We may not have stretched the limits of the product in any manner. Basically about 200 to 300 simple selects per hour on simple data types. I would use the newer builds as they have supported versions of the ODBC driver for SQL server and Oracle. Thanks Manoj Vakeel IBM Premier Support mvakeel@us.ibm.com 314 331 3936 "Keith Simmons" <smiley73@googlemail.com> Sent by: ids-bounces@iiug.org 11/28/2007 02:58 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject Enterprise Gateway Manager [10500] Apologies for double posting but this seemed to get lost going to c.d.i. ! Anyone out there using this product in anger on live servers? I'm trying (with assistance) to get this setup to communicate between IDS 10 on Solaris and/or AIX and $QL $erver 2OO5 on W2K. Any tips/gotchas. Keith ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Manoj Vakeel

R Fo — Wed, 28 Nov 2007 15:36:48 — source: IIUG Forums & Mailing Lists

Hi VakeelPlease, could you tell me what versions of IDS can connect to SQLServer using EGM ? Do you know any tool or product that - connected in SQLServer (2000 or 2005) can access IDS db to select data in its tables ? Thanks in advice. R Ferronato > To: ids@iiug.org> From: mvakeel@us.ibm.com> Subject: Re: Enterprise Gateway Manager [10505]> Date: Wed, 28 Nov 2007 09:43:23 -0500> > Yes, My clients are using EGM to query against SQL Server 2005 and Oracle > in a production environment but not in anger. > We have been using it for a few years now and have had no issues, it keeps > working just like the engine. It's on AIX 5.3 with IDS10. We also have a > few other production setup's on Solaris 10 but going only against oracle. > We may not have stretched the limits of the product in any manner. > Basically about 200 to 300 simple selects per hour on simple data types. > I would use the newer builds as they have supported versions of the ODBC > driver for SQL server and Oracle. > > Thanks > > Manoj Vakeel > IBM Premier Support > mvakeel@us.ibm.com > 314 331 3936 > > "Keith Simmons" <smiley73@googlemail.com> > Sent by: ids-bounces@iiug.org > 11/28/2007 02:58 AM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > Enterprise Gateway Manager [10500] > > Apologies for double posting but this seemed to get lost going to c.d.i. ! > > Anyone out there using this product in anger on live servers? I'm > trying (with assistance) to get this setup to communicate between IDS > 10 on Solaris and/or AIX and $QL $erver 2OO5 on W2K. > Any tips/gotchas. > > Keith > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt= en-us

↪ replying to R Fo

Manoj Vakeel — Wed, 28 Nov 2007 17:32:28 — source: IIUG Forums & Mailing Lists

It does not have much to do with the version of the engine itself, product can be installed in a different location form the engine, and the engine connects to the gateway through server definitions in sqlhosts. It worked fine on 7.31's, 9.4's and 10's. I have not messed with IDS 11 yet. I don't know much about sqlserver and going the other way, You could probably look into their SQL Server Management Studio ??? Thanks -Manoj "R Fo" <roeferr@hotmail.com> Sent by: ids-bounces@iiug.org 11/28/2007 09:36 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: Enterprise Gateway Manager [10506] Hi VakeelPlease, could you tell me what versions of IDS can connect to SQLServer using EGM ? Do you know any tool or product that - connected in SQLServer (2000 or 2005) can access IDS db to select data in its tables ? Thanks in advice. R Ferronato > To: ids@iiug.org> From: mvakeel@us.ibm.com> Subject: Re: Enterprise Gateway Manager [10505]> Date: Wed, 28 Nov 2007 09:43:23 -0500> > Yes, My clients are using EGM to query against SQL Server 2005 and Oracle > in a production environment but not in anger. > We have been using it for a few years now and have had no issues, it keeps > working just like the engine. It's on AIX 5.3 with IDS10. We also have a > few other production setup's on Solaris 10 but going only against oracle. > We may not have stretched the limits of the product in any manner. > Basically about 200 to 300 simple selects per hour on simple data types. > I would use the newer builds as they have supported versions of the ODBC > driver for SQL server and Oracle. > > Thanks > > Manoj Vakeel > IBM Premier Support > mvakeel@us.ibm.com > 314 331 3936 > > "Keith Simmons" <smiley73@googlemail.com> > Sent by: ids-bounces@iiug.org > 11/28/2007 02:58 AM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > Enterprise Gateway Manager [10500] > > Apologies for double posting but this seemed to get lost going to c.d.i. ! > > Anyone out there using this product in anger on live servers? I'm > trying (with assistance) to get this setup to communicate between IDS > 10 on Solaris and/or AIX and $QL $erver 2OO5 on W2K. > Any tips/gotchas. > > Keith > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt= en-us ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.