Cindy -

My suggestion as the easiest way to access SQL'ized Sage Data is to use the SQL Replicator for Sage.  It replicates all the data from the Pervasive Database on a regular schedule to a SQL instance.  Then you reference between SQL databases to get your end game.  Hope that helps.

John McLagan
Independent Senior Consultant
Johnny on the Spot

Yes, the data needs to be converted to a SQL database. SQL Replicator is free but I've heard it doesn't work consistently (syncing going offline a lot). If they have money in the budget, I'd recommend they use Anterra, https://anterratech.com/adc/. It's reliable and will give them more options for expanding their analytic capabilities in the future.