How to connect Domino database in Finereport

1. Overview

Domino is a document-based database, not a relational database, and Domino can be JDBC or ODBC, using JDBC to install Lotus Domino Driver for JDBC and this method has been abandoned by IBM for many years, So here's how to connect to the Domino database in ODBC for the Report development tool Finereport.

2. Connection steps

2.1 Notes SQL Installation and setup

Download the Notes SQL (IBM Lotus notes SQL Driver) installation package and install complete.

Locate the notes SQL shortcut in the Start menu and click Notes SQL Authentication List Manager under Notessql, as shown in:

650) this.width=650; "src=" http://img.blog.csdn.net/20151215112011191 "style=" border:none; "/>

Use it to add notes profiles and ID files, as shown in:

650) this.width=650; "src=" http://img.blog.csdn.net/20151215112020825 "style=" border:none; "/>

2.2 Adding environment variables

Add the directory where the Notes.ini is located to the system path environment variable, as shown in:

650) this.width=650; "src=" http://img.blog.csdn.net/20151215112031710 "style=" border:none; "/>

2.3 Configuring an ODBC data source

Open the ODBC Data Source Manager, select the System DSN, click the Add button, select "Lotus Notes SQL Driver (*.NSF)", the ODBC Lotus Notes Setup dialog box appears, according to the actual situation can be completed, as shown in:

650) this.width=650; "src=" http://img.blog.csdn.net/20151215112042311 "style=" border:none; "/>

2.4 Defining data connections in the designer

Click Designer server > Define Data Connections , create a new JDBC data connection, database selection: Others, Drive selection: Sun.jdbc.odbc.jdbcodbcdriver,url fill in: Jdbc:odbc:Domino (where Demino is the ODBC data source name) , test the connection button to indicate that the connection was successful, such as:

650) this.width=650; "src=" http://img.blog.csdn.net/20151215112053765 "style=" border:none; "/>

How to connect Domino database in Finereport