Re your ODBC and DECS comment Doug Finner 9.Nov.11 07:03 PM a Web browser LC LSX LC LSX - All ReleasesWindows
Re: 'Note that if you went with this option, you would be making a Connection to ODBC instead of a Connection to Oracle in the DECS administrator. '
In my case, I'm not actually using the whole DECS structure. I write LS that uses lsxlc and connect to Oracle there. Basically, I need to suck down some data from Oracle into Notes dbs and then use that data as pick list sources in other apps. For instance, I'll pull down release parts, bills of material, latest purchase cost data, etc.
Given that the data is dynamic, I think we'd need to be running LEI to handle the updates and it's highly unlikely we'll buy LEI. That results in my writing code to do the dynamic data management; as a new version of a part is released in Oracle, I'll obsolete the old version in my Notes db and pull in the latest rev. It works pretty good with the only issue being that my Notes data can be up to an hour out of sync with Oracle since my agents run once an hour. It's not generally a big deal and, if it is, I just force the agents to execute.
Return to top
. . . . Re your ODBC and DECS comment (Doug Finner 9.Nov.11)
Print this page
