ibax - enterprise business intelligence

Overview

Publications

Products

aito - Analytical Reporting

Individual BI Solutions

Competence

ETLight

ETLight provides an ETL implementation framework (Extract, Transform, Load) for Microsoft SQL Server 2005/2008. It's purely based on the core of the SQL Server engine itself (T-SQL, SQL Agent).

Advantages compared to other multi-component ETL solutions

Lightweight Architecture: T-SQL, SQL Agent only - no SSIS, etc.

Performance: parallel processing in unlimited number of instances

Features of prebuild ETL functionality:

extract filtered data from any local or (linked) server instances
data structure cross-check between source and target
index creation and maintenance on target objects
fact support to delete duplicate records
dimension support for insert new and update existing items
extensible thru open code calling interface for special tasks
customizable thru unlimited access to ETL
procedure code and repository objects

Note: ETLight can also be combined with other of our powerful tools like SQL Parallel Boost and SQL File Importer.

For more information and/or an evaluation copy, please contact us.

SQL Parallel Boost - Free Download | August 2011

A Community Edition of SQL Parallel Boost can be downloaded for free at www.codeplex.com

Get SQL Parallel Boost

ETLight 2.5 | Juli 2011

The new version of ETLight provides a lightweight implementation framework for rapid implementation of custom data mart implementations.

Details

Development Partnership | April 2011

Official development partnership with excellente for aito standard reports.

Partner List

New Offices | January 2011

ibax is moving all existing locations to new offices.
New address from
15th January 2011:
Talweg 74
8707 Uetikon am See

Location Details

aito for ABACUS | Nov 2010

aito 2.0 goes in production at Athleticum Sport Markets. The platform is used for financial & analytical dashboards/reporting and multi-scenario financial budgeting & planning.

Details