Solved

Audit a Pervasive database

Posted on 2014-09-23
3
317 Views
Last Modified: 2014-09-23
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.
0
Comment
Question by:Gerhardpet
3 Comments
 
LVL 18

Expert Comment

by:mirtheil
ID: 40339373
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
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 40339436
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
 
LVL 1

Author Closing Comment

by:Gerhardpet
ID: 40339856
To my surprise the ERP application works with version 11. So I’m set.

Thank you @BillBach
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question