MarkLogic Data Integration
Course Details
Use your development skills to integrate data from silos to create an operational data hub!
- Duration: 2 Days
- Format: Instructor-led course with hands-on labs
- Availability: Self-paced, public classes, private onsite
- Audience: Developers
- Prerequisites:
Course Objectives
Attendees completing this course will be able to
- Use MarkLogic for data integration
- Create a 360° view database
- Load disparate data from data silos
- Translate between XML and JSON
- Transform data while loading it
- Use the envelope pattern to harmonize data
- Harmonize data from varied sources
- Execute a CoRB process
- Execute a Data Movement SDK process
- Use triples to harmonize data
- Use templates to harmonize data
- Use templates to extract data
- Generate a template view
- Run SQL queries against a template view
- Write Optic API queries
- Use Entity Services
Course Outline
Using MarkLogic for Data Integration
- Explain what an operational data hub is
- Describe MarkLogic as a multi-model database
- Define a 360° view database
Loading and Indexing Data
- Know how data is stored and indexed
- Load data from XML and JSON files
- Split a multiple-record XML file
- Translate XML and JSON
- Load data from a .csv file
- Modify data while loading it
Harmonizing Data
- Explain data harmonization
- Describe the envelope pattern
- Create an envelope
- Add data to an envelope
- Query an envelope
- Run CoRB for batch processing
- Use the Data Movement SDK for batch processing
- Describe spell:double-metaphone()
Using Triples for Harmonization
- Describe how triples can be used
- Load triples
- Query triples
- Use triples to harmonize data
Using Templates for Data Extraction
- Explain Template-Driven Data Extraction
- Create a template and validate it
- Apply a template
- Define variables
- Generate a view
- Disable and delete a template
- Use TDE for data integration
Making SQL Queries
- Learn about SQL in MarkLogic
- Create a SQL query
- Do a join
- Configure a MarkLogic ODBC driver
- Execute SQL queries through a MarkLogic ODBC driver
- Write a SQL and document search query
Making Optic API Queries
- Describe the Optic API
- Write an Optic API query
- Perform a join
- Do an aggregate
- Create a master-detail result
- Use document query
- Query triples
- Join rows and triples
Modeling through Entity Services
- Explain Entity Services
- Create a model
- Define an entity
- Define a relationship
- Store a model
- Generate model-driven components
- Create instances
- Use instances
Learning Made Simple
Free Training Courses Will Make You a MarkLogician in No Time
Self-Paced Training
Do you need a more flexible learning schedule? Learn on your own time! Take classes as time permits through our self-paced portal.
On-Demand Tutorials
Watch the latest video tutorials with hands-on examples covering a wide variety of product features.
Learning Assessments
Learning Assessments provide a way for you to demonstrate understanding of the learning objectives defined for a specific training course.