<%@ LANGUAGE=VBScript%> ETL for BI: Building Data Marts and Data Warehouses Optimized for Reporting
<% Dim xml Dim xsl Dim template Dim processor Set xml = Server.CreateObject("MSXML2.FreeThreadedDOMDocument.3.0") xml.async = false xml.load (Server.MapPath("dynoProd.xml")) Set xsl = Server.CreateObject("MSXML2.FreeThreadedDOMDocument.3.0") xsl.async = false xsl.load (Server.MapPath("dynoNavV2.xsl")) Set template = Server.CreateObject("MSXML2.XSLTemplate") template.stylesheet = xsl set processor = template.createProcessor() processor.input = xml CurrentLink = "/products/webfocus/quick_query.html" if CurrentLink <> "" then processor.addParameter "selectedlink", CurrentLink end if processor.transform() Response.write (processor.output) %>

ETL (Extract, Transform, and Load)
Data Management Solutions Fact Sheet (PDF)
Download free Adobe Acrobat Reader

Business Intelligence Platform and Database Support  Learn more
Read about our Informatica and Ascential ETL adapters for WebFOCUS*
Building Data Marts and Data Warehouses Optimized for Reporting
Information Builders offers comprehensive solutions for developing, managing, and optimizing a flexible data architecture that efficiently supports key enterprise information initiatives – including self-service applications, real-time information delivery, business activity monitoring, enterprise information portals, and more. Our data management and ETL solutions meet the widest range of information needs by enabling direct access to data in operational systems, staged data in warehouses or marts, as well as detail data via drill-throughs.

Supporting both business and technical users, WebFOCUS 7 employs different access techniques to produce high-quality data, a reusable infrastructure, and comprehensive metadata. Access techniques, which vary according to need, can include:

Using ETL to extract, transform, and load data directly into a data warehouse or mart
Directly accessing operational data stores or the files that service operational systems
Transparently drilling and joining data warehouses to operational data
Using operational systems' own application functions to access data
Trickle-feeding a data warehouse to populate and refresh it, using real-time transformation

DataMigrator
Fully automated extract, transform, and load (ETL) tools simplify the creation, maintenance, and expansion of data warehouses, data marts, micro marts, and operational data stores. An intuitive, easy-to-use interface enables fast end-to-end ETL process creation involving heterogeneous data structures across disparate computing platforms.

Aggregate, join, merge, and apply selection criteria to information from any combination of back-office systems
Simplify data movement from back-office systems to e-business platforms using automatically generated and managed FTP scripts or most native transport protocols
Transform data from raw forms into structures that are more suited to your application
Simplify loading of data into a target database through the automatic invocation of bulk loaders or row-at-a-time inserts
Execute, schedule, review, manage, audit, and create dependencies among ETL requests
A "change data capture" capability enables you to load only changed records into your data source, dramatically reducing the time needed to refresh data and making it easy to achieve a near-real-time data warehouse