Mark logic database connection in Jasper server v6.x

[JasperTechie]

Hi,

Mark logic database doesn't have JDBC driver to Create JDBC or JNDI connection in jasper server.

So, did anyone tried connecting Marklogic database in Jasperserver?

Please suggest.

Thanks in advance.!

 

[hozawa]

Have you tried using Talend ETL 6.1.x to transfer data from  MarkLogic to a data that JasperReports Server can handle?

https://help.talend.com/display/TalendComponentsReferenceGuide61EN/tMarkLogicConnection?

 

[JasperTechie]

Hi Hozawa,

Appreciate your quick response!

I need to directly fetch data from Mark logic data base and create Jasper Reports.

So, it would be more helpful if you can share your inputs on creating a connection to Mark logic database in Jasper server.

 

Thanks for your time.

[adimulam.natarajan]

I connect to marklogic following steps

1) Create Data Adapter, select Web Service from the dropdown list

2) Data Adapter Configuration:

Server URL: http://localhost:8010 (This is my HTTP srver I created IN MarkLogin Admin, make sure you select authentication as application-level)

Connection Type: get

Langauge: xml

Authentication: basic

3) Data set Query Editor Dialogue:

Language: WebServiceQuery

Base Url: /news.xqy  (news.xqy is a my own query)

Content Type: JSON

Click on fields tab and click on "Get Server Response"

and you will see the results populated.