Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

how to capture the changed data (CDC) in ASE

3 posts in General Discussion Last posting was on 2012-05-04 20:28:44.0Z
Kevin Liang Posted on 2012-05-04 13:57:43.0Z
Sender: 4c1a.4fa3dfc9.1804289383@sybase.com
From: Kevin Liang
Newsgroups: sybase.public.ase.general
Subject: how to capture the changed data (CDC) in ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fa3e057.4c35.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 May 2012 06:57:43 -0700
X-Trace: forums-1-dub 1336139863 172.20.134.41 (4 May 2012 06:57:43 -0700)
X-Original-Trace: 4 May 2012 06:57:43 -0700, 172.20.134.41
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31081
Article PK: 73972

In our projects, we need to capture the changed data in
database side. We want to know exactly which table was
changed (insert, update or delete) when the front
application complete a business operation such as clicking
"OK" or "Save" button to save a customer information . The
front end may be either call a store procedure or run a sql
statement directly, that doesn't matter for us. We only need
to know business operation and the changed data.
The reason we do this is to prepare the data directly
without front end involved, in this way we can quickly
create and reload the testing data.
The sybase audit and monitor server cannot give us this
information, we need the changed table instead of when and
who called the store procedure or sql statement.
It seems like the CDC can only be used when the Replication
server or Integration server was installed, I want to know
which component I need to install to support CDC and
therefor which product we need to buy at minimum ?? If I
want a trial version to confirm the feature, how can I get
it?

FYI. Our current sybase ASE version is 15.5 on Linux and
15.0.2 on Window x86


Thanks

Kevin Liang


Bret Halford Posted on 2012-05-04 14:35:08.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: how to capture the changed data (CDC) in ASE
References: <4fa3e057.4c35.1681692777@sybase.com>
In-Reply-To: <4fa3e057.4c35.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fa3e91c$1@forums-1-dub>
Date: 4 May 2012 07:35:08 -0700
X-Trace: forums-1-dub 1336142108 10.22.241.152 (4 May 2012 07:35:08 -0700)
X-Original-Trace: 4 May 2012 07:35:08 -0700, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31082
Article PK: 73971


On 5/4/2012 7:57 AM, Kevin Liang wrote:
> In our projects, we need to capture the changed data in
> database side. We want to know exactly which table was
> changed (insert, update or delete) when the front
> application complete a business operation such as clicking
> "OK" or "Save" button to save a customer information . The
> front end may be either call a store procedure or run a sql
> statement directly, that doesn't matter for us. We only need
> to know business operation and the changed data.
> The reason we do this is to prepare the data directly
> without front end involved, in this way we can quickly
> create and reload the testing data.
> The sybase audit and monitor server cannot give us this
> information, we need the changed table instead of when and
> who called the store procedure or sql statement.
> It seems like the CDC can only be used when the Replication
> server or Integration server was installed, I want to know
> which component I need to install to support CDC and
> therefor which product we need to buy at minimum ?? If I
> want a trial version to confirm the feature, how can I get
> it?
>
> FYI. Our current sybase ASE version is 15.5 on Linux and
> 15.0.2 on Window x86
>
>
> Thanks
>
> Kevin Liang

Have you considered insert/update/delete triggers on the tables?

-bret


Kevin Liang Posted on 2012-05-04 20:28:44.0Z
Sender: 4c1a.4fa3dfc9.1804289383@sybase.com
From: Kevin Liang
Newsgroups: sybase.public.ase.general
Subject: Re: how to capture the changed data (CDC) in ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fa43bfc.5bad.1681692777@sybase.com>
References: <4fa3e91c$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 May 2012 13:28:44 -0700
X-Trace: forums-1-dub 1336163324 172.20.134.41 (4 May 2012 13:28:44 -0700)
X-Original-Trace: 4 May 2012 13:28:44 -0700, 172.20.134.41
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31083
Article PK: 73973


> On 5/4/2012 7:57 AM, Kevin Liang wrote:
> > In our projects, we need to capture the changed data in
> > database side. We want to know exactly which table was
> > changed (insert, update or delete) when the front
> > application complete a business operation such as
> > clicking "OK" or "Save" button to save a customer
> > information . The front end may be either call a store
> > procedure or run a sql statement directly, that doesn't
> > matter for us. We only need to know business operation
> > and the changed data. The reason we do this is to
> > prepare the data directly without front end involved, in
> > this way we can quickly create and reload the testing
> > data. The sybase audit and monitor server cannot give us
> > this information, we need the changed table instead of
> > when and who called the store procedure or sql
> > statement. It seems like the CDC can only be used when
> > the Replication server or Integration server was
> > installed, I want to know which component I need to
> > install to support CDC and therefor which product we
> > need to buy at minimum ?? If I want a trial version to
> > confirm the feature, how can I get it?
> >
> > FYI. Our current sybase ASE version is 15.5 on Linux and
> > 15.0.2 on Window x86
> >
> >
> > Thanks
> >
> > Kevin Liang
>
>
> Have you considered insert/update/delete triggers on the
> tables?
>
> -bret

Yes, trigger is another good solution, but we want to put it
in the end. Because we do not want to change or create new
code into the database, most of the case, the database have
a lot of triggers. The best choice for us is to get changed
data in system level.

--Kevin Liang