MarkLogic Data Integration

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