We currently use an accounting software (Sage 50) hosted on a local machine. It has many shortcomings and I want to build custom datasets/tables and display information to my organization. I am able to access the Pervasive Database our software runs off of in Razor SQL.
My question is a black box questions, how can I spit out this dataset to a internal site like Sharepoint (or even a shared Excel file) so everyone is my organization can view these reports? Pervasive ODBC connection is 32 bit only, so Excel cannot open the data source. Is there a way to setup a query to "copy/paste" the pervasive database into a 64 bit DB like MYSQL or MSSQL?
I did try to build out PowerBI Desktop reports which "worked" but refreshing the data set takes a very long time (like 3 mins). I tried to publish the data set to sharepoint but it cannot get auto refresh to work and everyone apparently needs Power Bi premium to view these reports. It has become a headache.