Data Acquisition / ETL - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

The Forrester Wave Report: Enterprise Service Bus, Q2 2006 2006-08-31 08:27:16 Cape Clear Software

Excerpt from the Forrester Wave™ Report: "Cape Clear retains its leading position in Forrester's latest review of the standalone ESB market. The vendor is one of the pioneers in the enterprise service bus (ESB) category and continues to be among the leaders in technology innovation and strategic vision in this space.

Aggressive pursuit of emerging Web services standards and communication protocols, coupled with good tools for developing and deploying services, make Cape Clear a good choice for companies looking for an advanced ESB that can meet many service-oriented architecture (SOA) requirements."

Download this complimentary analyst report now, a $795 value.

Business Survival Series: Assess Your Resources 2006-06-23 01:00:29 SAS Institute

As the criticality and strategic nature of business intelligence increases within large enterprises, so does the importance of having a firm data foundation on which to base these efforts. Successful business intelligence requires data from across the enterprise, data that comes from a myriad of sources in a variety of formats. Somehow, a person must bring all this data together, reconcile inconsistencies, remove extraneous detail and standardize the output to create a cohesive, well-structured integrated data source that is ready for enterprise-level analysis. This webcast provides insights and guidance on data acquisition and management.

Unlocking ERP Data Using Open Source Tools 2006-09-01 01:00:13 Breadboard BI

This white paper details an effort to unlock ERP data using open source tools. The demand for such methods is made clear in a recent study by Ventana Research. The paper stated that 86% of organizations reported value from prebuilt report templates for ERP and CRM applications. In this paper, two methods will be briefly explored: report templates running over ERP application databases, and the use of ETL to extract ERP data and load dimensional table structures.

Seeing the Big Picture in Business Intelligence 2006-05-23 06:28:57 SAS

Data integration, data management, reporting and analytics... All too often they are treated as separate projects or handled at a departmental level. The result: isolated solutions to isolated problems. Only a holistic approach can help you achieve maximum visibility and operational effectiveness throughout your entire business.

Oracle Warehouse Builder 10g Release 2: What Is an Expert? 2006-07-25 00:49:22 Oracle

Oracle Warehouse Builder 10gR2 (OWB) provides a major leap forward in technology, aimed at helping users meet their organization's requirements to derive actionable knowledge from its data assets (infusing quality into the entire process). OWB 10g Release 2 enables users to deliver on the knowledge requirements of their organization by encapsulating expertise. This is done in the form of a feature called Experts - empowering broader audiences to use OWB functionality (without necessarily knowing that they are) to accomplish particular task flows, and also to help implement/enforce standards and best practices. Experts enable users to capture the knowledge (expertise) and best practices in Warehouse Builder and make them repeatable.

ETPL - Extract, Transform, Predict and Load 2006-07-04 04:36:33 Oracle

Implementing an "Extract, Transform, Predict and Load" process can generate a huge variety of new opportunities. Since predictive analytics automates the process of finding new values or associations within in a large database there is no need to perform the traditional types of manual analysis. This new model is set to have a huge impact on the development and deployment of corporate data warehouses. Oracle is the only company to acknowledge the importance of this new model. The 10g database comes fully ETPL enabled, with built in support for functions that enable high-speed data extraction, transformation, predictive analytics, and target loading.

SOA and Information Services 2006-09-15 10:02:51 IBM

This Bloor Research white paper by analyst Philip Howard discusses the importance of information management within the context of service-oriented architecture projects. The white paper explores the advantages of converting information into a set of reusable services within a SOA, to ensure accessibility, consistency, flexibility, and control. It also recommends an approach for information services that incorporates metadata management, data cleansing, and data transformation. Existing technology approaches, including Extract, Transform, and Load (ETL), Enterprise Information Integration (EII), and Master Data Management (MDM) are discussed.

Litigation Data Analysis/Auditing/ETL for BI: Triples Separated at Birth 2006-12-27 01:00:56 SAS Institute

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 emphasis and time spent on each step that varies, based on the participant's goal. This is due to the commonality of the underlying principles of "Truth," Reproducibility and Time-Invariance (also seen as Time-Invariant). If the process is flawed, or if the data or processes are "Out of sync," one with the other, then any subsequent decision based on that data or process is without merit. The paper will also cover the issue of time series data, and some of the problems it poses for each function.

Base SAS Vs. SAS Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It 2006-12-22 01:00:22 SAS Institute

Now all grown up and ready to take on the world, SAS software's ability to get at just about any data source, massage, cajole, beat, cleanse and transform information and then make it sing and dance in the tool of preference makes SAS the ideal choice for modern decision-support applications. 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 SAS tools versus Data Integration Studio (or as it is now known - SAS Data Integration Studio).

Documentation-Driven Techniques for Building SAS Data Warehouses 2006-12-22 01:00:22 SAS Institute

This paper describes a process that is used in a SAS data warehouse implementation. Data model documentation of a SAS data warehouse (in Microsoft Word or Excel) serves as a feed to a SAS program that performs Extract-Transform-Load (ETL). Coding techniques are presented for applying SAS formats, informats, and labels to SAS data warehouse tables. It proved to be extremely efficient during development, when data models often undergo changes and modifications. This suggested approach significantly speeds up the implementation of data warehouses.

