MQ Series and ODS.

Customer Information Control System. Middleware and MQ Series.
Previous topicNext topic

Topic Author
Deepa
Registered Member
Posts: 16
Joined: Wed Mar 12, 2014 1:08 pm

MQ Series and ODS.

Post by Deepa » Sat Oct 21, 2017 6:54 pm

Hi,

We have a system which is called as ODS. This gets the data from mainframes. In mainframe there are IMS database and every segment of this database is replicated in ODS. This replication is done using the IBM EP and MQ Series.

There are very few knowledgable people for this system. My questions are:

Is this a setup which is common in many mainframe setups?
Why do we use MQ Series in such set-up? Can't we just FTP and make use of the FTPed data?




enrico-sorichetti
Global Moderator
Global Moderator
Posts: 892
Joined: Wed Sep 11, 2013 3:57 pm

Re: MQ Series and ODS.

Post by enrico-sorichetti » Sat Oct 21, 2017 7:10 pm

only somebody working in Your organisation can answer Your questions


cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)

User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: MQ Series and ODS.

Post by Anuj Dhawan » Sun Oct 29, 2017 10:38 pm

With my little experience I'd say it's common to the shops where there had been a lot of mergers, taken over other companies or vice-versa. After the merge ups now a lot of departments needs data from each other, interchangeably.

Mostly you need an interface where writing APIs are easy, depends on the mileage of the shop though, but if most of the enterprise operates on Win or *nix boxes - a usual preferred way to pick a choice from that world. Oracle, I've seen mostly. DB2 UDB could also be a choice, depends.

FTP would require another interface to be written at receiving end. With FTP you'll be able to send across the data-sets (files) which would reside on a server but you need (mostly) that information in Database (of your choice. If not it beats the purpose of having ODS, AFAIK). Having Web Services or MQ Series helps you to get away from this and you can mostly replicate data directly. It might require database triggers or stored-procedures to get it working though.


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.

Previous topicNext topic

Return to “CICS, Middleware and MQ Series.”