Rolling your own transactional report to replace operatorClient.jar

First, I remember putting the DB Schema in the TechRef, but that may be out of date so you are probably right to view the schema actually in your database.

(Warning this is all from memory)

My recollection is that the transaction table is what you want to look at. 

The transactionId will get you a link back to the person who purchased this (assuming you maintained that when you generated the .acsm file/URLLink url)

The adobeId guid will also give a good but not foolproof singe person identifier

The resource id will tell you which piece of content (foreign key to ?resourceItem? table)

and there should be a timestamp for original purchase.

The table should get you equivalent numbers to the transaction reports.

Fulfillment is the transaction table I was thinking of.  I don't know the columns name, but if my memory isn't completely shot, the transaction id, operator id, and timestamp should be in the table.  I don't remember  however if there is a fulfillment row created for every download, or just the first.  If it is every time, then you will need to start/join with the license table which should have one entry per purchase, instead of download.

(if you want to take this out of the forums, pm me, and I'll give you my email address)

Also,  given what you said, I'm assuming you have already done talked to them to try to get the transaction reports, you may also want to consider reaching out to Bluefire again - with the question the way you phrased it here:

'Since I can't get to the transaction report, what's the best way to get the information I need from my ACS4 database.'

Sometimes asking the question differently will get better results, and I've long been a fan at the people at Bluefire, so I'd be surprised if they didn't try to help you.

Good Luck.

Glad to hear that you got a working solution.