The Challenge: Flexible, Powerful Enterprise Reporting.
In today’s competitive marketplace, your business needs to know where it stands at all times. This means getting accurate, customized reports when you need them. You know from experience that reports are only as good as their underlying SQL requests. You also know that few managers have the time to master SQL, and your techni- cal personnel don’t always have time to design one custom report after another. So what do you do?
The Solution: Esperant.
With Esperant, sophisticated database querying and reporting couldn’t be easier. Esperant lets you access complex databases and produce custom reports using your own business terms. Esperant guides you while you define queries in a simple, English-like language, so it’s easy to understand exactly what is being retrieved from the database. Esperant’s SQL generator is one of the most advanced on the market. It handles everything from basic SQL to complex sub-queries, outer joins and unions—all automatically generated to match the underlying RDBMS.
The Esperant Advantage.
Esperant is accurate, powerful and easy-to-use. It lets you run any type of query, even if you don’t know SQL. And it’s impossible to make a mistake. Esperant’s patented Query Expert simply won’t let you create joins or queries that are syntactically correct but return wrong results. From there, Esperant offers a myriad of possibilities, including powerful formatting and chart functionality, data mining and versa- tile display options. And when you’re ready to share query results, Esperant comes through with easy-to-use export- ing, Web and e-mail capabilities.
Flexible Report Formatting.
Query results are formatted for the screen or for printing with alignment and format options that let you customize and control the appearance of your report or chart. Re-sorting, grouping, ranking and totaling are available. The Calculated Field Editor’s wide range of functions lets you create new fields that are computed from query results. Bitmaps and OLE objects can easily be embedded in reports.
You don’t need to transfer data from one tool to another when you use Esperant. For example, Esperant includes a fully-integrated Visualizer for data mining, so you don’t have to transfer information or open a new application when you want to explore query results. Complete integration of Esper- ant components makes reporting and data mining more efficient and enhances the quality of the information you view.
The patented Query Expert won’t let you create queries that are syntactically correct but return incorrect results. The Query Expert validates your query as you compose it, then creates the SQL statements for the RDBMS.
Charts, crosstabs and the Visualizer
Query results are displayed by default as a report, but you can easily transform reports into charts and crosstabs. For data mining, the powerful Visualizer identifies correla- tions between data elements and reveals patterns or exceptions you might otherwise miss.
From the Query Expert to the Visualizer, Esperant is wizard-driven. Other wizards include the AutoBuild Wizard, which helps DBAs create and modify data views, and the Merge Wizard, which lets users combine queries to see results that are difficult to achieve with just one query.
Esperant data views
Data views offer a streamlined business-oriented view of your corporate databases. They act as the heart of query and reporting projects.
Robust security system
Esperant uses hierarchical security with multiple inheri- tance, or existing database and platform security.
Batching and scripting
You can schedule where and when you want queries performed by submitting them to a batch server queue. Scripts help you automate tasks, such as saving results as spreadsheets or tables.
Esperant easily exports query results to text files, data- base tables or spreadsheets. It can also export data views and repositories.
Optional Web front end
Esperant Web lets you view query results and reports in a browser anywhere, anytime. Esperant Web is based on a platform-independent Java API and offers customizable report templates with automatic hyperlinks.
Recommended configuration for client:
- Processor: Pentium® II 300 MHz or higher
- RAM: 256 MB
- OS: Windows
- Browser: Internet Explorer 5.5 SP2 or higher
Recommended configuration for server:
- Processor: Pentium® III 750 MHz or higher
- RAM: 256 MB
- Storage: 4 GB hard drive (200 MB free); CD-ROM
- OS: Window
- DBMS: Microsoft SQL Server, Oracle, DB2
Esperant Helps You...
- Improve access to information by giving all managers and employees powerful, versatile reporting capabilities.
- Disseminate information throughout the corporation. Your entire organization can share query results via e-mail or across the Web.
- Eliminate inaccurate queries and reports that lead to poor business decisions. Esperant was developed expressly to give ad hoc query and reporting capability to users who are more familiar with business than SQL.
- Monitor the progress of crucial projects and eliminate unwelcome surprises.