Eclipse Community Forums: BIRT » DB2 connect blank

Help

Home

Home » Eclipse Projects » BIRT » DB2 connect blank(Using Data Explorer, DB2 connection is blank)

Show: Today's Messages :: Show Polls :: Message Navigator

DB2 connect blank [message #1737261]

Wed, 06 July 2016 17:18

Ed Overton

Messages: 1
Registered: July 2016

Junior Member

I am using BIRT 4.3.1, with db2 11.1.0.
I can connect to the database, but everything under it is blank.
I used IBM Data Studio 4.1.2, this works.
How do I debug this issue?

Report message to a moderator

Re: DB2 connect blank [message #1738838 is a reply to message #1737261]

Mon, 25 July 2016 10:55

Ricardo Paz

Messages: 2
Registered: July 2016

Junior Member

Hi Ed.

I use BIRT report design to create my reports.
To connect to DB2 databases I use jt400.jar drivers.

I just copy Jt400.jar file to the ...eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_...\drivers directory and works fine.

To create the data source connection right click Data Sources and select New Data Source in the Data Explorer Tab.

In driver class select com.ibm.as400.access.AS400JDBCDriver (v9.9)
Database URL: jdbc:as400:<server_ip>/<database>
User name: <your username to connect the database>
Password: <your password to connect the database>

Click test connection to verify if the connection it's ok.

I hope it helps.

Report message to a moderator

Previous Topic:	Related Cascade Parameters
Next Topic:	BIRT on AIX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 08 15:10:40 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter