Data integration
Most organizations draw data from multiple sources, including external ones. Data integration combines this data to create unified sets of information for tracking business performance and managing operations. Learn about data integration strategies to ensure information from multiple sources is consistent to meet users' data analysis needs across the organization.
Top Stories
-
News
15 May 2025
Qlik evolves to keep up with latest AI, analytics trends
The longtime BI vendor continues to expand beyond its historical base to keep current with what's happening in GenAI and agentic development, analytics, and data management. Continue Reading
-
News
14 May 2025
Alteryx One launch aims to unify, simplify vendor's platform
The updated version of the data integration vendor's platform aims to make it easier to prepare data for AI and analytics, while new GenAI tools further simplify data preparation. Continue Reading
-
Feature
09 Apr 2018
Information architecture applied to big data streaming, AI
New technologies challenge data professionals, but taking a step back helps with hurdles. In this interview, consultant William McKnight takes a measured look at data streaming, GDPR and AI. Continue Reading
-
Feature
06 Apr 2018
Cloud workloads, data lakes challenge information architecture
Data management options are expanding; cloud workloads are an example. That means changing your approach to information architecture, says data management expert William McKnight. Continue Reading
-
Podcast
22 Feb 2018
Google TPUs open up on cloud; LinkedIn intros Hadoop Dynamometer
In big data news, we find Google TPUs, or Tensor Processing Units, offered as a cloud service, while LinkedIn is open sourcing a Hadoop test simulator called Dynamometer. Continue Reading
-
Tip
13 Feb 2018
Data analytics architecture must break down higher ed silos
Siloed data isn't only a problem for businesses. It's also a big issue for many large universities -- one that their data infrastructures need to resolve for effective analytics. Continue Reading
-
Answer
21 Dec 2016
What are key features for choosing the best ETL tools for your needs?
Choosing the right ETL tool for your data integration requirements can be a challenge. Here's a rundown on what to look for in ETL software and potential vendors to consider. Continue Reading
-
Feature
29 Jun 2016
Inside the SAP Data Services data integration tool
SAP Data Services can be used alone or with other SAP products to provide data integration, transformation, data quality, data profiling and text data processing. Continue Reading
-
Feature
29 Jun 2016
An overview of the Pentaho Data Integration platform
The Pentaho Data Integration platform enables organizations to integrate, blend, convert and transform data from any data source across their entire enterprise. Continue Reading
-
Feature
03 Jun 2016
What you need to know about Oracle Data Integrator 12c
Oracle Data Integrator 12c works with several other Oracle products to leverage the capabilities of RDBMSs for processing and transforming data. Continue Reading
-
Tip
18 May 2015
Relational database design tips to boost performance
As relational database management systems handle more and more data, a strategic approach to data modeling has become vital. Continue Reading
-
01 May 2015
Key considerations for determining if a NoSQL DBMS meets your IT needs
A broad range of nouveau database systems can be helpful for organizations that need to crunch large volumes of unstructured, fast-moving data -- but there’s a lot to look out for. Continue Reading
-
News
21 Apr 2011
Disney discovers a whole new world of data warehouse best practices
The director of data warehousing and analytics at Walt Disney Parks and Resorts shares some important BI and data warehouse best practices. Continue Reading
-
Tutorial
06 Apr 2011
Structuring data integration models and data integration architecture
Get tips on structuring data integration models and data integration architecture. Learn how to build a business case for data integration modeling and leverage process modeling. Continue Reading
-
Tutorial
06 Apr 2011
Using logical data models for data integration modeling
Learn about using logical data models for data integration modeling. Get an overview of using a target-based data integration design technique. Continue Reading
-
News
23 Mar 2011
Capacity planning for the data warehouse environment
Capacity planning is essential for all data warehouse environments. Data warehouses grow at high rates and must be managed to keep budgets under control. Continue Reading
-
Answer
02 Aug 2010
What is the difference between data definition language (DDL) and SQL?
Learn the difference between a data definition language (DDL), also known as data descriptive language, and the Structured Query Language (SQL). Find examples of both DDL and SQL. Continue Reading
-
Answer
01 Jun 2010
Steps for converting a logical data model into a physical data model
Learn how to convert a logical data model into a physical data model via data modeling best practices. Find out how DDL and your data modeling practices play a role in conversions. Continue Reading
-
Feature
26 Oct 2009
Advantages and disadvantages of XML shredding
Learn about the advantages and disadvantages of XML shredding and different shredding methods, plus find out when shredding is and isn't a good option for your company. Continue Reading
-
Feature
27 Jul 2009
An introduction to database transaction management
Find out the performance advantages of using one connection for multiple statements in this database tutorial. Get a definition of local vs. distributed transactions and learn how to manage database transactions. Continue Reading
-
Feature
11 Jun 2009
Similarities and differences between ROLAP, MOLAP and HOLAP
Find out the differences between ROLP, MOLAP and HOLAP and their advantages and disadvantages. Learn about data quality and the evolution of data warehouse applications. Continue Reading
-
Feature
20 May 2009
Data modeling for the business: What is a data model?
Learn about high-level data modeling, what a data model is and how business and IT can use logical data modeling to plan a data design with these best practices from a data modeling handbook and guide. Continue Reading
-
Answer
14 Oct 2008
What are the components of service-oriented architecture (SOA)?
What are the components that make up service-oriented SOA? Find out in this expert response. Continue Reading
-
Answer
21 May 2008
Enterprise versus project level conceptual data modeling
Learn the differences between enterprise level and project level conceptual data modeling, and find out how both approaches are compatible. Continue Reading
-
Answer
22 Apr 2008
Data model conversion: Conceptual design to logical design using an ER model
Learn two common approaches to converting a data model from a conceptual design to a logical design. Continue Reading
-
Answer
28 Nov 2007
The ETL process and MySQL
Get advice on the ETL process and ETL tools for transforming raw data in MySQL. Continue Reading
-
Answer
23 Oct 2007
What are the benefits of a conceptual data model?
Learn the functions and potential benefits of a conceptual data model, from data modeling expert Pete Stiglich. Continue Reading
-
Feature
21 Jun 2007
Continuous integration: The value of CI
Learn about the value of continuous integration and get reasons why continuous integration can benefit the enterprise in this free sample chapter download. Continue Reading