iSeries Web Query and Reporting

Design real-time web based iSeries Reports and Queries fast and easy

Clover is an iSeries Web Query and Business Intelligence tool that lets unlimited end users and IT personnel design and run real-time web reports and queries deployed in browsers. You can create reports and graphs in minutes using the Clover Query templates and SQL wizards that make it easy to write reports with totals, level breaks, drill downs, export to Excel, graphs using SmartCharts and Executive Dashboards.

"We have found Clover to be a very useful tool in rapidly creating reports and getting them to the web. With Clover it's very easy to create a report and deploy it on our portal. I was able to create a report and display it as a bar graph in the first couple of hours we had the product. I also like the fact that we have unlimited users and developers. I know next to nothing about html and cgi programming, but Clover generates the html and cgi programs in a flash. Clover also lets you go in and tweak the html if you need to do that, making it very flexible. It's also possible to call RPG programs from a Clover report. "
- Dennis Ruud, Senior Pgmr / Analyst at Dominion Enterprises

You can also create ad hoc reports with Clover and use its full web development capabilities including dynamic library lists, editing records, change management and session ID handling. Plus, you’ll save lots of money too, because Clover includes unlimited users. So whether you have 6 or 600 people needing to access or create reports the cost will be the same.

"Clover adds much more flexibility than my previous report writer Crystal Reports in getting the data in the format and the results that I want in a single step. Very helpful."
- Todd Hanselman, Furniture Plus

Clover also integrates with the following solutions to take you further: WebSmart, Free* Nexus Portal and SmartCharts.

(Click animation to view real-time sample)

Clover Highlights

Reports have never been so easy to create!

End users—produce reports by following the basic Wizard prompts.
Power users—build complex reports with minimal or no coding, using the more advanced features of the templates and the Wizard.
Developers—use Clover and all the power of WebSmart’s IDE to build even more sophisticated reports.

The KPI’s, Charts and Summary Reports above were created in 5 minutes

Who Benefits

Anyone who wants to design iSeries reports and queries and deploy them in browsers-and anyone who cares about eliminating reporting requirement backlogs can benefit from Clover. Managers, power users and end users can even design their own reports without the need to ask programmers or designers to get involved. All levels of users can get timely, relevant, and accurate information on their desktops in a browser without client seats. And, users can access secured Clover-generated pages from anywhere: Internet, Extranet, or Intranet using very few resources.

Clover integration with WebSmart, SmartCharts and Nexus

Clover Integrates with WebSmart, Nexus and SmartCharts to further modernize business applications and processes:

	WebSmart: Clover is not simply an add-on product to WebSmart, our iSeries web application development solution. Moving back and forth between the core features of WebSmart and the reporting features of Clover is seamless. And all of the tools that are a core part of the WebSmart IDE are available to developers using Clover. You can actually write reports with little or no coding at all ! Clover’s own templates drive the report creation Wizards making it easy to design reports with breaks, subtotals, graphs, Excel spreadsheets and more. You can also relate many files (for example, join a header to a detail file) and specify just how you want the data sorted, filtered, and reported.
	Nexus: Nexus, our iSeries Web Portal and ECM solution, can provide the secure framework and organization required to provide users with secure access to their Clover reports and charts. It is also very easy to create Executive Dashboards or lists of links with your Clover queries and reports.
	SmartCharts: SmartCharts is an advanced set of KPIs, charts, graphs, gauges… that run as Flash objects and is included with Clover for free. Provide users with modern animated and professional quality graphical views of realtime data with drill down capabilities. Clover includes templates that incorporate SmartCharts with no coding required.

"IBM supports BCD's System i modernization suite -- WebSmart, Nexus Portal, Clover Query and Catapult -- and its use in the System i marketplace."

"BCD is an important and progressive solution provider and we appreciate their commitment to System i business modernization through the System i Initiative for Innovation program."
Elaine Lennox, IBM Vice President System i Marketing