Excel Add-In for MarkLogic

Build 24.0.9060

Data Model

The add-in models template views created in the MarkLogic server as views. These definitions are dynamically retrieved. Any changes you make, such as adding a new table, or adding new columns, or changing the data type of a column, will immediately be reflected when you connect using the add-in.

Creating Template Views

  1. Navigate to the query console, http://Server:8000/qconsole, where Server is the DSN of the Server MarkLogic is hosted.
  2. Create a new query tab.
  3. Set the Query Type to XQuery.
  4. From there, follow the guide to create a template view from the official MarkLogic website here: https://docs.marklogic.com/guide/sql/creating-template-views.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060