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 a SQL Anywhere 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%';