How to Connect to KDB database in Jaspersoft

Posted on by By Mounika, in Jaspersoft | 0

To Connect to KDB database in Jaspersoft follow the below steps:

  1. Open Jasper studio and create a data adapter.
  2. KDB requires a separate jar file called ‘jdbc.jar’.Below is the jar file.

    3. JDBC.jar file

  3. Include this jar file in Driver Classpath.

    4. Driver classpath

  4. Add the details in data adapter as shown.

    5. Add details

    JDBC Driver – jdbc

    JDBC Url – jdbc:q:servername:port

  5. Create a new report.
  6. In dataset, select language as ‘sql’.
  7. Write the required query and preview.

Ex : 

q) 
Select from table1

Note: Query in the dataset should be prefixed with q)

In case if you have any queries please get us at support@helicaltech.com

Thank You
Mounika Pulimamidi
BI Developer
Helical IT Solutions Pvt Ltd

logo

Best Open Source Business Intelligence Software Helical Insight Here

logo

A Business Intelligence Framework


logo

Best Open Source Business Intelligence Software Helical Insight is Here

logo

A Business Intelligence Framework


0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments