Active IQ Unified Manager Discussions

howto create BIRT Datasource for DFM (OCUM 5)

IMHOTEPSON

we do have OCUM 7 and OCUM 5 and we want to create a Datasource to OCUM 5 for creating reports at one Spot.

Is it possible to create custom reports for OCUM 5 with BIRT ?

1 ACCEPTED SOLUTION

atwilson

This is what I did:

 

Eclipse BIRT DB connection to NetApp DFM 5.2

 

Locate the SQL Anywhere jdbc connector drivers  (jconn2.jar, jconn3.jar, jodbc.jar)  on the DFM server
i.e.  D:\Program Files (x86)\NetApp\DataFabric Manager\DFM\misc\dbconn
copy the folder and drivers to the Eclipse BIRT server i.e.  \\BirtSrvr\c$\DFM 5.2 java db connector

 

Open Eclipse BIRT console and create a new project, report, and define a data source

JDBC Data Source
Manage Drivers
Add the jconn2.jar driver from C:\DFM 5.2 java db connector\

Define the connection

Driver Class:   com.sybase.jdbc2.jdbc.SybDriver (v5.5)
Database URL:   jdbc:sybase:Tds:xxx.xxx.xxx.xxx:2638  (specify the IP of the DFM DB)
User Name:     specify an account that has read access to the DFM DB
Password: xxxxxxx

 

The jconn2.jar also needs to be copied to the following location to display reports in the Apache Tomcat BIRT Reporting runtime

i.e  C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\birt-viewer\WEB-INF\lib
restart the Apache Tomcat service

 

hope this helps

Andrew

View solution in original post

2 REPLIES 2

atwilson

This is what I did:

 

Eclipse BIRT DB connection to NetApp DFM 5.2

 

Locate the SQL Anywhere jdbc connector drivers  (jconn2.jar, jconn3.jar, jodbc.jar)  on the DFM server
i.e.  D:\Program Files (x86)\NetApp\DataFabric Manager\DFM\misc\dbconn
copy the folder and drivers to the Eclipse BIRT server i.e.  \\BirtSrvr\c$\DFM 5.2 java db connector

 

Open Eclipse BIRT console and create a new project, report, and define a data source

JDBC Data Source
Manage Drivers
Add the jconn2.jar driver from C:\DFM 5.2 java db connector\

Define the connection

Driver Class:   com.sybase.jdbc2.jdbc.SybDriver (v5.5)
Database URL:   jdbc:sybase:Tds:xxx.xxx.xxx.xxx:2638  (specify the IP of the DFM DB)
User Name:     specify an account that has read access to the DFM DB
Password: xxxxxxx

 

The jconn2.jar also needs to be copied to the following location to display reports in the Apache Tomcat BIRT Reporting runtime

i.e  C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\birt-viewer\WEB-INF\lib
restart the Apache Tomcat service

 

hope this helps

Andrew

View solution in original post

IMHOTEPSON

that's it, many thanks for your reply

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public