Kbase 16734: Override Progess DB w/An Oracle DB Within Report Builder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to override database connection from a Progress database to Oracle within Report Builder?
FIX:
The Report Engine Table Interface will allow user to override database connection information from a Progress Database to an Oracle Database. By using this table interface, user can utilize the same report which was originally used with a Progress Database, against an Oracle Database with minimum rework.
This is how it can be done:
Create the Report Engine table and save it in the Progress database. (Please note, it will not work with the Schema holder).
EXAMPLE:
Running Report Engine from an application - TABLE INTERFACE.
/*You must be connected to the Runtable database in multi-user mode before running this procedure.*/
================================================================================
DO TRANSACTION:
CREATE RBREPORT.
ASSIGN RBREPORT.RB-REPORT-LIBRARY = "c:\rboracle\reports.prl"
RBREPORT.RB-REPORT-NAME = "Customer List"
RBREPORT.RB-DB-CONNECTION = "sports => orac"
RBREPORT.RB-PRINT-DESTINATION = "D"
RBREPORT.RB-DISPLAY-STATUS = yes
RBREPORT.RB-DISPLAY-ERRORS = yes.
RELEASE RBREPORT.
END.
RUN aderb\_prore(false, "-db Runtable -N WIPC -pf oracle.pf -rbdel").
================================================================================
ORACLE.pf = -db holder -N TCP -db orac -N TCP -S demosv0 -H themis
-ld orac -dt oracle -U sports -P sports
where holder = oracle database schema holder, orac = oracle database name, and sports = Progress database