Data Model
The adapter 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 adapter.
Creating Template Views
• Navigate to the query console, http://Server:8000/qconsole, where Server is the DSN of the Server MarkLogic is hosted.
• Create a new query tab.
• Set the Query Type to XQuery.
• 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. Using Collaborative Query Processing
The adapter offloads as much of the SELECT statement processing as possible to the MarkLogic APIs and then processes the rest of the query within the adapter. The following sections document API limitations and requirements.