What is Presto? Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Presto was designed and written from the ground up for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of organizations like Facebook. What can it do?

• Ad Hoc Reporting Tools
• Reporting Tool For Sql Server

Presto allows querying data where it lives, including Hive, Cassandra, relational databases or even proprietary data stores. A single Presto query can combine data from multiple sources, allowing for analytics across your entire organization. Presto is targeted at analysts who expect response times ranging from sub-second to minutes. Presto breaks the false choice between having fast analytics using an expensive commercial solution or using a slow 'free' solution that requires excessive hardware. Facebook uses Presto for interactive queries against several internal data stores, including their 300PB data warehouse. Over 1,000 Facebook employees use Presto daily to run more than 30,000 queries that in total scan over a petabyte each per day.

Leading internet companies including Airbnb and Dropbox are using Presto. Presto is amazing.

Lead engineer Andy Kramolisch got it into production in just a few days. It's an order of magnitude faster than Hive in most our use cases. It reads directly from HDFS, so unlike Redshift, there isn't a lot of ETL before you can use it.

It just works. Christopher Gutierrez, Manager of Online Analytics, Airbnb We're really excited about Presto. We're planning on using it to quickly gain insight about the different ways our users use Dropbox, as well as diagnosing problems they encounter along the way.

In our tests so far it's been rock solid and extremely fast when applied to some of our most important ad hoc use cases. Fred Wulff, Software Engineer, Dropbox.

'Please advice on 1) what you think is the best tool out there in the market producing the best adhoc capability for reporting. 2) How well does it integrate with a data warehouse or data marts?

3) Integration with essbase or Cognos cubes? 5) Performance? 6) User acceptance success?

7) Deployment strength? To how many users? 8) Ease of use? 9) Comparison to Cognos or Hyperion Performance Suite?

Any feedback would be greatly appreciated. Regards Sam Mohanty, Director clickISC 724 Highwoods Dr, Franklin Lakes, NJ 07417 US 28, Staverton Road, London, NW2 5HL UK Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. //.- INTERESTED IN THIS MESSAGE?

RELATED CONTENT - Sonic Takes Another Shot at TIBCO (Blogs) Business Intelligence (Wiki) formatting a line chart (Groups) -.// '. Cognos cubes are proprietary.

You won't be 'integrating with Cognos cubes' without a Cognos layer somewhere in the stack. Figure in added licensing cost (potentially significant), if you must use that as a data source. Bill William E.

Pearson III CPA, CMA, CIA, MCSE, MCDBA Island Technologies Inc. 931 Monroe Drive Suite 102-321 Atlanta, GA 30308 404.872.5972 Office wep3@islandtechnologies.com wep3@cognos-architect.com - - - - - Publisher Sites: 6f -Original Message- From: bounce-27234@groups.ittoolbox.com mailto:bounce-27234@groups.ittoolbox.com On Behalf Of spmohanty via bi-select Sent: Monday, November 20, 2006 11:58 PM To: WEP3 - Architect Subject: bi-select Ad-Hoc Reporting capability Please advice on 1) what you think is the best tool out there in the market producing the best adhoc capability for reporting. 2) How well does it integrate with a data warehouse or data marts?

3) Integration with essbase or Cognos cubes? 5) Performance? 6) User acceptance success?

7) Deployment strength? To how many users? 8) Ease of use? 9) Comparison to Cognos or Hyperion Performance Suite? Any feedback would be greatly appreciated.

Regards Sam Mohanty, Director clickISC 724 Highwoods Dr, Franklin Lakes, NJ 07417 US 28, Staverton Road, London, NW2 5HL UK Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. //.- INTERESTED IN THIS MESSAGE? RELATED CONTENT - Open Source vs. Commercial NMS software (Blogs) Data Mining (Wiki) RE: cannot import the table in framework because of one column in the table (Groups) -.//. Ad Hoc comes in two flavors: 1) a stand-alone client-based or web-based ad hoc reporting tool that allows an end-user to build and style an entire report from scratch 2) self-service parameterized reporting - allows end users to customize reports from a fixed list of fields, output formats, filters and styling choices. I believe category 1 has far less of a potential user base than category 2 at most companies.

No matter how easy to use an ad hoc reporting tool is, starting with a blank slate is just a little overwhelming to most end users. Give them a well designed template or parameter-driven front-end and I believe more people will be more likely to get good use out of the reporting system. That said, I know IBI webfocus (what we use) has a good ad hoc reporting tool ('Power Painter') and great self-service reporting capabilities. We only have a few users of our current app, but I know that companies like Pershing have upwards of 75,000 users hitting one particular BI app. And this isn't even their largest deployment.

