Import SQL view as Notes address book

HCL Domino Domino Forum
1

HiOur CRM system uses a MS SQL server as database environment. In the database I have a contact_person view with name, email, adress, phone etc.

I want to import this view into a shared Notes adress book database. Considering my novice skills in Notes/Domino, where should I start, and what should look into to get a hint on how this could be done?

Regards

K. E. Smith

2

Subject: Import SQL view as Notes address book

You can:

  1. If one off exercise, export the database as a flat file (comma delimted), then open the file (*.txt) using Lotus 123 or Excel (If you’re opening it in Excel, use file open when in Excel, then you’ll be offered options via the wizard to move the data into columns. Then ensure you save the file as a 123 file), then import the 123 file into the Notes view

Lookup fiel import in the deisnger help for further detail

  1. Use ODBC with the LSEXTENSION in an agent

  2. Use flat files which post to a file server, then chop up and create relevant Notes docs using an agent

  3. Use DECS to connect to the SQL server and do it dynamically

  4. Use a third party product (Eg. Notrix, LEI) to handle it all for you (but this ain’t cheap)

HTH

3

Subject: Import SQL view as Notes address book

Check the documentation on LEI (Lotus Enterprise Integration). You can set up a connection to a database via ODBC and map form fields to fields in a database table or view. You can then automatically draw information from the database or have Notes and the external database exchange information.