X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 etl enterprise data warehousing

Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Discrete Manufacturing (ERP)

The simplified definition of enterprise resource planning (ERP) software is a set of applications that automate finance and human resources departments and help manufacturers handle jobs such as order processing and production scheduling. ERP began as a term used to describe a sophisticated and integrated software system used for manufacturing. In its simplest sense, ERP systems create interactive environments designed to help companies manage and analyze the business processes associated with manufacturing goods, such as inventory control, order taking, accounting, and much more. Although this basic definition still holds true for ERP systems, today its definition is expanding. Today’s leading ERP systems group all traditional company management functions (finance, sales, manufacturing, and human resources). Many systems include, with varying degrees of acceptance and skill, solutions that were formerly considered peripheral such as product data management (PDM), warehouse management, manufacturing execution system (MES), and reporting. During the last few years the functional perimeter of ERP systems began an expansion into its adjacent markets, such as supply chain management (SCM), customer relationship management (CRM), business intelligence/data warehousing, and e-business, the focus of this knowledge base is mainly on the traditional ERP realms of finance, materials planning, and human resources. The foundation of any ERP implementation must be a proper exercise of aligning customers'' IT technology with their business strategies, and subsequent software selection. 

Evaluate Now

Documents related to » etl enterprise data warehousing

A Definition of Data Warehousing


There is a great deal of confusion over the meaning of data warehousing. Simply defined, a data warehouse is a place for data, whereas data warehousing describes the process of defining, populating, and using a data warehouse. Creating, populating, and querying a data warehouse typically carries an extremely high price tag, but the return on investment can be substantial. Over 95% of the Fortune 1000 have a data warehouse initiative underway in some form.

etl enterprise data warehousing  software products known as ETL (Extract/Transform/Load) tools. There are currently over 50 ETL tools on the market. The data acquisition phase can cost millions of dollars and take months or even years to complete. Data acquisition is then an ongoing, scheduled process, which is executed to keep the warehouse current to a pre-determined period in time, (i.e. the warehouse is refreshed monthly). Changed Data Capture: The periodic update of the warehouse from the transactional system(s) is complicated by Read More

Informatica PowerCenter 5 Enables Enterprise Data Integration


Informatica Corporation’s Informatica PowerCenter 5 is a platform for integrating data to be deployed in e-Business applications, analytic applications and data warehouses, including a wide range of data sources, from enterprise resource planning (ERP) systems such as SAP R/3 and PeopleSoft, to web logs and Siebel applications. Market validation of its offerings is shown in a record Q4 of 2000, with a 150% increase in revenue over the previous year.

etl enterprise data warehousing  PowerCenter 5 Enables Enterprise Data Integration Informatica PowerCenter 5 Enables Enterprise Data Integration M. Reed - April 5, 2001 Event Summary Informatica Corporation (NASDAQ: INFA), a provider of e-Business analytic software, has announced the availability of Informatica PowerCenter 5 , an enterprise data integration platform for the deployment and management of analytic applications and data warehouses. The vendor states that the Informatica PowerCenter 5 suite is designed to be a Read More

Access to Critical Business Intelligence: Challenging Data Warehouses?


There is a perception that if business users are given access to enterprise databases and raw query tools, they will create havoc in the system, which is a possibility—unless the business intelligence (BI) product developer understands the potential problem and addresses it as a business-critical factor.

etl enterprise data warehousing  fragile as the procedural ETL scripts and can accommodate the necessary changes much more quickly. Need for Clean Information Another historical driver for the DW model has been the perceived need to clean information prior to making it available for reporting, and many companies are still investing large amounts of time, human resources (HR), and money in cleaning their data and applying consistent terminology to it as a necessary step in building their DW. As was mentioned earlier on, some vendors Read More

Distilling Data: The Importance of Data Quality in Business Intelligence


As an enterprise’s data grows in volume and complexity, a comprehensive data quality strategy is imperative to providing a reliable business intelligence environment. This article looks at issues in data quality and how they can be addressed.

etl enterprise data warehousing  tools or as part ETL/data integration packages. DataFlux (a SAS company) offers dfPowerStudio , an integrated platform for data quality and data integration. One of the components of dfPowerStudio is dfPower® Profile, an extensive data profiling module. It includes metadata analysis that helps organize data across multiple organizational sources. A relationship discovery component helps uncover relationships across data sources and granularity. In addition to verifying metadata-defined relationships, Read More

