Kbase 15714: Report Engine - Connect Non-Progress Database With DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/02/2011 |
|
Status: Verified
GOAL:
How to get the Report Engine Connect to non-Progress database with dataserver
FIX:
We're going to assume:
1) Using Report Builder version 8 (RB 2.0)
2) Report developed using a local database
3) Want to deploy the report in an environment with a non-Progress database
How to override the db connection using the table interface:
As the report was built using a database and we need to override the connection parameters at run time using Report Engine with table interface, we must provide the new connection parameters.
Inside the report library (stored with the report) we have the connection used on development (e.g. database name, logical database name and single user mode).
We have a database wich contains the table RBREPORT (or equivalent); the call to report engine will be:
1) Database with RBREPORT table: rbdb.db, local.
2) Schema holder database: SPORTSH.DB, local (read-only)
3) DataServer Schema: ASSPORTS
4) Report developed using local database: MYDB.DB, logical name MYDB.
The RBREPORT.RB-DB-CONNECTION field must have the following:
mydb => assports
***
define variable wait-option as logical.
wait-option = false.
run aderb/_prore.p
(
wait-option,
"-db rbdb -1 -pf nonpscdb.pf"
).
***
nonpscdb.pf
-db sportsh -1 -RO
-db assports -dt as400 -H hostname -N tcp -S service -U user -P password