Understand and question the data to convert it into results, reports or information, whatever the data source, the complexity of the study, or the result destination . . .

 HARRYPilot vous permet :

• De créer des requêtes sophistiquées incluant des expressions calculées sauvegardées préalablement ou lancées à la volée,
• De gérer plusieurs milliers d'objets : colonnes, expressions, requêtes, avec de puissantes fonctions de recherche ou de remplacement,
• De sauvegarder des requêtes paramétrées et des rapports complexes utilisant les mêmes ou de nouveaux paramètres,
• De naviguer dans les données relationnelles, vectorielles ou multidimensionnelles par pivot d'axes, zoom, drill down.

A business oriented dictionary, multiple platforms, shared and/or private, A powerful system for analyzing and creating queries A navigation system in the data A report and graph generator A scheduler for delayed queries A single dictionary HARRYPilot provides access through a single dictionary: To the main data servers in the market by the owner's middleware and the source syntax of each SGBD/R, doing so regardless of the platform: Oracle, DB2, Sybase, SQL-Server, Informix or Teradata To HARRYVectorServer servers, Through ODBC to all the other servers and local databases such as DBASE, ACCESS and EXCEL. The dictionary lets the user create a business work environment independently of the physical structure, and lets the user structure the data into analyses or dimensional axes. It also facilitates the creation of folders, dynamic business views that hide the complexity of the tables and joins for the casual user. A powerful system for analyzing and creating queries The analysis system facilitates the creation and parameterization of queries: List, Group by, Cross table (with many variables in rows and columns), Overview of numeric variables, Hit-parade list, Top list, Compound queries (union, intersection, different, ...), Result join. It also facilitates the generation of local files in current office formats, or tables on the servers with automatic integration in the dictionary. HARRYPilot offers expert users functions for query concatenation, update or table modification, and the user of the source language. It offers the possibility to send direct e-mails or as part of conditional procedures. HARRYPilot is interfaced with the main mail clients: Microsoft Outlook, Netscape or Lotus Notes. A single data-navigation system The navigation system lets the user explore data through: Rotation of axes Zoom Drill-down A report and graph generator The report and graph generator lets the user: Make additional calculations (percentage, conditional calculation, etc.), Calculate subtotals, Apply presentation models specific to the enterprise, Insert graphs in the reports, Use parameters that can be incorporated in the query to improve the use of reports and to create applications, Generate various output files (EXCEL, TXT, PDF, RTF, etc.) or send e-mail messages. A scheduler for delayed queries The scheduler lets the user: Launch the execution of queries at a given time and specific frequency, Concatenate the query execution, Update the help or value lists, as well as the database descriptions, Interface the schedulers on the servers.