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.
2 answers
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
here is a link to the level of support for OpenSocial from the Jazz foundation
https://jazz.net/wiki/bin/view/Main/OpenSocialSupportInJazz
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.
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
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.