Need help with how to add Data Source and Build Data Sets in BIRT RCP Report Builder. The progress DB is on a UNIX server and want to connect to it from windows pc which does not have progress installed on it. Here is what I have below:-
Have specified Data Source as below:-
Driver Class: com.ddtek.jdbc.openedge.OpenEdgeDriver (Progress OpenEdge JDBC v3.6)
Driver URL: jdbc:datadirect
penedge://bonobos:3045;databaseName=pjh;defaultschema=pub;statementCacheSize=10
Username: teenpjh
Password: a password was entered
JNDI URL: Nothing here was entered
Defined envirnment variable CLASSPATH as below on the windows client:-
C:\birt-rcp-report-designer-2_3_2\openedge.jar;C:\birt-rcp-report-designer-2_3_2\util.jar;C:\birt-rcp-report-designer-2_3_2\base.jar;%CLASSPATH%
On clicking test connection, it is ok.
However when I go to build the Data Set, I can't see the tables and columns I see connected as below:-
- OpenEdge Data Source
- Pub
STORED PROCEDURES
- SYSPROGRES
STORED PROCEDURES
Please help. Thanks.
Have specified Data Source as below:-
Driver Class: com.ddtek.jdbc.openedge.OpenEdgeDriver (Progress OpenEdge JDBC v3.6)
Driver URL: jdbc:datadirect
penedge://bonobos:3045;databaseName=pjh;defaultschema=pub;statementCacheSize=10Username: teenpjh
Password: a password was entered
JNDI URL: Nothing here was entered
Defined envirnment variable CLASSPATH as below on the windows client:-
C:\birt-rcp-report-designer-2_3_2\openedge.jar;C:\birt-rcp-report-designer-2_3_2\util.jar;C:\birt-rcp-report-designer-2_3_2\base.jar;%CLASSPATH%
On clicking test connection, it is ok.
However when I go to build the Data Set, I can't see the tables and columns I see connected as below:-
- OpenEdge Data Source
- Pub
STORED PROCEDURES
- SYSPROGRES
STORED PROCEDURES
Please help. Thanks.