I am using QB Enterprise for Desktop, running on the server and users opening the data file from a shared network drive in multi-user mode. I need to write a series of reports outside of Quickbooks, using an advanced reporting tool like Crystal Reports, powerBI, etc... Right now I'm using Crystal. I downloaded QODBC and installed and the data connection works just fine. But to get it to work I had to approve my ODBC connection as an approved integrated application, and that approval times out in 2 weeks.
A little research seems to suggest that you can't extend the 2 week approval, and that's a safety feature. Which means I will have to go through that approval process every 2 weeks to keep my reports working.
What I'm wondering is... is there a better / more reliable / less maintenance connection to my data file for this kind of reporting? Or am I stuck having to go through the approval process every 14 days? I'm using a tool similar to Crystal Server that let's users self-service and get their own reports, but obviously this setup is going to break every 2 weeks until I approve it again. Just wondering how everyone else gets this done. Thanks!
