Audit a Pervasive database

I have the need to audit a Pervasive database. The version my ERP application is on is 10 which should work with Pervasive AuditMaster v6.4 but I just found out that this version has been discontinued according to this http://www.goldstarsoftware.com/am.asp

Can someone recommend a third party tool to audit a database? I need to see what get's posted to a given table upon save in the application.

I'm able to connect to the database with MS Access using ODBC.
LVL 1
GerhardpetAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mirtheilCommented:
As far as I know, there aren't any third party Audit tools.  You might contact the vendor of the ERP application to see if they can still sell you AuditMaster 6.4.
0
Bill BachPresident and Btrieve GuruCommented:
Pervasive PSQL v10 was discontinued and has been unsupported since March 31, 2011.  In a very short-sighted move, Pervasive Software (now Actian Corporation) also discontinued all add-on products and license count increases for the older version at the same time -- essentially making it impossible to maintain an existing system on this older release.  Anyway, I digress.

I have two recommendations:

A) If you are able to move to the current release, Actian PSQL v11, then AuditMaster v7 is available and will do what you need.  While your current ERP solution may require v10 to be "supported by the company", it is certainly possible (and likely) that the same product WILL WORK on PSQLv11.  My recommendation would be to install a second server (even a virtual server) with the existing ERP environment, then upgrade it to PSQLv11, and install AM as well.  (You can do all of this with 30-day trial versions.)  Once you have done this, you can use AM to acquire the info that you need in this test environment.

B) The only other option is kind of horrific -- enable MKDE Tracing on the database.  (You find this in the PCC "Configure Local Engine" dialog under Debugging tab.)  However, you need to have a solid understanding of the Btrieve programming API to use this to determine "what changes are made by a given process".  If you are interested in ONE table only, then this will give you exactly what you need -- but you'll need to interpret the bytes from the data buffer on your own.  (If you try this, be sure to increase the size of the captured data buffer block from 128 (default) to the size of the record you want to capture.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GerhardpetAuthor Commented:
To my surprise the ERP application works with version 11. So I’m set.

Thank you @BillBach
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.