Database Modeling
Create, Compare, and Update
Visual Database Models
Datanamic Solutions B.V. has announced the
release of DeZign for Databases 5, an application
that allows DBAs to create, compare, and modify
database models. According to Datanamic, the
software relies on a visual creation metaphor that
simplifies the creation of data models. This latest
version introduces improved data and function
conversion rules that improve accuracy when migrating data models from one platform to another. SQL Server
2005, 2000, 7.0, and 6.5 are supported, and pricing begins at $245 per user. For more information, contact
Datanamic Solutions at support@datanamic.com or visit www.datanamic.com.
Refer to Figure 1 for more information
Business Intelligence
OLAP Reporting and Analysis Tool
CNS International’s DataWarehouse Explorer analyzes and generates reports from SQL Server, Oracle, and IBM
databases. The software features an interface that closely resembles Microsoft Office 2007, a feature that helps
end users more easily create their own reports, while an included server component enables DBAs to manage
and view generated reports. DataWarehouse Explorer is written in .NET, and offers an OLAP reporting feature
that requires the use of the Microsoft Analysis Services server. The application also relies upon the Microsoft
Reporting Services server bundled with SQL Server 2005. For more information, contact Datanamic Solutions
at sales@cns.nl or visit www.cns.nl.
Development
Database Programming and Maintenance
Caber Computing has released SqlTac, a product that provides a
number of utilities for SQL Server DBAs and developers that rely on
Visual Studio to create database applications. For DBAs, SqlTac can
be used to validate SQL statements, capture domain knowledge, and
troubleshoot and resolve generic database design issues. For developers,
the product generates DLinq’s DataAccess layer, provides Object-Relational
Mapping (ORM), and saves database schemas. It can also validate
SQL code used in stored procedures and user-defined functions,
and offers a variety of search tools for finding specific SQL statements.
SqlTac supports SQL Server 2008, 2005, and 2000, and pricing begins
at $295 per user. For more information, contact Caber Computing Inc.
at info@cabercomputing.com or visit www.cabercomputing.com.
Refer to Figure 2 for more information
To read our product spotlight on virtualization, see “Virtualization: Flexible Product Release Management” InstantDoc ID 98566.