Lotus Notes SQL

To obtain this driver, go to the Lotus NotesSQL web site at http://www.ibm.com/developerworks/lotus/products/notesdomino/notessql/. Read the documentation that is included with it for an explanation of how Notes data maps to relational tables. You can easily map SAP Sybase IQ tables to Notes forms.

Here is how to set up SAP Sybase IQ to access your Lotus Notes contacts.

• Make sure that the Lotus Notes program folder is in your path (for example, C:\Program Files (x86)\IBM\Lotus\Notes).

• Create a 32-bit ODBC data source using the NotesSQL ODBC driver. Use the names.nsf database for this example. The Map Special Characters option should be turned on. For this example, the Data Source Name is my_notes_dsn.

• Create a remote data access server using Interactive SQL connected to a 32-bit database server. Here is an example:

  CREATE SERVER NotesContacts
  CLASS 'ODBC'
  USING 'my_notes_dsn';

• Create an external login for the Lotus Notes server. Here is an example:

  CREATE EXTERNLOGIN "DBA" TO "NotesContacts" 
  REMOTE LOGIN 'John Doe/SYBASE' IDENTIFIED BY 'MyNotesPassword';

• Map some columns of the Person form into an SAP Sybase IQ table:

  CREATE EXISTING TABLE PersonDetails
  ( DisplayName CHAR(254), 
    DisplayMailAddress CHAR(254),
    JobTitle CHAR(254),
    CompanyName CHAR(254),
    Department CHAR(254),
    Location CHAR(254),
    OfficePhoneNumber CHAR(254) )
  AT 'NotesContacts...Person';

• Query the table:

  SELECT * FROM PersonDetails
  WHERE Location LIKE 'Waterloo%';