Charting from Oracle database

Hello,

Currently I have several excel templates which query Oracle and are used to update charts.  For the smaller files, it works well, but the larger excel files ~100MB's it is quite slow.  Does Oracle have something I could use to chart which would help with performance instead Excel?
jverasqlAsked:
Who is Participating?
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.

slightwv (䄆 Netminder) Commented:
Oracle's 'charting' is built in to Oracle Business Intelligence Enterprise Edition (OBIEE)
http://www.oracle.com/us/solutions/business-analytics/business-intelligence/enterprise-edition/overview/index.html

The bad part is, just like most Oracle products, it isn't cheap.

Can you do most/all of the processing at the database layer and only do presentation in Excel?

Instead of bringing back 100M of data, can you do whatever summarization necessary at the database?

If you can provide more information about what the charts do and the raw data, we might be able to provide some SQL or maybe a function/procedure to help.
0

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
PortletPaulfreelancerCommented:
The Oracle database does not, but the Oracle corporation has many products including business intelligence.

But a way to help you would be to see if the size of those files can be reduced.
Maybe the queries (that produce the files) could do more of the needed number crunching?
0
sdstuberCommented:
You could also try APEX.  It comes with a wide variety of charting options.
0
Wasim Akram ShaikCommented:
For free versions of preparing charts, you can try your queries with google chart apis

sample reference of how to incorporate your queries with google charts can be found here

http://www.pythian.com/blog/google-charts-for-dba-tablespaces-allocation/
0
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
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.