Data from sql server

HCL Domino Domino Forum
1

Hi,

I need to download data into Notes database from ms sql server periodically. I need to automate the process. Please let me know what should be done?

I need something like background agent, which runs once in a day and downloads data from the sql server into Notes database. Any sample code is appreciated

Thanks

2

Subject: Data from sql server

You can use LS : DO and/or data connection resource, ODBC connector, LEI, Percussion Notrix, etc.

If you look at any of the help files for these funcationality you will see example code. OR you can look at the Redbook for R6.

HTH – Cheers

3

Subject: RE: Data from sql server

You could also try and use LC LSX.

4

Subject: RE: Data from sql server

There’s also now a redbook for LEI. This talks about using LEI, DECS, and the LC LSX. The latter two are included with Domino.

5

Subject: RE: Data from sql server

LS : DO would work within domino as well