GoldenGate?
Has anyone heard of a Data Warehousing product called GoldenGate for Real-Time data Warehousing? I have a potential IDS customer who uses it for an Oracle-based data warehouse: one of their criteria is whether the chosen database integrates with this product. On the face of it, reading GoldenGate's blurb, IDS doesn't: "Heterogeneity - GoldenGate supports a wide range of database versions for Oracle, SQL Server, IBM DB2 OS/390 and UDB, Sybase, Enscribe, SQL/MP and SQL/MX, and Teradata running on UNIX, Windows, and HP Nonstop platforms, and can deliver data to any warehouse running on an ODBC compliant database". ... but if anyone knows differently, please let me know. Thanks -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com
Hi, Neil, They claim, that they do 'Log-based capture of new data transactions committed at the source database'. That is, this is not trigger-based replication (what most third-party replication vendors do), this is log-based replication - similar to Informix CDR/HDR/RSS/SDS. Obviously, the database vendor should provide a way to decode their transactions logs (which is platform-specific, version-specific). I don't believe, that they know how to read Informix Logical Logs. -Alexey -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Neil Truby Has anyone heard of a Data Warehousing product called GoldenGate for Real-Time data Warehousing? I have a potential IDS customer who uses it for an Oracle-based data warehouse: one of their criteria is whether the chosen database integrates with this product. On the face of it, reading GoldenGate's blurb, IDS doesn't: "Heterogeneity - GoldenGate supports a wide range of database versions for Oracle, SQL Server, IBM DB2 OS/390 and UDB, Sybase, Enscribe, SQL/MP and SQL/MX, and Teradata running on UNIX, Windows, and HP Nonstop platforms, and can deliver data to any warehouse running on an ODBC compliant database". ... but if anyone knows differently, please let me know. Thanks -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
"Alexey Sonkin" <alexeys@cidc.com> wrote in message news:mailman.357.1201563692.20610.informix-list@iiug.org... Hi, Neil, They claim, that they do 'Log-based capture of new data transactions committed at the source database'. That is, this is not trigger-based replication (what most third-party replication vendors do), this is log-based replication - similar to Informix CDR/HDR/RSS/SDS. Obviously, the database vendor should provide a way to decode their transactions logs (which is platform-specific, version-specific). I don't believe, that they know how to read Informix Logical Logs. -Alexey OK, thanks. I guess that's a tick in the "No" column for IDS then :-( cheers Neil
I talked to them a while back, I don't seem to recall that not supporting IDS was an issue. Might want to check their website. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Neil Truby Sent: Monday, January 28, 2008 6:53 PM To: informix-list@iiug.org Subject: Re: GoldenGate? "Alexey Sonkin" <alexeys@cidc.com> wrote in message news:mailman.357.1201563692.20610.informix-list@iiug.org... Hi, Neil, They claim, that they do 'Log-based capture of new data transactions committed at the source database'. That is, this is not trigger-based replication (what most third-party replication vendors do), this is log-based replication - similar to Informix CDR/HDR/RSS/SDS. Obviously, the database vendor should provide a way to decode their transactions logs (which is platform-specific, version-specific). I don't believe, that they know how to read Informix Logical Logs. -Alexey OK, thanks. I guess that's a tick in the "No" column for IDS then :-( cheers Neil _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
On Jan 28, 7:31 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > I talked to them a while back, I don't seem to recall that not supporting > IDS was an issue. Might want to check their website. > > j. > > -----Original Message----- > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org]On Behalf Of Neil Truby > Sent: Monday, January 28, 2008 6:53 PM > To: informix-l...@iiug.org > Subject: Re: GoldenGate? > > "Alexey Sonkin" <alex...@cidc.com> wrote in messagenews:mailman.357.1201563692.20610.informix-list@iiug.org... > Hi, Neil, > > They claim, that they do 'Log-based capture of new data transactions > committed at the source database'. That is, this is not trigger-based > replication (what most third-party replication vendors do), this is > log-based replication - similar to Informix CDR/HDR/RSS/SDS. > Obviously, the database vendor should provide a way to decode their > transactions logs (which is platform-specific, version-specific). > I don't believe, that they know how to read Informix Logical Logs. > > -Alexey > > OK, thanks. I guess that's a tick in the "No" column for IDS then :-( > > cheers > Neil > > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list We have a group that is using the GG product for Oracle to Oracle when we were purchased they wanted to use GG to go from Informix to Oracle but alas GG told them that they don't support Informix. IBM was trying to work with them using a web sphere product.