EncartaLabs

MarkLogic Data Integration

( Duration: 2 Days )

This MarkLogic Data Integration training course provides skills to integrate data from silos to create an operational data hub!

By attending MarkLogic Data Integration workshop, delegates will learn 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

The MarkLogic Data Integration class is ideal for:

  • Developers

COURSE AGENDA

1

Using MarkLogic for Data Integration

  • Explain what an operational data hub is
  • Describe MarkLogic as a multi-model database
  • Define a 360° view database
2

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
3

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()
4

Using Triples for Harmonization

  • Describe how triples can be used
  • Load triples
  • Query triples
  • Use triples to harmonize data
5

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
6

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
7

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
8

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top