Jump to 1 2 [3] 4 5 6 7 8

Title	Date Added	Company
The Forrester Wave Report: Enterprise Service Bus, Q2 2006	2006-08-31 08:27:16	Cape Clear Software
Excerpt from the Forrester Wave™ Report: "Cape Clear retains its leading position in Forrester's latest review of the standalone ESB market. The vendor is one of the pioneers in the enterprise service bus (ESB) category and continues to be among the leaders in technology innovation and strategic vision in this space. Aggressive pursuit of emerging Web services standards and communication protocols, coupled with good tools for developing and deploying services, make Cape Clear a good choice for companies looking for an advanced ESB that can meet many service-oriented architecture (SOA) requirements." Download this complimentary analyst report now, a $795 value.
Business Survival Series: Assess Your Resources	2006-06-23 01:00:29	SAS Institute
As the criticality and strategic nature of business intelligence increases within large enterprises, so does the importance of having a firm data foundation on which to base these efforts. Successful business intelligence requires data from across the enterprise, data that comes from a myriad of sources in a variety of formats. Somehow, a person must bring all this data together, reconcile inconsistencies, remove extraneous detail and standardize the output to create a cohesive, well-structured integrated data source that is ready for enterprise-level analysis. This webcast provides insights and guidance on data acquisition and management.
Unlocking ERP Data Using Open Source Tools	2006-09-01 01:00:13	Breadboard BI
This white paper details an effort to unlock ERP data using open source tools. The demand for such methods is made clear in a recent study by Ventana Research. The paper stated that 86% of organizations reported value from prebuilt report templates for ERP and CRM applications. In this paper, two methods will be briefly explored: report templates running over ERP application databases, and the use of ETL to extract ERP data and load dimensional table structures.
Seeing the Big Picture in Business Intelligence	2006-05-23 06:28:57	SAS
Data integration, data management, reporting and analytics... All too often they are treated as separate projects or handled at a departmental level. The result: isolated solutions to isolated problems. Only a holistic approach can help you achieve maximum visibility and operational effectiveness throughout your entire business.
Oracle Warehouse Builder 10g Release 2: What Is an Expert?	2006-07-25 00:49:22	Oracle
Oracle Warehouse Builder 10gR2 (OWB) provides a major leap forward in technology, aimed at helping users meet their organization's requirements to derive actionable knowledge from its data assets (infusing quality into the entire process). OWB 10g Release 2 enables users to deliver on the knowledge requirements of their organization by encapsulating expertise. This is done in the form of a feature called Experts - empowering broader audiences to use OWB functionality (without necessarily knowing that they are) to accomplish particular task flows, and also to help implement/enforce standards and best practices. Experts enable users to capture the knowledge (expertise) and best practices in Warehouse Builder and make them repeatable.
ETPL - Extract, Transform, Predict and Load	2006-07-04 04:36:33	Oracle
Implementing an "Extract, Transform, Predict and Load" process can generate a huge variety of new opportunities. Since predictive analytics automates the process of finding new values or associations within in a large database there is no need to perform the traditional types of manual analysis. This new model is set to have a huge impact on the development and deployment of corporate data warehouses. Oracle is the only company to acknowledge the importance of this new model. The 10g database comes fully ETPL enabled, with built in support for functions that enable high-speed data extraction, transformation, predictive analytics, and target loading.
SOA and Information Services	2006-09-15 10:02:51	IBM
This Bloor Research white paper by analyst Philip Howard discusses the importance of information management within the context of service-oriented architecture projects. The white paper explores the advantages of converting information into a set of reusable services within a SOA, to ensure accessibility, consistency, flexibility, and control. It also recommends an approach for information services that incorporates metadata management, data cleansing, and data transformation. Existing technology approaches, including Extract, Transform, and Load (ETL), Enterprise Information Integration (EII), and Master Data Management (MDM) are discussed.
Litigation Data Analysis/Auditing/ETL for BI: Triples Separated at Birth	2006-12-27 01:00:56	SAS Institute
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 emphasis and time spent on each step that varies, based on the participant's goal. This is due to the commonality of the underlying principles of "Truth," Reproducibility and Time-Invariance (also seen as Time-Invariant). If the process is flawed, or if the data or processes are "Out of sync," one with the other, then any subsequent decision based on that data or process is without merit. The paper will also cover the issue of time series data, and some of the problems it poses for each function.
Base SAS Vs. SAS Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It	2006-12-22 01:00:22	SAS Institute
Now all grown up and ready to take on the world, SAS software's ability to get at just about any data source, massage, cajole, beat, cleanse and transform information and then make it sing and dance in the tool of preference makes SAS the ideal choice for modern decision-support applications. 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 SAS tools versus Data Integration Studio (or as it is now known - SAS Data Integration Studio).
Documentation-Driven Techniques for Building SAS Data Warehouses	2006-12-22 01:00:22	SAS Institute
This paper describes a process that is used in a SAS data warehouse implementation. Data model documentation of a SAS data warehouse (in Microsoft Word or Excel) serves as a feed to a SAS program that performs Extract-Transform-Load (ETL). Coding techniques are presented for applying SAS formats, informats, and labels to SAS data warehouse tables. It proved to be extremely efficient during development, when data models often undergo changes and modifications. This suggested approach significantly speeds up the implementation of data warehouses.