|
DH
ETL™
DH
ETL is the most cost-effective way to build SQL Server data warehouses.
DH ETL
builds SQL Server data warehouses without programming. It
dynamically generates DTS
Packages and Stored Procedures through a 100% metadata-driven
interface.
DH ETL supports transformations with functions and
conditional logic, and its Calculation Engine automatically manages
transformation dependencies.
DH ETL hides the complexities
of Microsoft DTS from the user, with a
programming free and visual interface. Simply stated, DH ETL eliminates
the need for programming scripts and stored procedures when building
snowflake and star schemas, as well as de-normalized relational models
for reporting.
- You want to deploy your
Business Intelligence solution in the shortest time possible
- You need to
easily maintain and quickly modify your data warehouse
- You want to fully exploit Microsoft
Business Intelligence tools
- Your ETL projects are taking
your time away from analytic applications
- You find it hard to build and
modify data cubes
- You have limited IT resources
- Metadata-driven interface
- Supports transformations with
functions and conditions
- Builds complex metrics or key
performance indicators
- Builds star schemas,
snowflake, and de-normalized relational data models
- Formula dependencies are
automatically managed
- Automatic propagation of
changes in business rules
- High degree of reusability of
objects
- Automatic documentation of
data warehouse
- Automatically integrates data
warehouse to Crystal Reports at metadata level
- Eliminates the need to create
Microsoft® DTS Packages and stored
procedures
ETL Works
- Point
to the source database tables and fields you want in the data
warehouse, and define the level of granularity per table.
- Visually
create new tables and new fields, transformations, relationships,
filters, summaries, formulas, star schemas, snowflake schemas, and
business metrics.
- Build
complex metrics with DH ETL’s powerful formula engine; it automatically
manages formula dependencies, dramatically decreasing maintenance
costs.
- Use
DH ETL’s extensive data modeling capabilities to meet any data
warehouse design specification.
- Perform
data warehouse auditing functions with the embedded query and reporting
tools.
- DH
ETL dynamically creates the SQL Server data warehouses, on demand or on
a schedule.
:
- Windows and
MS SQL Server 2000 with 256 MB RAM
- 60 MB of disk
space plus application data
*
Microsoft® SQL Server™ 2000 Data Transformation
Services (DTS) is a set of graphical tools and programmable objects
that lets you extract, transform, and consolidate data from disparate
sources into single or multiple destinations.
|
White
paper
Datasheet
Brochures
Technical
Overview
|
