Part 11: Data Integration Tools | Data Integration & Interoperability

DESCRIPTION You know the methods. Now, which tools carry them out? In this video (DAMA-CDMP series, Part 11) we cover the Tools section of the DMBOK2 chapter on Data Integration and Interoperability, seven tools in total: the data transformation engine (ETL tool), the data virtualization server, the enterprise service bus (ESB), the business rules engine, data and process modeling tools, the data profiling tool, and the metadata repository. For each tool we explain the problem it solves, the key terms, how it works step by step, real products, a full worked example, and how it differs from the previous tool. We also cover the classic exam traps, such as data profiling versus data mining and what a metadata repository is not. We link everything back to Parts 1 to 10. The video ends with 6 practice questions. CHAPTERS 0:00 Introduction 0:22 The big picture 0:40 The toolbox 1:16 The running example 1:49 ETL tool: the problem 2:14 ETL tool: key terms 2:53 ETL tool: how it works 3:16 ETL tool: when to use a tool 3:38 ETL tool: how to choose 4:01 ETL tool: in real systems 4:28 ETL tool: a full example 4:50 Virtualization: the problem 5:10 Virtualization: key terms 5:40 Virtualization: how it works 6:00 Virtualization: the warehouse stays 6:16 Virtualization: in real systems 6:36 Virtualization: a full example 6:53 ETL tool versus Virtualization 7:27 ESB: the problem 7:46 ESB: key terms 8:31 ESB: how it works 8:52 ESB: near real-time 9:08 ESB: SOA and use cases 9:28 ESB: in real systems 9:45 ESB: a full example 10:03 Virtualization versus ESB 10:19 Rules engine: the problem 10:33 Rules engine: key terms 11:04 Rules engine: how it works 11:25 Rules engine: why it saves cost 11:42 Rules engine: in real systems 12:00 Rules engine: a full example 12:20 ESB versus Rules engine 12:40 Modeling tools: the problem 12:56 Modeling tools: key terms 13:31 Modeling tools: what to model 13:51 Modeling tools: in real systems 14:09 Modeling tools: a full example 14:26 Rules engine versus Modeling tools 14:45 Profiling tool: the problem 15:07 Profiling tool: key terms 15:45 Profiling tool: how it works 16:05 Profiling tool: the goal of discovery 16:24 Profiling versus data mining 16:48 Profiling tool: in real systems 17:11 Profiling tool: a full example 17:33 Modeling tools versus Profiling tool 17:52 Repository: the problem 18:15 Repository: key terms 18:47 Repository: what it holds 19:12 Repository: how many 19:27 Repository: not a glossary 19:54 Repository: when to consult it 20:10 Repository: in real systems 20:28 Repository: a full example 20:56 Profiling tool versus Metadata repository 21:20 From methods to tools 21:51 Tools and Parts 1 to 10 22:35 Putting it all together 22:58 How to recognize the answer 24:12 Summary 24:58 Practice questions 25:03 Question 1 25:30 Question 2 26:13 Question 3 27:02 Question 4 27:51 Question 5 28:31 Question 6 TAGS DAMA-CDMP, CDMP, DMBOK2, data management, data integration, data interoperability, ETL tool, data virtualization, enterprise service bus, ESB, business rules engine, data modeling tools, data profiling, data mining, metadata repository, SOA, data governance, CDMP exam, CDMP practice questions, شرح DAMA, CDMP بالعربي