odbc jdbc driver

I have iPortal workgroup version installed along with BIRT report option. I am trying to open reports that have been designed in BIRT using an oracle ODBC JDBC connection. I have the driver but I don't know where to install it on the iPortal so that I may open the reports I made with BIRT. Please help.

Find more posts tagged with

Comments

scott_d

I'm also wondering the same thing. I have the iServer Express demo and a SQL Server jdbc jar I can't figure out where to place.

rmurphy

The following DevShare post has been updated to include the where to place JDBC drivers for iServer Express and iPortal. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=5&lid=169'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=5&lid=169</a> 
 
Rob

Virgil Dodson

Hi guys, 
There is a DevShare post that describes where to put the JDBC driver for iPortal workgroup and iServer Express 
 
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=5&lid=169'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=5&lid=169</a>

scott_d

Thanks for the tip, I placed the jar under the directory for iServer Express, didn't work but went into the servlets directory and copied it to iPortal's jar directory as described and it works now.

rmurphy

Assuming you installed the iServer Express into the default directory, copying the jar files to
C:Program FilesActuate9JarBIRTplatformpluginsorg.eclipse.birt.report.data.oda.jdbc_2.2.2.v20071218-1951drivers

should work. Are you saying that this did not work?

Rob

scott_d

Correct, the iServer express directory did not work.
But I'm running the report from my documents folder on iPortal, perhaps this is the issue. I'm new to actuate/birt and still trying to figure how all the pieces fit together.

rmurphy

The iPortal is a multi-use web application that allows users to browse for and execute reports. The iPortal can run in a lighter weight standalone (workgroup) mode, or as an interaface to the iServer Express. When running the iPortal in workgroup mode, report designs are stored in a file system based repository. In this scenario the iServer Express is not involved and generation of reports occurs in the application server (e.g. Tomcat). In this instance, the JDBC drivers will need to be in the iportal's WEB-INFplatformpluginsorg.eclipse.birt.report.data.oda.jdbc_drivers directory.

When you install the iServer Express, you automatically get the iPortal too. In this instance report generation is handled by the iServer Express outside the app server. When running with iServer Express, the drivers should be located in ACTUATE_HOMEJarBIRTplatformpluginsorg.eclipse.birt.report.data.oda.jdbcdrivers.

I'm wondering if you have installed both iServer Express and iPortal. If so, it sounds like you may be running the report from the iPortal running in workgroup mode. Did you copy the report design you are executing to a location on the file system or did you publish/upload it to the iServer Express?

scott_d

Thanks for the info Rob. 
 
I've just got the default iServer Express bundle installed onto the server. To deploy, I just right click in Eclipse and "Publish Report to iServer". Then to run it I go to our server URL,<a class='bbc_url' href='http://192.168.x.x:8900/iportal/getfolderitems.do?serverurl=httpblahvolume=xxxxx'>http://192.168.x.x:8900/iportal/getfolderitems.do?serverurl=httpblahvolume=xxxxx</a>, into my folder and click the report to run it. 
 
I'm not sure if this is the correct way, its just what i fell into.

Carvajal

Hi,

I'm running iServer 10 on a Linux box (CentOS release 5.4 ), using Kerberos authentication against A.D. and pulling out data from SQL Server 2008 R2.

I copied the SQL JDBC driver into TWO folders. See description:

./jar/BIRT/platform/plugins/com.actuate.data.oda.jdbc.drivers_2.3.2/sqljdbc4.jar
./jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.3.2.v20090605-1532/drivers/sqljdbc4.jar

In my specifications I need "INTEGRATED SECURITY", I cannot use SQL Server Authentication.

I'm getting a message that says: "This driver is not configured for integrated authentication."

How can I get integrated authentication to SQL Server R2 from iServer running on Linux?

Thanks!

R.