-
1. Re: Fuse Integration Designer: access to table in relational database
socallag Jun 24, 2009 6:57 AM (in response to simonepringle)Hi Simone,
It is possible to interact with Relational Databases using the FUSE Mediation Router (Camel) , the following documentation explains how this is done.
http://camel.apache.org/sql-component.html
http://camel.apache.org/jdbc.html
In the context of using the FID a Generic Endpoint can take any URL that is supported by Camel, which would include the jdbc: and sql: documented above, but you may required to do some additional configuration of such endpoints.
If you can give us a little more detail of your usecase we may be able to help some more.
Regards,
Seán
-
2. Re: Fuse Integration Designer: access to table in relational database
simonepringle Jun 24, 2009 2:31 PM (in response to socallag)Hi, Sean!
Thanks for the quick reply. I'll definitely take a look at the links you provided.
In the meantime, we're trying to set up an environment that makes it easy(ier) for folks to service-enable (read) access to data. We are in an experimental phase of our efforts (i.e. 'researching'), so the first thing we were trying to do was to expose data from a single table as a service.
Imagine, for instance, that I have a table that summarizes reporting data (e.g. last month's statistics on web page visits - each page on the site tracking the total number of visitors per month). I'd like to be able to access that data (read it) using a web service.
It seems that it should have been possible to do something (generically) like:
JDBC-aware end point -> Mapper -> Web-service publisher
Each of the steps above would be configurable:
- JDBC-aware end point: connection string including login
- Mapper: select and potentially manipulate row values and map to target format (XML)
- Web-service publisher: WSDL-specifiable interface
Does that make sense?
Thanks for your help,
Simone
Edited by: simonepringle on Jun 24, 2009 6:30 PM
-
3. Re: Fuse Integration Designer: access to table in relational database
abdeslam Jul 21, 2009 5:58 AM (in response to simonepringle)Hi simonepringle !
i have done same things without FID.
I'm very interested by your experience for integrating JDBC DB and mapping.
Can you share it ?
Regards
abdeslam