Connecting Report builder to other (not RTC, not IBM) Oracle Databases
Hello,
Ideally I want to connect Report Builder to a Serena Dimensions database and then fire SQL queries at it to return queries as tables for display in Report Builder widgets. Happy to just fire plain SQL statements at this oracle database.
I cannot test whether this would work without playing with firewalls on the RTC server to make sure the RTC process running on the server can see Dimensions oracle server.
Well worth the trouble if I can do something like this as it could tie history of the old tool to the new tool and use the rather slick Report Builder.
Thanks for any advice
Richard
One answer
Richard,
the Report Builder Administration allows to connect to
- A Rational Data Warehouse
- A Lifecycle Query Engine
- A Lifecycle Query Engine scoped by a configuration
I would assume that an arbitrary database somewhere is likely not to show up in the choice list above. My many, many years of experience tell me, that applications that work on databases usually make assumptions about the tables and other characteristics and fail if the assumptions are not matched. E.g. RS will make assumptions about how to find project areas and other information when creating a report (even before you start with SQL). There will also be assumptions about where to get the attribute names, Ids and the used data types and formats.
This and common sense tells me that it is pretty likely futile to even try.
1. You can try to create a lifecycle query index server facade for the Serena Dimensions database and configure Report builder to use it.
2. You can see if you could write custom ETL Jobs for the Data Warehouse that pull in the data from the Serena DB. I do not thing this is supported.
I fail to understand why this is tagged with rational-insight.
Comments
