Esperant - The Query and Reporting Tool for Better Business Decisions

Esperant is a sophisticated query and reporting solution that gives you the power to query complex data and rapidly generate reports from your desktop or on the Web. Esperant’s robust SQL generator and predefined query formats improve business performance by making complex reports as simple as pointing and clicking.

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.

Convenient Integration.

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.

Esperant Features:

Query Expert

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.

Powerful wizards

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.

Powerful exporting

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.

System Requirements:

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.