[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Query Reports

Posted on 2011-05-03
Medium Priority
Last Modified: 2012-08-13
I am looking for a software package to interact with large Databases. Basically to execute Queries and export them into mutiple formats (PDF,HML,XML, XLS, XLSX,TXT....) and generate some reports. Don't need anything too elaborate or  extended but it should interact well with large amounts of data.  
Question by:gonzalezwh
  • 2
  • 2
LVL 42

Expert Comment

ID: 35515669
Oracle, SQL/Server, MySQ--probably every dbms vendor--have studios/suites that claim to do that.  And there are many third part products, as well. I'd start with getting specific about what "large databases" you want to mine and target the (sometimes free) products from the same vendor.  

Expert Comment

ID: 35515704
Your options would be Sql Server Reporting Service and Crystal Reports by Bussiness Object

Author Comment

ID: 35517535
We  work with an Oracle database and it is large but not so much. I need this software as an aid with the various formats of information we load every day to the system. I can sacrifice time to belong to a lower price range.  In fact up until now Microsoft Access has been enough to do that part of the work. If you can recommend a program it does not have to be strong in report generation.
LVL 42

Accepted Solution

dqmq earned 375 total points
ID: 35691609
Hmmm...the Oracle toolset is pretty robust when it comes to running queries and producing different kinds of exports.  I'm not sure why you need anything else.  And what audience are you targeting for this new tool?  DBA's, IT developers, managers, end-users, web-users?

If you want something that gives you a GUI tool for extracting data into various formats, do a Google search for "ETL" tools.


Author Closing Comment

ID: 35713232
I belive there are other packages out there that are not so expensive and large. More on the middle side of the size range and price. For example Oracle PHP Generator Professional.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question