Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Maximo+BIRT: how to use jdbc data source?
Maximo+BIRT: how to use jdbc data source? [message #912730] Fri, 14 September 2012 04:17 Go to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
hi all,

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?

thanks

=======================================
EDIT:

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

Re: Maximo+BIRT: how to use jdbc data source? [message #913060 is a reply to message #912730] Fri, 14 September 2012 17:27 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
I am not very familiar with Maximo, but have you tried just creating a basic jdbc data source that use the tdsdrvier?

Jason

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913938 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913945 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913946 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913955 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913956 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913961 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913962 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913965 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913966 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913973 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member

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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913980 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913981 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913982 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913983 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913984 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #913985 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914000 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914001 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914002 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914003 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914004 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914005 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914006 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914007 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914008 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous messageGo to next message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914022 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914024 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914025 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914026 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914027 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914028 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914029 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914030 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914031 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914032 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914048 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914049 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914050 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914051 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914052 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914053 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914054 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914055 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914056 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914057 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914073 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914074 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914075 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914076 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914077 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914078 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914079 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914080 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914081 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914082 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914098 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914099 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914100 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914101 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914102 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914103 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914104 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914105 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914106 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914107 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914123 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914124 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914125 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914126 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914127 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914128 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914129 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914130 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914131 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914132 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914148 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914149 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914150 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914151 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914152 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914153 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914154 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914155 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914156 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914157 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914173 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914174 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914175 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914176 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914177 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914178 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914179 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914180 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914181 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914182 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914198 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914199 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914200 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914201 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914202 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914203 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914204 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914205 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914206 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914207 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914223 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914224 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914225 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914226 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914227 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914228 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914229 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914230 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914231 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914232 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914248 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914249 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914250 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914251 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914252 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914253 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914254 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914255 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914256 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914257 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914273 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914274 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914275 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914276 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914277 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914278 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914279 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914280 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914281 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914282 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914298 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914299 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914300 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914301 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914302 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914303 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914304 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914305 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914306 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914307 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914323 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914324 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914325 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914326 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914327 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914328 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914329 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914330 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914331 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914332 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914348 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914349 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914350 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914351 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914352 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914353 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914354 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914355 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914356 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914357 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914373 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914374 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914375 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914376 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914377 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914378 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914379 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914380 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914381 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914382 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914398 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914399 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914400 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914401 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914402 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914403 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914404 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914405 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914406 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914407 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914423 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914424 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914425 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914426 is a reply to message #912730] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914427 is a reply to message #913060] Sun, 16 September 2012 02:38 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914428 is a reply to message #913060] Sun, 16 September 2012 02:39 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914429 is a reply to message #913060] Sun, 16 September 2012 02:40 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914430 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
test

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914431 is a reply to message #913060] Sun, 16 September 2012 02:41 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914432 is a reply to message #913060] Sun, 16 September 2012 02:53 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914448 is a reply to message #912730] Sun, 16 September 2012 02:32 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914449 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Re: Maximo+BIRT: how to use jdbc data source? [message #914450 is a reply to message #913060] Sun, 16 September 2012 02:35 Go to previous message
j k is currently offline j kFriend
Messages: 436
Registered: September 2012
Senior Member
Hi Jason,

There's no issue there. I can embed a jdbc data source inside the report and that runs fine, but i want to leverage the data source info that comes with the default maximo birt reports(in a rptlibrary) and is already deployed on the server.

There's a maximodatasources.properties file that's used to create a script data source that's present in the "systemMaximoReports.rptlibrary" file (file types/names are from memory, im replying from home)


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?

Report message to a moderator

Previous Topic:HOW, ? Birt 4.2.0 runtime on Oracle Weblogic 11g
Next Topic:[chart] tooltip containing x label
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 02 22:52:14 GMT 2023

Powered by FUDForum. Page generated in 0.11179 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly