Business Intelligence
ProClarity Analytics
The platinum winner in the Business Intelligence category is ProClarity Analytics, a complete analytics platform that lets you query Analysis Services data and presents results in dashboard and scorecard formats for business-performance monitoring and analysis. Early this year, ProClarity announced ProClarity Analytics 6.1 add-ons, including ProClarity for Business Scorecard Manager, which lets you investigate the key performance indicators (KPIs) in Microsoft Office Business Scorecard Manager; ProClarity for Reporting Services, which lets you create Reporting Services reports without opening Visual Studio; ProClarity for SharePoint Portal Server, which displays ProClarity analytic views within a Microsoft SharePoint Portal System; and ProClarity Publishing Server, which lets you create PDF and HTML documents that include ProClarity analytic views and author commentary. Shortly after the release of these add-ons,Microsoft announced its purchase of ProClarity. Microsoft plans to integrate ProClarity as the analytics component of Office PerformancePoint Server 2007, the software giant's comprehensive BI solution, scheduled for release late next year. Contact ProClarity at 208-344-1630 or http://www.proclarity.com.
See Associated Figure
Panorama 4.5
The gold winner in the Business Intelligence category, Panorama, also has a close working relationship with Microsoft. At the same time, the company provides a BI platform that it hopes gives customers a reason to look beyond Microsoft tools. Oudi Antebi, Panorama vice president of marketing and strategy, explains that Microsoft's foray into the BI arena "is very application focused.You look at data in one app, your scorecard is in another app, [and] reporting is in another app.All those environments might connect to the same cube, but all have separate metadata and require separate configuration." Panorama NovaView 5, one of the key components of the company's BI platform meets a company's BI needs through a single UI. In addition, the product offers integration with Microsoft Office, real-time updates and collaboration, and "guided analytics," an interactive environment that helps users intelligently select the information they need. The Panorama 4.5 suite of products includes NovaView Dashboards, NovaView Analytics, NovaView Reporting, and NovaView Scorecards. Contact Panorama at 201-804-0144 or http://www.panorama.com.
See Associated Figure
Database Design
Sybase PowerDesigner 12
The platinum winner for Database Design tools stands alone in this category. PowerDesigner 12 by Sybase supports conceptual, physical, and logical data models in addition to application and business-process modeling. In addition to standard modeling languages such as IDEF, PowerDesigner supports XML-specific modeling techniques linked to UML and data models. By using the product's metadata repository, an organization can store, manage, and maintain versions of PowerDesigner models and all other documents in a single location and analyze the upstream and downstream affects of model changes. This analysis capability can help you see the affect of changes before they are made to production databases. The common repository lets you store and maintain cross-model dependencies and supports the reuse of objects across all models and projects. Multiple modelers can work on the same model at the same time, but you can also limit access and visibility to model objects by using role-based security that defines users and permissions within the tool. In addition, you choose the relational database that will host PowerDesigner's Enterprise Repository, so the repository is highly scalable and open.This repository supports version control, configuration management, delta reports between models and versions, and comprehensive search capabilities across the repository.The enterprise edition of PowerDesigner 12 includes the T-SQL commands for opening and closing a database as part of code-generation and incorporates changes to the catalog for proper reverse engineering. PowerDesigner's UML modeling supports forward and reverse engineering ofVisual Basic .NET andVisual C# .NET. Contact Sybase at 800-792-2735, 925-236-5100, or http://www.sybase.com.
Database Development
Quest Software SQL Turbo
The platinum award in the Database Development tools category goes to Quest Software's SQL Turbo, a product that can dramatically increase the speed of SQL Server's full text retrieval by using the IMCEDA Search Engine.The search engine is a thin application layer that sits on top of the SQL Server database and uses SQL Server's database components. The low overhead of this database-indexing approach contributes to SQL Turbo's processing speed. SQL Turbo is designed to achieve high performance for database text retrieval and in certain cases can retrieve results more than 100 times faster than SQL Server's Full-Text Catalog.You can launch SQL Turbo from within Enterprise Manager or SQL Server Management Studio (SSMS). SQL Turbo is fully integrated with SQL Server, and you can use stored procedures to access the tool, so SQL developers can easily use SQL Turbo from SQL batches or other stored procedures.The product uses indexes generated from the SQL Server database to search for information. Search query results are returned as a normal database record set exactly as if you were executing a standard SQL query. Contact Quest Software at 949-754-8000 or http://www.quest.com/sql_turbo.
See Associated Figure
ApexSQL Edit
The gold winner in the Database Development category is ApexSQL Edit, a development tool especially designed for SQL Server developers.The ApexSQL Edit IDE provides many advanced SQL database-development features including SQL Intellisense, formatting, and data editing. In addition, the product provides support for SQL Server 2005, centralized mapping, Object Explorer, code snippets, and object notes. For source control, ApexSQL Edit is integrated with Microsoft Visual SourceSafe. ApexSQL Edit also includes a results pane that lets you group and filter results and gives you the ability to provide automatic filtering with drop-down selections. These features are designed to save developers' time and produce higher quality code. A trial version of the software is available. Contact ApexSQL at 866-665-5500, 919-968-8452, or http://www.apexsql.com.
Prev. page
1
[2]
3
4
5
next page 
