Re: Middleware --- polling or triggering

Steve

The AQ-MQ gateway is part of a Procedural gateway, so look for that. Not surprised you didn't find the Internet Broker, 'cause it's actually called the Oracle Integration Broker (don't you know "the Internet changes everything" as Larry would say?!).

HTH. Pete

steven_ma_at_my-deja.com wrote:

> Pete,
>
> I did a search on Oracle's website, couldn't find info on the Internet
> Broker or AQ-MQ gateway. Do you know where I can possibly find some
> info. Thanks.
>
> Steve
>
> In article <37D950F5.FDC33B85_at_us.oracle.com>,
> Pete Sharman <psharman_at_us.oracle.com> wrote:
> > This is a multi-part message in MIME format.
> > --------------D6880EDA99DC75F12B556AE0
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > From what I understand, all three are capable of doing the
> integration. You
> > would need to look at what each offers to see which best suits your
> > particular needs.
> >
> > Pete
> >
> > steven_ma_at_my-deja.com wrote:
> >
> > > Pete,
> > >
> > > Thanks for all the info.
> > >
> > > However I am still confused. From what I understand, you are
> talking
> > > about Oracle that has 3 products that will talk to MQSeries;
> Procedural
> > > Gateway for MQSeries, Oracle Internet Broker and AQ-MQ Gateway??
> > >
> > > Here is what I am trying to do:
> > >
> > > I am tryiny to integrate IBM's Net.Commerce to an Oracle ERP
> > > application. There's an existing IBM product that will integrate
> > > Net.Commerce with MQSeries. Now I am looking for a way to
> integrate MQ
> > > to an Oracle App and its db. Do you know anybody has such
> product? Or
> > > do you think the Oracle Internet Broker, Procedural Gateway for MQ
> or
> > > AQ-MQ Gateway will do the trick?
> > >
> > > Steve
> > >
> > > In article <37D6CBB3.58871420_at_us.oracle.com>,
> > > Pete Sharman <psharman_at_us.oracle.com> wrote:
> > > > This is a multi-part message in MIME format.
> > > > --------------687AB29D1738F4FBB6005D9F
> > > > Content-Type: text/plain; charset=us-ascii
> > > > Content-Transfer-Encoding: 7bit
> > > >
> > > > Steve
> > > >
> > > > I'm not sure what Michael is using this for, but the way you use
> the
> > > > term "real time transaction" makes it sound like you're wondering
> if
> > > > this is done synchronously. By their very nature, messaging
> products
> > > > like MQSeries and Oracle/AQ are asynchronous in nature. You can
> get
> > > > near real-time (a couple of seconds delay maybe) but not real
> real-
> > > time
> > > > (if that's not confusing).
> > > >
> > > > Oracle and MQSeries can talk through a number of approaches -
> Oracle
> > > > Internet Broker has just been released to do this, there is an AQ-
> MQ
> > > > gateway (which is probably what Michael is referring to), or
> there is
> > > a
> > > > product from Level8 that can do this as well. Alternatively, if
> there
> > > > is more complex data transformation that needs to occur, you
> could use
> > > > TSI's Mercator product or STC's Datagate (I think).
> > > >
> > > > HTH.
> > > >
> > > > Pete
> > > >
> > > > steven_ma_at_my-deja.com wrote:
> > > >
> > > > > Hi Michael,
> > > > >
> > > > > When you are using MQ Series and Procedural
> > > > > Gateway for MQSeries, this is a real time
> > > > > transaction, right??
> > > > >
> > > > > Is Procedural Gateway a client of MQSeries?
> > > > > How much is it?
> > > > >
> > > > > Thanks.
> > > > >
> > > > > Steve
> > > > >
> > > > > In article <7qhacj$48r$1_at_nnrp1.deja.com>,
> > > > > michael_bialik_at_my-deja.com wrote:
> > > > > > Hi.
> > > > > >
> > > > > > Look at www.quest.com.
> > > > > > They have a product that enable off-line copy
> > > > > of data
> > > > > > between 2 DBs.
> > > > > > I wonder what trigger you are going to use if
> > > > > no DBLINK is
> > > > > > possible between your databases?
> > > > > > I used IBM's MQSeries and Oracle MQ
> > > > > Procedural Gateway to
> > > > > > pass data from one DB to another and back.
> > > > > >
> > > > > > Good luck. Michael.
> > > > > >
> > > > > > In article
> > > > > <7qh35l$tol$1_at_imsp009a.netvigator.com>,
> > > > > > "Ken" <kenchowhk_at_yahoo.com> wrote:
> > > > > > > Hi there,
> > > > > > >
> > > > > > > I am studying which way is the best to
> > > > > refresh the DB.
> > > > > > > There are two DB and let say A and B, they
> > > > > are in
> > > > > > > different machine. When the update is done
> > > > > on A,
> > > > > > > then we need to refresh the corresponding
> > > > > table
> > > > > > > in B. Now let's assumed that the db_link
> > > > > can't be used.
> > > > > > > we are just thinking of two approaches
> > > > > > >
> > > > > > > 1. to set the timer in middleware to
> > > > > periodically do the
> > > > > > > synchronisation between the two DB.
> > > > > > > 2. to setup the trigger in DB A, any update
> > > > > in A will be
> > > > > > > firing a trigger to update B.
> > > > > > >
> > > > > > > Is there any whitepaper or document in
> > > > > comparing this
> > > > > > > two approach ? Should you have any other
> > > > > alternatives,
> > > > > > > kindly drop a few words also, many thanks.
> > > > > > >
> > > > > > > Ken
> > > > > > >
> > > > > > >
> > > > > >
> > > > > > Sent via Deja.com http://www.deja.com/
> > > > > > Share what you know. Learn what you don't.
> > > > > >
> > > > >
> > > > > Sent via Deja.com http://www.deja.com/
> > > > > Share what you know. Learn what you don't.
> > > >
> > > > --------------687AB29D1738F4FBB6005D9F
> > > > Content-Type: text/x-vcard; charset=us-ascii;
> > > > name="psharman.vcf"
> > > > Content-Transfer-Encoding: 7bit
> > > > Content-Description: Card for Pete Sharman
> > > > Content-Disposition: attachment;
> > > > filename="psharman.vcf"
> > > >
> > > > begin:vcard
> > > > n:Sharman;Peter
> > > > tel;cell:+1.650.868.9969
> > > > tel;fax:+1.650.633.1669
> > > > tel;work:+1.650.607.0109
> > > > x-mozilla-html:FALSE
> > > > url:http://eif.us.oracle.com
> > > > org:Advanced Technology Solutions;Oracle Corporation
> > > > adr:;;500 Oracle Parkway M/S OPL-A4019;Redwood
> > > Shores;California;94065;USA
> > > > version:2.1
> > > > email;internet:psharman_at_us.oracle.com
> > > > title:Managing Principal Consultant
> > > > note;quoted-printable:=0D=0A=0D=0A **** The statements and
> opinions
> > > expressed here are my **** =0D=0A **** own and do not necessarily
> > > represent those of **** =0D=0A **** Oracle
> > > Corporation. =20
> > > ****=0D=0A=0D=0A"Controlling application developers is like herding
> > > cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no
> it's
> > > not! It's much harder than that!" =0D=0ABruce Pihlamae, long term
> > > ORACLE DBA
> > > > x-mozilla-cpt:;24448
> > > > fn:Pete Sharman
> > > > end:vcard
> > > >
> > > > --------------687AB29D1738F4FBB6005D9F--
> > > >
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Share what you know. Learn what you don't.
> >
> > --------------D6880EDA99DC75F12B556AE0
> > Content-Type: text/x-vcard; charset=us-ascii;
> > name="psharman.vcf"
> > Content-Transfer-Encoding: 7bit
> > Content-Description: Card for Pete Sharman
> > Content-Disposition: attachment;
> > filename="psharman.vcf"
> >
> > begin:vcard
> > n:Sharman;Peter
> > tel;cell:+1.650.868.9969
> > tel;fax:+1.650.633.1669
> > tel;work:+1.650.607.0109
> > x-mozilla-html:FALSE
> > url:http://eif.us.oracle.com
> > org:Advanced Technology Solutions;Oracle Corporation
> > adr:;;500 Oracle Parkway M/S OPL-A4019;Redwood
> Shores;California;94065;USA
> > version:2.1
> > email;internet:psharman_at_us.oracle.com
> > title:Managing Principal Consultant
> > note;quoted-printable:=0D=0A=0D=0A **** The statements and opinions
> expressed here are my **** =0D=0A **** own and do not necessarily
> represent those of **** =0D=0A **** Oracle
> Corporation. =20
> ****=0D=0A=0D=0A"Controlling application developers is like herding
> cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no it's
> not! It's much harder than that!" =0D=0ABruce Pihlamae, long term
> ORACLE DBA
> > x-mozilla-cpt:;24448
> > fn:Pete Sharman
> > end:vcard
> >
> > --------------D6880EDA99DC75F12B556AE0--
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Tue Sep 14 1999 - 12:01:48 CDT