Sage 100 Business Intelligence

I am interested to know if anyone is using Sage 100 or MAS 200 and is doing anything with business intelligence for reporting. The only reporting mechanisms I have are crystal reports and Sage Intelligence. Each has their drawbacks, notably the complexity and immense time it takes to create those reports.

What I am looking to see if anyone has done is to web enable the reports? I am looking to see if we can pull reports via a web page and have the results appear in the browser. Or even simply have an iframe contain the results of a specific report. This would eliminate the need to manually run and wait for reports, as many may take several minutes to run, but then must be re-ran all the time for updates.

Unfortunately Sage 100 is not on a SQL database, but rather providex. It does have ODBC drivers to link to its tables.
tkwadminAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vastoCommented:
I am not very clear how a WEB app will resolve the waiting.  
I was working for R-Tag in the past and I remember we had plenty of customers who used the software to run and schedule reports from Sage. R-Tag however is a desktop application.
There are also web based applications which are able to run  Crystal reports, but they are pretty pricey. Here is a list:
http://kenhamady.com/cru/comparisons/server-based-deployment-options

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
I don't know about providing the data through frames but you can build reports and present them through applications including web applications.

The main reason the web apps are pricey is the licensing required.  Crystal is pretty lenient for in-house use but as soon as you make it external the licensing gets to be expensive.

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.