| Author |
Message
|
| cwazpitt3 |
 Posted: Wed Nov 14, 2012 7:46 am Post subject: Anyone ever done Integration with Cognos? |
 |
|
Acolyte
Joined: 31 Aug 2011
Posts: 61
|
I was just wondering really if anyone has ever used Message Broker to trigger creation of reports in Cognos.
We have had calls with IBM Cognos teams and it seems their suggestion is to use their Java SDK. I have a POC I did that does this, but I'm not sure that we should be doing this within the JVM inside of Message Broker (and I'm a little apprehensive about this as well). This SDK seems to just be a wrapper around SOAP calls, so it is using AXIS to make service calls and stuff like that. Any suggestions or comments about using a fairly large SDK of this type within Broker?
They also have a WSDL, but it seems they really don't suggest using it directly but rather tell you to use the SDK which is really just a wrapper around this WSDL to "make it work" in their words. I plan to try this out anyhow just to see if it is another option...that's on my plate in the coming days.
I guess I just wondered if anyone in the MB community has tried this or heard about this and can offer any insight.
Thanks in advance! |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Nov 15, 2012 1:00 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| cwazpitt3 |
| Posted: Thu Nov 15, 2012 1:15 pm Post subject: |
|
|
Acolyte
Joined: 31 Aug 2011
Posts: 61
|
I am not trying to do this for monitoring though but rather just for a web application to request reports from Cognos. Is this solution able to just run reports? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Nov 15, 2012 1:26 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| cwazpitt3 |
| Posted: Thu Nov 15, 2012 1:46 pm Post subject: |
|
|
Acolyte
Joined: 31 Aug 2011
Posts: 61
|
I already have the wsdl and have tried to import it into broker. It has hundreds of errors (probably why the made the SDK as a wrapper). Most are duplicate field names in namespace types of things...just a mess. So I don't think its worth the effort of fixing it just for my purposes nor do I think its the right thing to do.
As of now I'm leaning towards using the SDK directly in the MB. Do you see any issues with that? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Nov 15, 2012 1:48 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
If I were writing code to interface with the SDK, I would write all my interface code in a Java jar using plain Eclipse or RAD. I would then call the Jar's subroutines from ESQL or JCN as needed.
I would not write any SDK code directly into a JCN.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| cwazpitt3 |
| Posted: Thu Nov 15, 2012 2:20 pm Post subject: |
|
|
Acolyte
Joined: 31 Aug 2011
Posts: 61
|
| lancelotlinc wrote: |
If I were writing code to interface with the SDK, I would write all my interface code in a Java jar using plain Eclipse or RAD. I would then call the Jar's subroutines from ESQL or JCN as needed.
I would not write any SDK code directly into a JCN. |
.
Ya that's basically what I did. Created a plain old java project and called it via esql . That seems to be working out good so far. Thanks for your help in confirming my thoughts. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Nov 16, 2012 5:59 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
The advantage of segmenting your code in this fashion is that you can test your Jar independently of WMB.
You have three deployment options:
1. [Best] Create a classloader service for your Broker instance.
2. [Better] Put Jar in $MQSI_WORKPATH/shared-classes.
3. [Ok] Include your Jar in the Bar. This is less desirable since you tend to end up with multiple Jars deployed to the same Broker with different versions.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
