ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB - DB Connection

Post new topicReply to topic
IIB - DB Connection View previous topic :: View next topic
Author Message
Senthamizh
PostPosted: Tue Mar 27, 2018 1:50 am Post subject: IIB - DB Connection Reply with quote

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

Thanks
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Wed Mar 28, 2018 4:54 am Post subject: Reply with quote

Master

Joined: 17 Jul 2017
Posts: 236
Location: UK

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.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB - DB Connection
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.