Solved

Audit a Pervasive database

Posted on 2014-09-23
3
314 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This article describes some very basic things about SQL Server filegroups.
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now