Introduction to the Course and Using MarkLogic for Data Integration
- Introducing the Course
- Understanding the Course System Requirements
- Download the Course Virtual Machine
- Using Virtual Box
- Getting Set Up
- Understanding an Operational Data Hub
- Learning About MarkLogic as a Multi-Model Database
- Pop Quiz
- Lab: Create a 360° View Database
Loading and Indexing Data
- Storing and Indexing Data
- Loading Documents
- Splitting a Multiple-Record XML Document
- Transforming Between JSON and XML
- Loading Records From a .csv File
- Transforming Data While Loading Part 1
- Transforming Data While Loading Part 2
- Pop Quiz
- Lab: Load Data
Harmonizing Data
- Understanding Data Harmonization Part 1
- Understanding Data Harmonization Part 2
- Using an Envelope Pattern to Harmonize Data
- Adding Data to an Envelope Part 1
- Adding Data to an Envelope Part 2
- Querying an Envelope
- Using CoRB for Batch Processing Part 1
- Using CoRB for Batch Processing Part 2
- Using the Data Movement SDK for Batch Processing Part 1
- Using the Data Movement SDK for Batch Processing Part 2
- Using the Data Movement SDK for Batch Processing Part 3
- Using the Data Movement SDK for Batch Processing Part 4
- Using the Data Movement SDK for Batch Processing Part 5
- Resolving Entities
- Pop Quiz
- Lab: Add Canonical Data
Using Triples for Harmonization
- Using Triples to Harmonize Data
- Storing and Indexing Triples Part 1
- Storing and Indexing Triples Part 2
- Querying Triples Part 1
- Querying Triples Part 2
- Querying Triples Part 3
- Pop Quiz
Using Templates for Data Extraction
- Understanding Template Driven Extraction
- Creating a Template for Rows
- Applying a Template Part 1
- Applying a Template Part 2
- Applying a Template Part 3
- Defining Variables
- Generating a View Part 1
- Generating a View Part 2
- Disabling and Deleting a Template
- Using TDE for Data Integration Part 1
- Using TDE for Data Integration Part 2
- Pop Quiz
- Lab: Create a Template
Making SQL Queries
- Understanding SQL in MarkLogic
- Running a SQL Query
- Doing a Join
- Creating an ODBC App Server
- Installing the ODBC Driver Part 1
- Installing the ODBC Driver Part 2
- Using mlsql
- Executing SQL from JavaScript or XQuery
- Pop Quiz
Making Optic API Queries
- Understanding the Optic API
- Writing an Optic API Query Part 1
- Writing an Optic API Query Part 2
- Writing an Optic API Query Part 3
- Using Document Criteria
- Creating a Document Join Part 1
- Creating a Document Join Part 2
- Including Triples Part 1
- Including Triples Part 2
- Including Triples Part 3
- Using the Optic API in an Application Part 1
- Using the Optic API in an Application Part 2
- Writing an Optic API Query in XQuery
- Using the Optic API with the REST API
- Pop Quiz
Modeling and Harmonizing through Entity Services
- Understanding Entity Services
- Writing a Model Descriptor
- Defining an Entity Type
- Storing a Model
- Generating Model-Driven Components
- Creating Entity Instances Part 1
- Creating Entity Instances Part 2
- Using Instances
- Pop Quiz
Learning About the Data Hub Framework
- Understanding the Data Hub Framework
- Course Wrap Up