Webfocus also has a new feature called 'Active Reports' which we haven't brought in house yet, but I've demo'ed it on their web site. It includes re-sorting, filtering, charts and visualization functions embedded into the report itself so changing the sort, or displaying the graph or applying a new filter does not require you to go and do another pass at the data, nor does it require you to even be connected to the network. It's all embedded into the file so you can take it with you. Pricing was 'affordable' (otherwise we couldn't have bought it) and performance is excellent. Also, they do have an interface to Essbase, but I'm not sure about Cognos (probably not). They provide interfaces to all of the 'usual suspects' in terms of DMs and DWs (Oracle, UDB, SQL Server, etc.). Hope that helps.

JC -Original Message- From: spmohanty via bi-select mailto:bi-select@Groups.ITtoolbox.com Sent: Monday, November 20, 2006 11:58 PM To: joseph.coule Subject: bi-select Ad-Hoc Reporting capability Please advice on 1) what you think is the best tool out there in the market producing the best adhoc capability for reporting. 2) How well does it integrate with a data warehouse or data marts? 3) Integration with essbase or Cognos cubes? 5) Performance?

6) User acceptance success? 7) Deployment strength? To how many users? 8) Ease of use? 9) Comparison to Cognos or Hyperion Performance Suite? Any feedback would be greatly appreciated. Regards Sam Mohanty, Director clickISC 724 Highwoods Dr, Franklin Lakes, NJ 07417 US 28, Staverton Road, London, NW2 5HL UK Check out the new AOL.

Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. //.- INTERESTED IN THIS MESSAGE? RELATED CONTENT - Software Reuse Program: ComponentUser (Blogs) Data Mining (Wiki) RE: Transpose column to a row (Groups) -.//.

Hello Jesse, Our company is currently looking for a BI solution. We are currenlty using 'Pronto software' as our ERP software, which runs on AIX box with a C-ISAM database. We are located in Australia. Just wondering if your company have a branch in Australia or a reseller which we can talk to.

I am interested to find out more about your product, cost and requirements etc to run your solution. Kind regardsSong Su IT Manager Creative Brands Pty Ltd. + 61 3 9574 2100 F. + 61 3 9574 2144 Creative Brands 30 Bando Road Springvale, Victoria, 3171 AUSTRALIA -Original Message- From: Jsams02 via bi-select mailto:bi-select@Groups.ITtoolbox.com Sent: Thursday, December 14, 2006 9:46 AM To: Song Su Subject: RE:bi-select Ad-Hoc Reporting capability Hello Sam, You may want to have a look at LogiXML's - LGX Ad Hoc solution. The tool is completely DB and browser neutral, and also 100% web-based (thus it would integrate well with DW and DMs).

Pricing is 10k per processor and there is no charge for the number of end-users. Deployment takes weeks as opposed to months and months (meta data later setup). If you like I can send you more info. Feel free to contact me at: Jesse@logixml.com Jesse Samuelson Product Specialist.

Hi All, Jinfonet Software Inc. Makes a product called JReport. It is a 100% Java embedded reporting solution. It is designed to be fully embedded in any Java application to deliver interactive web reports that are totally seamless to your application.

It is the oldest 100% Java reporting solution on the market. They began selling the first version of their product in 1998.

Ad hoc, dynamic OLAP cubes and enterprise level performance are just some of the reasons that the world largest companies choose JReport. For more info go to www.jinfonet.com Or feel free to contact me. We also have international resellers all over the world. Scott Krass Jinfonet Software Inc www.jinfonet.com 240.477.1075 - Office 301.379.8340 - Mobile SKrass@jinfonet.com -Original Message- From: song.su via bi-select mailto:bi-select@Groups.ITtoolbox.com Sent: Wednesday, December 13, 2006 8:17 PM To: Scott Krass Subject: RE: bi-select Ad-Hoc Reporting capability Hello Jesse, Our company is currently looking for a BI solution. We are currenlty using 'Pronto software' as our ERP software, which runs on AIX box with a C-ISAM database. We are located in Australia. Just wondering if your company have a branch in Australia or a reseller which we can talk to.

I am interested to find out more about your product, cost and requirements etc to run your solution. Kind regardsSong Su IT Manager Creative Brands Pty Ltd. + 61 3 9574 2100 F. + 61 3 9574 2144 Creative Brands 30 Bando Road Springvale, Victoria, 3171 AUSTRALIA -Original Message- From: Jsams02 via bi-select mailto:bi-select@Groups.ITtoolbox.com Sent: Thursday, December 14, 2006 9:46 AM To: Song Su Subject: RE:bi-select Ad-Hoc Reporting capability Hello Sam, You may want to have a look at LogiXML's - LGX Ad Hoc solution.

Ad Hoc Reporting Tools

The tool is completely DB and browser neutral, and also 100% web-based (thus it would integrate well with DW and DMs). Pricing is 10k per processor and there is no charge for the number of end-users. Deployment takes weeks as opposed to months and months (meta data later setup).

Reporting Tool For Sql Server

If you like I can send you more info. Feel free to contact me at: Jesse@logixml.com Jesse Samuelson Product Specialist.