MarkLogic Data Integration

On-demand Training


Course Description

Use your development skills to integrate data from silos to create an operational data hub!

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




9 Hours


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

How to Subscribe

On-Demand Option

Learn on your own time! Take the class as time permits through our self-paced portal.

Go to course
Services prefooter banner

Interested in the Class?

Stay up to date with technology trends and get the most out of your Progress technology investment.