Mark Logic is a NoSQL database that allows third party tools to connect using REST Api. This blog aims at providing explanation on connecting to MarkLogic database using Pentaho Data Integration. In case you want to know about creating a REST API in Mark Logic, then read this blog.
Setting up Authentication
In this blog, i have considered basic / digestbasic authentication of Mark Logic REST Api. So you need to login to marklogic admin console (available in port 8001 by default). In the App Services section you will identify the HTTP services. Change the authentication to basic or digestbasic from digest as the image below:
More on authentication in official Mark Logic documentation.
REST Client Step in Pentaho DI
Once you are done with Step #1, next is to create a pentaho transformation and include the REST Client Step. The REST client step in PDI will read trigger a request to Mark Logic database based on the query in question. A sample transformation is as below:
Subscribe to continue reading
Subscribe to get access to the rest of this post and other subscriber-only content.
Tech Spaghetti 
2 responses to “Connect to Mark Logic database using Pentaho DI”