Re:Re: IDMS Data Replication Via TCP/IP

Discussion created by ca.portal.admin on Nov 6, 2008

We replicate to a data warehouse on MS SQL server. The rational
was to get reporting cycles off the mainframe to free cycles for
other work.

Our replication is done via a third party product except for updates
done by our local mode batch processing (no journaling). Those are
selectively done by
a program we wrote that creates SQL syntax that is FTP'ed to MS SQL

Since you are asking about TCP/IP does that imply real time replication?
We FTP our SQL files to the data warehouse server and they have a
that is kicked off to apply the SQL updates. I am not aware of a
canned real time process on the SQL server side with which CA IDMS
code could communicate. (that does not mean there is not one)

Terry Schwartz
Perot Systems