2010/03/18

Connect .NET application with Microsoft SQL database through OSB

I received a mail today from a Blogspot.com reader with the following question:

"Is it possible, to connect a .net application (running on Microsoft SQL 2010), with an Oracle OSB and import data from a SQL-database"

The reason I post this is that other people can also react and so we get more views on it.
My view on it:
  1. Make a WebLogic webservice (using for instance OpenJPA) to get the data from the SQL database.
  2. Expose this webservice through the OSB
  3. Call this service from the .NET application
This has the following advantages:
* No tight coupling between application and SQL database
* Reuse possibility of the data(base) service
 
 

No comments:

Post a Comment