[Platform] Configure data connection

With the data connection option, you can create a data connection without a designer, and you can also see which databases are connected to the current report and modify them. [Designer]JNDI data connection and Multidimensional data connection plugins can be created by the designer, and platform-created data connections can also be managed by the designer.

Click on [Designer] JDBC data connection.

Enter the data decision system as the administrator and click "Manage>System>Data Connection>Data Connection Management New Data Connection" to create a new data connection, 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 ConnectionAuthorization.

Click "New Data Connection" button, you can select three types: Commonly used, All, and Others. As shown below:

1. Commonly used

Several common database types are displayed, including HSQL, IBM DB2, Microsoft SQL Server, MySQL, and Oracle. As shown below:

2. All

All database types supported by FineReport Designer are: ADS, Amazon Redshift, Apache Impala, Apache KYLIN, Apache Phoenix, DERBY, GBase 8A, GBase 8S, GBase 8T, H2, Huawei Cloud DWS, Fusioninsight Elk, Fusioninsight HD, GaussDB 200, Hadoop Hive, HBase, HP Vertica, HSQL, IBM DB2, INFORMIX, KINGBASE, Microsoft SQL Server, MySQL, Oracle, Pivotal Greenplum Database, Postgresql, Presto, SAP HANA, SAP Sybase, SPARK, SqLite, TeraData, TRANSWARP INCEPTOR, as shown below:

The main introduction is as follows:

Built-in Support and Plugin Support are selected by default.

After the database type is changed on the left, Built-in Support and Plugin Support are restored to their default values.

You can select Built-in Support and Plugin Support to filter the database type. If they are not selected, blank is displayed.

3. Others

The "Others" type includes JNDI data connections, other JDBC. As shown below:

The main introduction is as follows:

• New data connections include JDBC and JNDI data connections, and adapted third-party data source plug-ins.

• If the platform does not adapt to the data connection, the platform can only read the name of the data source, and cannot create, edit or view the specific Settings, but can only create, edit and view the data in the designer.

1) JNDI data Connection

Select JNDI Data Connection in Others type, as shown below:

Note: Refer to JNDI Data Connections for details:[Designer]JNDI data connection.

2) Other JDBC

If the required database type is not in the database list, select Other JDBC.

Place the corresponding driver package under%FR_HOME%\webapps\webroot\WEB-INF\liband restart the report server.

In Others, select Other JDBC, manually enter complete data connection information, such as the driver name and URL, and click Test Connection. After the Connection Successful, click Save. As shown below:

•  Data connection information: data connection name, drive, URL, encoding (it is recommended to choose automatic directly, JAR on December 27, 2018 and later support), user name, password.

• Test connection: test whether the database configuration is successful. If it is successful, "Connection successful" will pop up. If it fails, detailed reasons for failure will be displayed.

Note: Refer to [Platform]Cache Data Connection and [Designer]dBASE data Connection

For details, see the actual database reference documents.

The configuration information for different databases may vary. The following describes the Pattern and Authentication Method attributes.

1) Pattern

Connect Amazon Redshift, Apache KYLIN, Apache Phoenix, DEBRY, HP Vertica, IBM DB2, INFORMIX, Microsoft SQL Server, Oracle, Pivotal Greenplum Database, Postgresql, GBase 8S, GBase 8T, KINGBASE, Presto, SAP HANA, SAP Sybase, and Hbase have one more step than other data connections: mode. As shown below:

The mode is described as follows:

• If the schema is not selected for these databases, the first schema is selected by default.

• If the database does not have schema selection, no schema selection is required.

• The mode cannot be edited by default. You can edit the mode after you Click to Connect Database and connect to database successfully.

• The schema was created to make it easier for other functions to read the data in the database.Select Default value.

• SQL statements that connect to multi-schema databases need to be searched with the schema name prefix.

Note: For a database with mode selection, ensure that the database has a available mode; otherwise, an error will be reported during connection.

2) Authentication Methord

APACHE IMPALA, Hadoop Hive, SPARK, TRANSWARP INCEPTOR, APACHE Phoenix, and HBase configure authentication mode for data connection for six databases. As shown below:

The detailed introduction is as follows:

• If the database supports multiple authentication modes, click to display the authentication mode drop-down list.

• If Kerberos authentication is selected, enter the client name registered with the KDC and the keytab key path.

• For details about Kerberos authentication, see [Platform] Data Connection Kerberos Authentication

3) Advanced settings

The advanced Settings interface is shown as the picture below:

For details about the parameters, see Section II of the Connection Pool Properties document.

1) Management scope

In the data decision system, click "Manage>System>Data Connection>Data Connection Management" and click the icon on the right of a database, as shown below:

Note: The  icon is not displayed on the right of the unadapted database type.

After clicking the icon on the right of a data connection, the following table describes the buttons that appear:

For data connections not adapted to the platform, such as third-party data source plug-ins, the platform can only read the name of the data source, and cannot create, edit or view specific Settings. Instead, it can only create, edit and view data in the designer. "This type can only be viewed using the old version data connection in the designer"is prompted.

2) Connection pool status

Note: Only JDBC type databases have connection pooling.

The connection pool status page is displayed on the Data Connection page, as shown in the following figure:

The following table describes Active Connection Number and Number of idle connections.