| |
|
|
Can I Integrate Notes data with Microsoft Access?
Yes. There are two ways to achieve this depending on what the business objective is.
Data from Notes databases can be linked via Integra for Notes to read or write data to Microsoft Access. Both Access and Lotus Notes support ODBC as a standard data access method and Integra for Notes leverages this.
Integra profiles can be created using the @DbLookup and @DbColumn functions with ODBC parameters to read data from Access databases and use this data in conjunction with Notes data for exporting to Word or Excel.
Below is an example for your review:
Scenario: An Excel based report is required of client details from a Notes database but we wish to show the current outstanding balance on the client's account. This Balance is contained in an accounting database which uses Microsoft Access.
Solution: A list of the fields to be exported from the Notes database is created in the Selected Field List and a Computed field called Balance is also added. A formula needs to be set for the Balance field as shown below:
res := @DbLookup( "ODBC" : "NoCache" ; "Integra ODBC Demo" ; "" : "" ; "" : "" ; "ACCOUNT" ; "balance":"" ; "account" ; accountcode ; "" : "" );
@if(@iserror(res);"ODBC Error";res);
where "Integra ODBC Demo" is the source name of the database which is being connected to.
In addition, the Lotuscript Microsoft Access 9.0 Object Library under the Lotuscript OLE Classes can be used to update the Access databases with data taken from a Notes database and this script can be used in Integra profiles to enable updating of data to Access databases.
Related FAQ's:
|
. |
|
FAQ# 0007
|
|
|
| |