Building ETL Processes for Business Intelligence Solutions Built on Microsoft SQL Server
White Papers While not as flashy, ETL is just as important as the other aspects of Business Intelligence solution, if want a good BI solution, then need to take the time to develop a good ETL process. Designing and building solid ETL processes is critical to...
[August 7, 2009, 1:20]
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]
The Emerging Trend to Sales and Marketing Intelligence, Part 1
White Papers Business and customer intelligence have largely been associated to application providers that couple ETL tools with high-powered analytical capabilities to help sales and marketing managers integrate disparate databases into data warehouses to run...
[September 1, 2004, 3:00]
Oracle Warehouse Builder 10g
White Papers This white paper describes the Oracle Warehouse Builder architecture and explains why using this tool is ideal for customers choosing an ETL and design environment for their business intelligence projects.
[July 1, 2004, 3:00]
Oracle Business Intelligence Warehouse Builder 10g Release 2 Experts in Action: Loading Data Into Oracle E-Business Suite
White Papers Experts truly vault OWB 10gR2 from being 'just' an ETL tool into being a platform and fundamental component of the Oracle Business Intelligence stack, helping users throughout the organization solve their data and metadata integration and quality...
[March 10, 2006, 0:01]
Elixir Repertoire Whitepaper
White Papers Dashboard, Reporting, Data ETL and Scheduler. Elixir Repertoire, an integrated Business Intelligence (BI) suite, is ideally suited for providing holistic business views, ensuring optimal process and resource planning as well as service delivery...
[May 14, 2009, 1:17]
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]
MSDN geekSpeak Webcast: Extending SQL Server Integration Services With Reza Madani (Level 100)
White Papers It also takes questions about the most effective use of this powerful tool for implementing Extract, Transform, and Load (ETL) processes in Business Intelligence (BI) solutions. The presenters of this webcast share their knowledge and experience...
[March 25, 2008, 0:01]
Boats.com Unleashes the Power of Its Data Using Open Source Business Intelligence
White Papers MySQL was chosen as the database engine; the Pentaho business intelligence suite was chosen to provide Extract, Transform, Load (ETL) and analysis/ reporting functionality. YachtWorld.com and Boats.com required a flexible, highly-scalable...
[May 16, 2009, 1:17]
SAS marks 30 years with data integration record
News The process involved extracting, transforming and loading as much data as possible in an hour, a procedure known as ETL. Organisations are struggling with ever-increasing amounts of data that cannot be extracted and loaded using the ETL...
[May 17, 2006, 12:30]
Performance Management - Making It Work, Part 4: Data Mining to Support Performance Management With Analytical Intelligence
White Papers This paper describes how information technologies, namely data warehousing; data mining with their powerful Extraction, Transform, and Load (ETL) features, and business analytics (e.g.statistics, forecasting, and optimization) all produce data...
[August 10, 2006, 0:00]
Business intelligence goes open source
News In about a month, the company is expected to release a component for doing analysis and then a so-called ETL product later this year for moving data between different sources. On the heels of open-source databases come business-intelligence tools...
[April 24, 2006, 8:55]
Information Builders shows there's life in the over 40s yet
News Products include WebFocus application server; WebFocus ETL; a Java-based scheduling and distribution application called WebFocus Report Caster, and Enterprise Information Portal. This, he says, is a way of giving users the power to create business...
[September 25, 2001, 9:51]
Microsoft ventures into business intelligence
News In the next edition of SQL Server -- planned for release at the end of the year -- Microsoft plans to expand the number of utilities for moving and reformatting data, a set of features called extraction, transformation and loading, or ETL.
[January 27, 2004, 8:45]
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]
Microsoft plugs gaps in business intelligence tool
News In the next edition of SQL Server, codenamed Yukon, Microsoft will expand the number of utilities for moving and reformatting data, with a set of features called extraction, transformation and loading, or ETL.
[June 24, 2004, 14:05]
Offshore Application Development Helps Customer Intelligence Provider Get State-of-the-Art Product
White Papers At the same time, it outsourced the database development (ETL) process to TEAM International. In Q1 2008, VueLogic began development of a business analytics tool for the purpose of entering new markets with a competitive software product.
[May 21, 2009, 1:19]
Deploying Business Intelligence Solutions on Microsoft SQL Server 2005 and HP Integrity Servers
White Papers The paper presents an example hardware and software configuration that demonstrates deploying the Data Warehouse and Data Transformation Services (DTS) and/or Extract Transform and Load (ETL) DTS/ETL components of a mid-range BI solution...
[December 27, 2006, 0:00]