Computer Associates Splashes Into the Data Warehousing Market with Platinum Technology Acquisition


Computer Associates DecisionBase is an Extract/Transform/Load tool designed to help in the population and maintenance of data warehouses. First released in March of 1998, the product is geared towards large implementations with the need for metadata management. The current release is 1.9, which is the fourth release of the product.

etl enterprise data warehousing  of vendors in the ETL market in the mid-1990''s was small, comprised of basically four companies (Prism, Carleton, Evolutionary Technologies, Trinzic) plus some modest offerings from IBM. In the past four years, the space has become very crowded, with over fifty vendors competing in various market niches (e.g. specializing in access to VSAM databases). Four vendors still primarily control the general market, including Ardent, Computer Associates, Informatica, and Sagent, with some offerings from IBM and Read More

Data Mining with MicroStrategy: Using the BI Platform to Distribute Data Mining and Predictive Analytics to the Masses


Data mining and predictive analysis applications can help you make knowledge-driven decisions and improve efficiency. But the user adoption of these tools has been slow due to their lack of business intelligence (BI) functionality, proactive information distribution, robust security, and other necessities. Now there’s an integrated enterprise BI system that can deliver data mining and predictive analysis. Learn more.

etl enterprise data warehousing  Mining with MicroStrategy: Using the BI Platform to Distribute Data Mining and Predictive Analytics to the Masses Data mining and predictive analysis applications can help you make knowledge-driven decisions and improve efficiency. But the user adoption of these tools has been slow due to their lack of business intelligence (BI) functionality, proactive information distribution, robust security, and other necessities. Now there’s an integrated enterprise BI system that can deliver data mining and pre Read More

Infor EAM Enterprise


Infor EAM is a configurable enterprise asset management (EAM) solution. It allows companies to improve capital asset management in ways that increase reliability, enhance predictive maintenance, ensure regulatory compliance, reduce energy usage, and support sustainability initiatives. Available in industry-specific editions, it also gives organizations the flexibility to zero in on specialized industry requirements.

etl enterprise data warehousing  EAM Enterprise Infor EAM is a configurable enterprise asset management (EAM) solution. It allows companies to improve capital asset management in ways that increase reliability, enhance predictive maintenance, ensure regulatory compliance, reduce energy usage, and support sustainability initiatives. Available in industry-specific editions, it also gives organizations the flexibility to zero in on specialized industry requirements. Read More

Epicor Enterprise Resource Planning Software System v. 9.05 for ERP for Mixed-mode Manufacturing Certification Report


The Epicor product Epicor Enterprise Resource Planning Software System (v. 9.05) is now TEC Certified for online evaluation of enterprise resource planning (ERP) solutions for mixed-mode manufacturing in the ERP Evaluation Center. Download this report for product highlights, competitive analysis, product analysis, and in-depth analyst commentary.

etl enterprise data warehousing  Enterprise Resource Planning Software System v. 9.05 for ERP for Mixed-mode Manufacturing Certification Report The Epicor product Epicor Enterprise Resource Planning Software System (v. 9.05) is now TEC Certified for online evaluation of enterprise resource planning (ERP) solutions for mixed-mode manufacturing in the ERP Evaluation Center. Download this report for product highlights, competitive analysis, product analysis, and in-depth analyst commentary. Read More

Data Quality: Cost or Profit?


Data quality has direct consequences on a company's bottom-line and its customer relationship management (CRM) strategy. Looking beyond general approaches and company policies that set expectations and establish data management procedures, we will explore applications and tools that help reduce the negative impact of poor data quality. Some CRM application providers like Interface Software have definitely taken data quality seriously and are contributing to solving some data quality issues.

etl enterprise data warehousing  Quality: Cost or Profit? Market Overview In the past year, TEC has published a number of articles about data quality. ( Poor Data Quality Means A Waste of Money ; The Hidden Role of Data Quality in E-Commerce Success ; and, Continuous Data Quality Management: The Cornerstone of Zero-Latency Business Analytics .) This time our focus takes us to the specific domain of data quality within the customer relationship management (CRM) arena and how applications such as Interaction from Interface Software can Read More

Data Masking: Strengthening Data Privacy and Security


