Previous
ETL of your own - wise or not?
Blog ETL - Extracting and reading data from the original source, Transforming it to suit your business, that is, cleansing and formatting it, and finally Loading(sending) it to your system/database/warehouse
[October 14, 2008, 12:03]
EAI Vs. ETL: Drawing Boundaries for Data Integration
White Papers Data integration, a function of ETL, is a prominent need as mediocre data at the foundation of any BI initiative fails to provide an accurate picture of the business. Thus the vital question: EAI or ETL?
[October 14, 2008, 1:01]
SQL Server 2005 Gives Microsoft IT FeedStore Group Enterprise-Grade ETL and Encryption
White Papers SQL Server 2005 Integration Services for Extract, Transform, and Load (ETL) processes is a major new enterprise-level feature being deployed for FeedStore. When managers at Microsoft Corporation need information, they turn to a repository called...
[January 1, 2007, 0:00]
Orchid: Integrating Schema Mapping and ETL
White Papers This paper describes Orchid, a system that converts declarative mapping specifications into data flow specifications (ETL jobs) and vice versa. Orchid provides an abstract operator model that serves as a common model for both transformation...
[October 14, 2008, 1:01]
Grid-Enabled Data Management and ETL
White Papers This paper describes the Univa UD solution for enhancing Extract, Transform and Load (ETL) performance by combining parallel processing with an appropriate process architecture to reduce processing timeframes and increase responsiveness and...
[October 14, 2008, 1:01]
Managing ETL Processes
White Papers ETL tools allow the definition of sometimes complex processes to extract, transform, and load heterogeneous data into a data warehouse or to perform other data migration tasks. In larger organizations many ETL processes of different data...
[October 14, 2008, 1:01]
Base SAS Vs. SAS Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It
White Papers So which tools, technologies and/or approaches can be used for ETL and which make sense for any given application? This paper explores the world of ETL from the perspective of the tasks that the programmers have to accomplish and compare using Base...
[December 22, 2006, 0:00]
Litigation Data Analysis/Auditing/ETL for BI: Triples Separated at Birth
White Papers This paper shows how the steps in Litigation Data Analysis (Litigation Analysis), Auditing and Extract-Transform-Load for Business Intelligence (ETL for BI, or data warehousing for business data analysis) are inherently similar; it is just the...
[December 27, 2006, 0:00]
N.C. Central University Selects SAS Enterprise BI Server, SAS ETL Server
White Papers NCCU has selected SAS Enterprise BI Server and SAS ETL Server software. As North Carolina Central University (NCCU) rapidly grows in size and stature, the number of time-consuming, ad hoc requests for information has increased dramatically, and the...
[January 5, 2007, 0:00]
MSDN Webcast: Integrating Hand-Coded ETL With SQL Server Integration Services (Level 300)
White Papers For years one has been told that Extract Transform and Load (ETL) development is a struggle between hand-coding and tools. Well, the ETL struggle is over and the winner is the developer who chooses Microsoft SQL Server Integration Services (SSIS).
[May 5, 2006, 0:00]
Deciding the Physical Implementation of ETL Workflows
White Papers This paper deals with the problem of determining the best possible physical implementation of an ETL workflow, given its logical-level description and an appropriate cost model as inputs. The paper formulates the problem as a state-space problem...
[October 14, 2008, 1:01]
Building ETL Processes for Business Intelligence Solutions Built on Microsoft SQL Server
White Papers Designing and building solid ETL processes is critical to the success of data warehouse. If one takes time and design a flexible ETL process one will find that life becomes much easier later when one acquires a new data source.
[August 7, 2009, 1:20]
Using SAS ETL Studio to Convert Clinical Trials Data to the CDISC SDTM
White Papers ETL Studio is the new SAS product designed to support a warehouse building process. Octagon Research Solutions uses ETL Studio as the key software application in the complex process of converting its clients' clinical trials data into submission...
[October 14, 2008, 1:01]
Mapping Conceptual to Logical Models for ETL Processes
White Papers Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In previous line of research, the paper has...
[October 14, 2008, 1:01]
Advanced ETL With Pentaho Data Integration
White Papers This white paper attempts to introduce the community to the functionality native to Breadboard BI's ETL Solution Slices. The recent quote in the industry press about the great potential of Pentaho Data Integration (formerly named Kettle) drew a lot...
[September 1, 2006, 1:00]
ETL of your own - wise or not?
Blog Comment Thanks for bringing this to my attention, fixed it in the first paragraph.
[October 14, 2008, 11:11]
Speeding ETL Processing in Data Warehouses
White Papers Staying competitive in today's real-time business world demands the capability to process ever-increasing volumes of data at lightning speed. In today's fast-changing, competitive environment, a complaint frequently heard by data warehouse users is...
[October 14, 2008, 1:01]
Understanding the System Architecture of SAS/ETL and SAS/EBI Server for Federal Enterprise Architecture Requirements
White Papers This paper describes some of the key points learned through: many conversations with SAS Institute, and persistence to understand how the SAS Enterprise Business Intelligence Server and the Extraction, Transformation, and Loading Server work.
[December 22, 2006, 0:00]
Oracle Warehouse Builder 10g Release 2 - Business Rule Driven Data Integration
White Papers This paper shows how one can create business rules in Warehouse Builder and then apply them to real world ETL problems. The reader will see how changing a business rule will change the ETL logic with a few simple clicks.
[June 5, 2007, 1:00]
