howto create BIRT Datasource for DFM (OCUM 5)

IMHOTEPSON — Wed, 04 Jun 2025 14:15:57 GMT

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 ?

Re: howto create BIRT Datasource for DFM (OCUM 5)

atwilson — Fri, 08 Dec 2017 22:22:23 GMT

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

Re: howto create BIRT Datasource for DFM (OCUM 5)

IMHOTEPSON — Mon, 11 Dec 2017 10:01:58 GMT

that's it, many thanks for your reply

topic Re: howto create BIRT Datasource for DFM (OCUM 5) in Active IQ Unified Manager Discussions

howto create BIRT Datasource for DFM (OCUM 5)

Re: howto create BIRT Datasource for DFM (OCUM 5)

Re: howto create BIRT Datasource for DFM (OCUM 5)