I. Overview
SAP HANA is a combination of software and hardware that provides high-performance data query functions. Users can query and analyze a large amount of real-time service data without modeling or aggregating the service data.
II. Data connection
1. Configuration information
| Driver | URL | Driver download link | Supported database versions |
|---|---|---|---|
| com.sap.db.jdbc.Driver | jdbc:sap://ip:port?reconnect=true | 2.0 4.5.1 |
2. Placing the driver File
Download the SAP HANA driver package from the driver download link of the configuration information and place the driver package under %FR_HOME%\webapps\webroot\WEB-INF\lib to restart the report Designer and server.
3. Selecting a connection mode
FineReport provides two ways to connect data:
Method 1: Connect to the database in the designer. For details, see [Designer]JDBC data connection.
Method 2: Connect to the data decision platform. This paper mainly introduces this way.
4. Connection steps
1) Creating a data connection
Administrator login data decision system, click Manage>System>Data connection>Data Connection management, select New Data connection, select SAP HANA under All options, and click OK, as shown below:
Note: If non-administrator users want to configure data connection, the administrator must assign the permission of the data connection node in the management system to them. For details, see Data Connection Authorization.
2) Configuring data connections
Enter the data connection information in the format described in Section II. Advanced Settings are optional. For details, see [Platform] Data Connection. After input information, the interface is as follows:
3) Testing the connection
Click Test Connection, or Click to Connect Database in mode. If the "Connection Successful" prompt box pops up, the database is successfully connected, as shown below:
4) Selecting a mode
After the connection test is successful, you can select a mode as required. If you do not select a mode, the first mode is used by default. As shown below:
5) Effect preview
Click the Save button in the upper right corner after selecting the mode, and the data connection will be added successfully. As shown below:
III. Precautions
1. Error 1: Authentication failed
Problem: The following error occurs when connecting to an SAP HANA database: http-nio-8075-exec-5 ERROR
[standard] [10]: authentication failed
Analysis: The account used is not an administrator account, so make sure that the user name, password and IP address are correct, and check whether the account has the permission to perform operations in the database.Solution: Assign a privileged account to connect, and the connection will be successful.
