Posted: Tue Mar 27, 2018 1:50 am Post subject: IIB - DB Connection
Apprentice
Joined: 21 Dec 2009 Posts: 47
Hello,
Just wanted to know if the usage of odbc Database connection to make insert/update/delete operations is recommened or is it good to make these operations on the application end and use IIB just to transform the canonical to a simple flat xml. Send them to application using MQ and then processes them later using another technology to make the DB operations
I guess it depends on the architectural principles and guidelines you have in place. Generally it is a good practice to use IIB just to transform messages and leave the rest for the application so that there is a clear boundary between integration and application layers.
For eg: if you are sending the transformed message anyway to the destination via queue (or some other transport) then it doesn't make any sense to update the application database from IIB, that task should be left for the application.
Having said that I've seen scenarios where an application is not in a position to receive the transformed message as such (for various reasons), in that case you could get IIB to update the database but preferably via a database stored procedure so that all application specific logic can be maintained separately.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum