Hello,

For my client I need to extract modified and new records
from Baan tables. (Both transactional and master data tables)

Audit is not an option as the tables (PO) are heavily used.

Is there any other method to extract incremental data without affecting the performance.

Environment : Baan 5b

Thanks for your time

First of all I will say that I am not a Baan developer :)

I focus on sys admin and DBA types of activities with our clients but here is what I have seen to address this problem:

1. Use database triggers (some performance overhead, added complexity for upgrades and DBA activity).

2. Use audit (performance issues for Baan -- easy to administer).

3. Modify the Baan session to maintain a log of updated records (easy to do for one session, a pain if the table hasmany update points).

4. Use a point in time comparison table where updated records are replayed into the second instance (common for data warehouse environments that must push period based data into the system).

5. Use a third party replication product (cost issues, easier to manage than triggers, lower performance hit than audit).

6. Live with the problem

Just a few quick thoughts...

--Jim

I'd probably vote for database triggers but honestly I wouldn't like to do it myself. Good luck in the task ahead!

hi,

be it PUR or SLS or INV or RPL transactions, BaaN maintains a history line.

Eg:
P.O order Header / Line tables are tdpur040/041

BaaN maintains tdpur050/051 as a history/image of pur040/041

it has records marked with record type 1 / 2/ 3 to indicate new orders / deleted orders / invoiced orders

This might help as this history is robust bcos only history information is extracted for BaaN BIS even.

Vish

With baanERP you have Data Access Layers (DAL) for most of tables. It is the most reliable way (after DB trigers) to track tables transactions.

The problem is that you need sources to do that.

I did use a product named Qkey on baan IV that allow to add scripts for events. With that tool you can add log, audit, field content checking, ... without baan sources.

I don't know if this product still exist for Baan V.

One can use the DAL hooks to create history tables. The main drawback is if db.update/db.insert is used instead of dal.update/dal.new this will fail.

As for QKEY, baanboard is hosting an opensource development of a similar product. See this thread http://www.baanboard.com/baanboard/showthread.php?s=&threadid=355

Thanks. I choose to use the PO history to see if there is a modification.

Vamsi do u have the qkey like tool?

Originally posted by Commandeur
I did use a product named Qkey on baan IV that allow to add scripts for events. With that tool you can add log, audit, field content checking, ... without baan sources.

I don't know if this product still exist for Baan V.

Yes! QKEY supports both Baan IV and Baan V; it has for some time now. The 3.x version includes support for DLLs as well as 4GL sessions and expanded set of directives to make it easier to call arbitrary parent events/functions. The DLL support is more useful in Baan V where you have DALs -- thus you can add additional validations or methods (or add code before/after a method defined in the parent) in a DAL.

--Kevin Brock, author of QKEY