Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to query a remote database from within RTC? (Widgets?)

At the moment we are using an External Content widget to display HTML generated from our code. This HTML is plain text and is hard to quick interpret. 

Is there a way of querying a remote database (MySQL) and then display the results graphically? Is there a Widget which would allow us to do this? Or could we modify one to suit this requirement? 

Version details:
RTC: 4.0
Jazz: 4.0.6

Thanks in advance. 

0 votes



2 answers

Permanent link
I am not aware of any UI widgets that provide the support you requested.  You could create one, using the OpenSocial api. 
here is a link to the level of support for OpenSocial from the Jazz foundation
https://jazz.net/wiki/bin/view/Main/OpenSocialSupportInJazz

1 vote

Comments

 I've spent quite a while looking both on this forum and elsewhere for an existing Widget and don't think it exists. I'll leave the question open for the minute but if this is the solution used, I'll mark this as accepted. Or I'll post the solution.


Permanent link
Hi Jack,

I would like to follow up with some questions :

About Mysql support you're right. The databases supported are Oracle, SqlServer and DB2.
For the RTC 4.0 DB versions and compatibility you can check at this link :  https://jazz.net/library/article/811

On the question about querying a remote database, An alternative to approach it, is to create this connection using only the databases. Do you connect to the RTC database the remote database that you want to query. I believe it's a good solution to this case because it is transparent for the application.

For Oracle databases, we could use the DBLink (database link) which is quite simple to enable :
Check1 ) http://www.orafaq.com/wiki/Database_link
Check2 ) http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm

For DB2 you can create synonyms referencing the external Data :  http://forums.devshed.com/db2-development-114/equivalent-database-link-oracle-db2-77675.html

For MySql Is had research and I could find some orientations regarding the federated engine should be use for query tables on remote servers.

I hope it help you out.


1 vote

Comments

 I'm not sure exactly where the question was there but I'll try to give some more details. 


At the moment all RTC does is used an External Content widget to display HTML generated though some scripts. The scripts are what queries the MySQL database at the moment. I was hoping for a direct method of querying the database, and then transforming the results into a graph/table. 

The Federated Engine looks like an interesting theory, but unless I'm mistaken in what I've read, it requires both databases to be MySQL with the same config. 

right. the provided widgets do html content view.  A general purpose graphing UI widget from varying sources would be a lot of work to support.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 201
× 84
× 82
× 37

Question asked: Jan 05 '15, 7:02 a.m.

Question was seen: 5,528 times

Last updated: Jan 09 '15, 3:39 p.m.

Confirmation Cancel Confirm