Symtrax, un fabricante norteamericano de software para Business Intelligence, que tiene oficinas en España, ha lanzado recientemente la última versión de su herramienta analítica integrada con excel, el StarQuery 1.5. Esta herramienta tiene la peculiaridad de poder conectar e interactuar desde excel todo tipo de bases de datos, entre ellas: DB2, Oracle, Access and MSSQL, StarQuery now operates with Lotus Domino, Sybase SQL, IBM Informix, MS FoxPro…

Más información en español sobre Symtrax:

O contacte con Mirjenko García Travanic / Tél. : 900 97 33 97


Symtrax is pleased to announce the release of StarQuery 1.5. StarQuery is a powerful analytical tool that can create complex reports from virtually any database and send the data straight into Excel for efficient end-user analysis.

One major improvement in StarQuery 1.5 is the number of databases it can now connect to and query. In addition to querying such databases as DB2, Oracle, Access and MSSQL, StarQuery now operates with Lotus Domino, Sybase SQL, IBM Informix, MS FoxPro and more.

Making StarQuery compatible with virtually every database out there completely opens up the possibilities, said David Morgenstern, Vice President of Symtrax Corporation. An increasing amount of organizations store their information on multiple databases and StarQuery allows users to be able to access this information without needing a different query product for each respective database, Morgenstern said.

StarQuery is split into three modules StarQuery MapDesigner, StarQuery for Excel and StarQuery Runtime. StarQuery MapDesigner, managed by the database administrator, enables the creation of a Map File or a functional view of the database, which includes database tables, dimensions and calculations. These Map Files include all the information that is going to be accessible to the end-users, said Morgenstern. With StarQuery 1.5, when the database is modified or updated, the Map File is automatically synchronized with the database and can reflect these changes with just a click of a button. This is crucial for end-users as they can update their queries immediately for accurate, real-time reporting.

Once the Map File is complete, it can be made accessible to end users who can then create their own queries, based on the information within the Map File, by using StarQuery for Excel. With version 1.5, StarQuery for Excel includes several new features, which enhance end-user reporting.

One new feature of StarQuery for Excel is the ability to split data into different Excel worksheets depending on the data within a query. For example a sales manager may want to have a new worksheet for every different state, says Morgenstern. StarQuery can now create several excel sheets with just one query, rename the sheets according to the variable in which the query was split and group the data. This is an ideal way of being able to quickly access and analyze information, he continued.

End-users can also make calculations and create functions on hidden data. Previously, if a user were to make a calculation with data in two Excel columns, these columns would have to appear in the query. With version 1.5, these columns can be hidden, allowing users to make calculations on data that doesnt have to be in the same Excel sheet, ideal for creating reports, which only contain data end-users want to see.

Also new in StarQuery 1.5 are variable forms, which allow users to be prompted when they run a query. The resulting pop-up box asks the user to more precisely specify which data they would like to receive in the spreadsheet (select a part number, state, sales representative, etc.). Variable forms make StarQuery more interactive with the user and easier to use, says Morgenstern.

Finally, administrators can now store their Map Files on a web server, which will now allow web-based end-users to run queries. This means for example, an administrator in the US can create a Map File and make it accessible to anyone with Internet access, says Morgenstern. He continued, This can create a global network in which users can run queries 24-hours-a-day, regardless of location.

Also newly available is the StarQuery Runtime module. Queries are first created with the more extensive StarQuery for Excel module, then distributed to Runtime users or consolidated on a network or other repository. Runtime users may then run queries but cannot modify them. This is ideal for non-technical users who do not need to create their own queries, but who still require data in a timely fashion. Runtime users also benefit from the variable forms (as mentioned earlier), and can be prompted with a pop-up box when executing a query.

For more information on StarQuery, visit the website at:

Pinche aquí para visitar el FORO SOBRE ENTERPRISE CONTENT MANAGEMENT  y comentar esta información.
Pinche aquí para visitar el FORO SOBRE BUSINESS INTELLIGENCE  y comentar esta información.


Por admin