I’d like to pull data from DB2 each day via an agent. Essentially the data in DB2 would be cleared at midnight, new data would be populated in DB2 and then I’d like it pumped into a Domino database with a new corresponding document for every DB2 record.
I don’t have to worry about synchronization of records on updates in the Domino database or anything.
I’ve done some work with ODBC and Lotuscript but I need this to be a scheduled server based agent.
What’s a good, simple way to do this?