I have never heard about IBM Universe before I had to integrate my application with IBM Universe (this time).

When I deal with two MS SQL servers I replicate data I need from other vendor DB to my application DB and write triggers on replicated tables which update my application.

If you know Universe's possibilities please offer some options.

I believe there is a better way rather than creating a CSV file on change in Universe and scheduled DTS package to process files and suck it in SQL 2000.


Thks a lot,

Igor

My application needs data from Universe. I do not need to update data in Universe.

For example, Universe maintains data about a resident. My application on MS SQL needs 'resident' table to function. I want every time a new record added or old record updated in Universe this change triggers INSERT/UPDATE/DELETE in MS SQL.

Igor