Here is my question. I have a SQL table that I want to repopulate an address book on a nightly basis. i delete all the documents out of the database. Does anyone have an idea in decs on how to schedule running an initialize keys to bring back all the data (plus new records) or how to set up the scheduled process to repopulate all the records from SQL again.
Thanks in advance.
Subject: DECS and automatically running initialize key
That’s not what DECS is intended for. Deleting and recreating all documents every night is absolutely worst practice.
If you don’t feel like programming the update logic yourself (using e.g. LotusScript with LS:DO or Lotus Connectors or Java with JDBC), LEI might be the right thing for you. It will allow you to define batch updates from external data sources purely through configuration and without any coding. But there is a noteworthy price tag …
Look up “Connecting to enterprise data” in Designer help for a description of the characteristics of the available tools.