MarkLogic Data Integration

Outcomes

Attendees completing this course will be able to:

  1. Use MarkLogic for data integration
  2. Create a 360° view database
  3. Load disparate data from data silos
  4. Translate between XML and JSON
  5. Transform data while loading it
  6. Use the envelope pattern to harmonize data
  7. Harmonize data from varied sources
  8. Execute a CoRB process
  9. Execute a Data Movement SDK process
  10. Use triples to harmonize data
  11. Use templates to harmonize data
  12. Use templates to extract data
  13. Generate a template view
  14. Run SQL queries against a template view
  15. Write Optic API queries
  16. Use Entity Services

Course Units

  • Explain what an operational data hub is
  • Describe MarkLogic as a multi-model database
  • Define a 360° view database
  • 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
  • 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()
  • Describe how triples can be used
  • Load triples
  • Query triples
  • Use triples to harmonize data
  • 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
  • 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
  • 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
  • Explain Entity Services
  • Create a model
  • Define an entity
  • Define a relationship
  • Store a model
  • Generate model-driven components
  • Create instances
  • Use instances