|Maximo+BIRT: how to use jdbc data source? [message #912730]
||Fri, 14 September 2012 04:17
| j k
Registered: September 2012
I'm trying to create a report that uses a jdbc data source and that inherits credentials from the mxreportdatasources.properties file
It's the tdsdriver: # jdbc:inetdae7a:hostname:port?database=dbname&language=us_english&nowarnings=true
I haven't been able to find any info anywhere. The guides on the birtreporting.com site skip this step
And when I deploy the report it keeps using the data source url that's embedded in the report
Is it possible to use the tdsdriver as a jdbc data source or am I stuck with having to use a script data source?
I cant post a reply for some reason. No error message, the original posts just load up again. And if i look at the tree view it's full of invalid links, so here's my response:
I've been reading this : Configuring BIRT Designer 2.3.2 with V7 Products (link to ibm removed - You can only use links to eclipse.org sites while you have fewer than 25 messages.) and their 'design guidelines' recommend using the same script data source and embedding proprietary ibm maximo java libraries inside the report scripts (thereby preventing the reports from running outside maximo).. I don't agree with that methodology for custom reports
I prefer using a reporting tool for presentation only. If the dataset the database spits out matches the dataset definition in the report then the report should run. And i prefer using a jdbc data source than a script datasource because it makes dev faster and i get better error messages
So i guess my question now is..
how do i retrieve the attribute values from a data source imported from a library to build a jdbc data source? although im guessing since it's a script data that won't be possible..
What about dynamically loading themaximodatasources.properties file and populating the values in my jdbc data source? Can I load a properties file by specifying a relative path or does it have to be in the "reference library" location?
And can i do this inside my custom rptlibrary file or would i need to have the script code to assign the jdbc data source properties inside every report?
[Updated on: Sun, 16 September 2012 02:46]
Report message to a moderator