It's all about the answers!

Ask a question

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


Jack Dunning (312) | asked Jan 05 '15, 7:02 a.m.
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. 

2 answers



permanent link
Grazielle Codogno (1536) | answered Jan 06 '15, 3:31 p.m.
edited Jan 06 '15, 3:47 p.m.
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.



Comments
Jack Dunning commented Jan 07 '15, 6:51 a.m.

 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. 


sam detweiler commented Jan 07 '15, 7:34 a.m.

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.


permanent link
sam detweiler (12.5k6195201) | answered Jan 05 '15, 9:24 a.m.
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


Comments
Jack Dunning commented Jan 05 '15, 10:40 a.m.

 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.

Your answer


Register or to post your answer.