To Connect to KDB database in Jaspersoft follow the below steps:
- Open Jasper studio and create a data adapter.
- KDB requires a separate jar file called ‘jdbc.jar’.Below is the jar file.
- Include this jar file in Driver Classpath.
- Add the details in data adapter as shown.
- Create a new report.
- In dataset, select language as ‘sql’.
- Write the required query and preview.
JDBC Driver – jdbc
JDBC Url – jdbc:q:servername:port
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](https://www.helicaltech.com/wp-content/uploads/2019/01/Quotes.png)
Best Open Source Business Intelligence Software Helical Insight Here
![logo](https://www.helicaltech.com/wp-content/uploads/2019/01/logo.png)
A Business Intelligence Framework
![logo](https://www.helicaltech.com/wp-content/uploads/2019/01/Quotes.png)
Best Open Source Business Intelligence Software Helical Insight is Here
![logo](https://www.helicaltech.com/wp-content/uploads/2019/01/logo.png)
A Business Intelligence Framework
Subscribe
Login
0 Comments