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]
ETL - The Secret Weapon in Data Warehousing and Business Intelligence
White Papers This paper tries to explain the importance of ETL i.e.extract, transfer and load in business intelligence and data warehousing. The desire to refine and derive solid business intelligence (BI) from the oceans of raw data rapidly growing in today's...
[August 26, 2004, 3:00]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
Advanced ETL Processor Enterprise
Downloads Advanced ETL Processor Enterprise is a Codeless Automation Tool. By combining simple Package actions together Advanced ETL Processor Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
[May 13, 2009, 12:57]
ETL-The Secret Weapon in Data Warehousing and Business Intelligence ETL-The Secret Weapon in Data Warehousing and Business Intelligence
White Papers This paper tries to explain the importance of ETL i.e.extract, transfer and load in business intelligence and data warehousing. The desire to refine and derive solid business intelligence (BI) from the oceans of raw data rapidly growing in today's...
[August 21, 2004, 3: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]
The Evolution of ETL - From Hand-Coded ETL to Tool-Based ETL
White Papers But these hand-coded ETL resulted in a lot of hard-to-maintain "Spaghetti" code and it is hard enough to get programmers to document it. To build a data warehouse various tools are used like modeling tools to design a warehouse, database tools to...
[June 12, 2009, 3:04]
Hummingbird ETL, Solutions for SAP
White Papers This paper explores the opportunity presented by successfully integrating SAP R/3 data with other business applications throughout the enterprise.Moreover, it addresses the challenges of SAP R/3 integration and the requirements for overcoming...
[June 24, 2009, 8:40]
