(Extract, Transform, Load) The functions performed when pulling data out of one database and placing it into another of a different type. ETL is used to migrate data, often from relational databases into decision support systems.
ETL, EII and EAI
ETL differs from EII (enterprise information integration), which aggregates data temporarily from disparate data sources, and EAI (enterprise application integration), which integrates data from one application to another. See EII and EAI.
ETL, EII and EAI
ETL differs from EII (enterprise information integration), which aggregates data temporarily from disparate data sources, and EAI (enterprise application integration), which integrates data from one application to another. See EII and EAI.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Advanced ETL Processor 2.4.2.9 (Windows)
- Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be...
- Software downloads 2009-11-13
- Advanced ETL Processor Professional 3.3.2.17 (Windows)
- Advanced ETL Processor Professional is a Codeless Automation Tool. Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis. By combining simple Package actions together Advanced ETL Processor Professional...
- Software downloads 2009-11-13
- Advanced ETL Processor Enterprise 3.3.2.17 (Windows)
- Advanced ETL Processor Enterprise is a Codeless Automation Tool. Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis. By combining simple Package actions together Advanced ETL Processor Enterprise...
- Software downloads 2009-11-13
- Visual Importer 4.9.4.8 (Windows)
- Now you can load 14,347 records a second with the easy-to-use visual importer ETL. If you regularly export, transform or load database data, visual importer ETL is designed to save you time. It does this in three ways: Processing speed--using visual importer ETL standard version, you can load a delimited...
- Software downloads 2009-11-13
- AnyDbTest 2.3 (Windows)
- AnyDbTest is the first automated DB unit testing tool available using Xml as test case. AnyDbTest is just designed for DBA/DB developers. It supports all kinds of popular database, such as Oracle, SQL Server, and MySQL. AnyDbTest can also be used to validate the replication, ETL, DTS & SSIS result....
- Software downloads 2009-09-28
- NetSuite + AdaptivePlanning = BPM disruption
- This slipped under the radar but on June 10th NetSuite and AdaptivePlanning announced a marketing and integration partnership that will see NetSuite acting as a reseller for AdaptivePlanning's business performance management BPM solution. Why should this matter? So far, the saas/on-demand transaction app...
- Blog posts 2009-07-01
- HP unveils financial planning and analysis solutions designed to both optimize and modernize IT operations
- LAS VEGAS -- Hewlett-Packard HP today unveiled its new HP Financial Planning and Analysis (FP&A) solutions, aimed at recession-beleaguered IT executives who need to cut costs, prepare for a service-based future, and run their departments like a business -- all at the same time. FP&A is part...
- Blog posts 2009-06-16
- Five reasons why people mistrust SOA
- Five reasons why people mistrust SOAPoint 5 is......spot on."...the end-goal of any efforts should not be to simply ?build an SOA.?"Keep the primary focus on the business objectives. The style with which they are approached is important too but it is not *the* important thing.The 1st reason should be......the buzzwordification...
- Discussion threads 2009-06-02
- Business Intelligence - HP DL785 G5 server reference configurations for Microsoft SQL Server 2008
- Trying to determine the correct hardware configuration to support a Business Intelligence BI workload may be challenging. Therefore, HP has made available several documents to simplify the hardware selection process by documenting various configurations to support pre-defined workloads, which access various sized databases and/or OLAP cubes. This paper provides with...
- White papers 2009-06-01
- Cooling future cost inflation
- Cooling future cost inflationMakes senseAlthough you COULD should take those 80+ watt desktops and grid them together in a distributed fashion - thus adding little-used CPU power into a big pool. This allows for ALL computers great and small to be loaded and configured EXACTLY THE SAME. This of course...
- Discussion threads 2009-05-23
- Visual Display of Large Data Volumes
- Many organizations have huge amounts of data, containing hundreds of millions of records. There are good solutions available for the purpose of collecting, organizing and consolidating data, but people still struggle with presenting the data in a useful way. When trying to make use of the data, details are often...
- White papers 2009-03-22
- Upgrading older systems
- Upgrading older systemseBay "support"At FORD, we had many legacy machines in differing states of "decay". One was a NVH (Noice/Vehicle Harmonics) platform - which consisted of a specialty input card (ISA bus?) that connected hundreds of different sensors on a vehicle to check noise levels. A new card was pretty...
- Discussion threads 2009-03-02
- Useful by Association: Adding Practical Value by Analyzing SAS 9 Data Integration Metadata
- SAS 9 has an incredibly rich metadata model, but the documentation can be very daunting! This paper will explain the practical use of Associations and Attributes in the metadata to extract, analyze, and report this valuable resource using SAS DATA step programming. Starting from simple techniques such as listing all...
- White papers 2009-02-27
- Oracle Warehouse Builder Tips and Tricks: Advanced Data Transformations
- Oracle Warehouse Builder 11g, the tenth major release of OWB, delivers a rich ETL, data warehousing and data quality feature set that enhances productivity and contributes to project success while lowering total cost of ownership compared to non-Oracle products. This whitepaper looks at advanced data transformation capabilities of Oracle Warehouse...
- White papers 2009-02-01
- Integrated Marketing and Decision Support Solution Using Business Intelligence and ETL
- A $300-million online real estate management, information, media and technology services provider needed single, integrated solution to make analysis of market data easy. It deployed business intelligence tool for reporting with a backend ETL (Extract, Transform and Load). The datawarehouse will help capture business-critical data like new business, growth of...
- Case studies 2009-01-01
- End-to-End Open Source Business Intelligence, ETL, and Data Warehouse for MySQL
- The presenter of this webcast will discusses the advances in BI/DW technologies, demonstrates the integration of Jaspersoft BI Suite and Infobright's analytic database and gives real-world examples of end-to-end open source BI solutions.
- Webcasts 2009-01-01
- Offshore Application Development Helps Customer Intelligence Provider Get State-of-the-Art Product
- In Q1 2008, VueLogic began development of a business analytics tool for the purpose of entering new markets with a competitive software product. VueLogic's vision for this new product was to design a SAAS application with three layers. VueLogic's internal cost-analysis found that developing the application via in internally managed...
- Case studies 2008-12-16
- Any chance our student data could be consistent?
- Any chance our student data could be consistent?Analyzing Data fromTestsChris,Download the openIntel data model from os4ed.com and out your data in there for analysis using any of the free reporting tools available. (BIRT, Pentaho, Jasper, etc.) The data model was designed by Maurice Frank, the creator of the...
- Discussion threads 2008-10-16
- MobilKom Reduces Data Extract, Transform, and Load Process Time and Reporting Time by 90%
- MobilKom wanted to establish a single data store for performance management information such as network reports and reduce the amount of manual work as a result of using Microsoft Excel for reporting. The challenge was to accelerate data Extract, Transform, and Load ETL processes by eliminating manual tasks and establish...
- Case studies 2008-10-01
- Thanks, but no thanks, SAS
- Thanks, but no thanks, SASSome good R linkshttp://www.johnmwillis.com/r/are-you-using-r/openIntelTry openIntel, a free data model offered by OSEd ( http://osed.com ). IT is free and it includes documentation explaining it, the tables and the relations. It was designed by Maurice Frank, the original creator of the IBM Insight at...
- Discussion threads 2008-09-30
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- Learn more about tools to grow your business
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Save time with the UPS Business Essentials Guide
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
Enterprise Applications
- Check out some of the easiest and most powerful ways to boost productivity while saving money on your application infrastructure. See ZDNet's comprehensive Enterprise Application resource center, now!
- New Online Dashboard
-
- Read about top issues IT decision-makers face every day, plus get cost effective solutions to real life IT problems. Oracle Topline
-