Many business activities require access to real production data, but there are just as many that don’t. Data masking secures enterprise data by eliminating sensitive information, while maintaining data realism and integrity. Many Fortune 500 companies have already integrated data masking technology into their payment card industry (PCI) data security standard (DSS) and other compliance programs—and so can you.

etl enterprise data warehousing  Masking: Strengthening Data Privacy and Security Many business activities require access to real production data, but there are just as many that don’t. Data masking secures enterprise data by eliminating sensitive information, while maintaining data realism and integrity. Many Fortune 500 companies have already integrated data masking technology into their payment card industry (PCI) data security standard (DSS) and other compliance programs—and so can you. Read More

SAP, Sybase, and the Future of Enterprise Mobility


SAP's acquisition of Sybase foreshadows a revolutionary change in the enterprise mobility space. John Chen, CEO of Sybase, discusses what the company has to offer as a new member of the SAP family, including exciting technology developments that position Sybase and SAP to lead this mobile revolution.

etl enterprise data warehousing  Sybase, and the Future of Enterprise Mobility SAP''s acquisition of Sybase foreshadows a revolutionary change in the enterprise mobility space. John Chen, CEO of Sybase, discusses what the company has to offer as a new member of the SAP family, including exciting technology developments that position Sybase and SAP to lead this mobile revolution. Read More

Re-think Data Integration: Delivering Agile BI Systems with Data Virtualization


Today’s business intelligence (BI) systems have to change, because they’re confronted with new technological developments and new business requirements, such as productivity improvement and systems as well as data in the cloud. This white paper describes a lean form of on-demand data integration technology called data virtualization, and shows you how deploying data virtualization results in BI systems with simpler and more agile architectures that can confront the new challenges much easier.

etl enterprise data warehousing  BI, business intelligence, operational intelligence, Hadoop, NoSQL, self-service BI, data virtualization, big data, on-demand data integration, lean data integration, JBoss Data Virtualization Read More

Cincom Enterprise Management


Cincom Enterprise Management is a portfolio of Web-enabled business applications that address the business cycle of companies who build and service complex products. It encompasses activities included in business planning, business acquisition, order management, engineering, procurement, manufacturing and re-manufacturing operations, cost management, finance, and aftermarket support. CONTROL also supports global enterprises by offering distributed multi-site implementation options, multiple currencies, and multiple languages.  

etl enterprise data warehousing  Enterprise Management Cincom Enterprise Management is a portfolio of Web-enabled business applications that address the business cycle of companies who build and service complex products. It encompasses activities included in business planning, business acquisition, order management, engineering, procurement, manufacturing and re-manufacturing operations, cost management, finance, and aftermarket support. CONTROL also supports global enterprises by offering distributed multi-site implementation Read More

eBay Enterprise


By engaging eBay Enterprise as a co-sourcing partner for the products and services you need, you get the most out of your online channel. With eBay Enterprise bringing you greater speed and operating capabilities, your commerce team has the freedom to focus their management energies on developing essential strategies for growing your online business and providing a unique, brand-centric experience for your customers.

etl enterprise data warehousing  Enterprise By engaging eBay Enterprise as a co-sourcing partner for the products and services you need, you get the most out of your online channel. With eBay Enterprise bringing you greater speed and operating capabilities, your commerce team has the freedom to focus their management energies on developing essential strategies for growing your online business and providing a unique, brand-centric experience for your customers. Read More

Linked Enterprise Data: Data at the heart of the company


The data silos of today's business information systems (IS) applications, and the pressure from the current economic climate, globalization, and the Internet make it critical for companies to learn how to manage and extract value from their data. Linked enterprise data (LED) combines the benefits of business intelligence (BI), master data management (MDM), service-oriented architecture (SOA), and search engines to create links among existing data, break down data walls, provide an open, secure, and long-term technological environment, and reduce complexity—read this white paper to find out how.

etl enterprise data warehousing  Enterprise Data: Data at the heart of the company The data silos of today''s business information systems (IS) applications, and the pressure from the current economic climate, globalization, and the Internet make it critical for companies to learn how to manage and extract value from their data. Linked enterprise data (LED) combines the benefits of business intelligence (BI), master data management (MDM), service-oriented architecture (SOA), and search engines to create links among existing data, Read More