Previous Topic
JDBC Connection Plug-ins
Logi Report Designer provides connection plug-ins for the most commonly used relational databases: Oracle, MySQL, SQL Server, InterSystems IRIS, and PostgreSQL, to include the JDBC drivers required for these databases for an easy connection setup procedure (by default Logi Report does not include the MySQL driver in the MySQL connection plug-in for license concern so you will need to provide it by yourself). This topic describes connecting to these databases using the connection plug-ins.
A connection plug-in can have its own driver, configuration dialog, and logo. The configuration dialog defined in a plug-in can be used to create a connection to the database and can get driver from the plug-in.
The following shows the procedure to set up a JDBC connection to connect to an Oracle, MySQL, SQL Server, InterSystems IRIS, or PostgreSQL database via the corresponding connection plug-in:
- Do one of the following:
- On the Start Page, select Oracle, MySQL, SQL Server, InterSystems IRIS, or PostgreSQL in the Connect category. In the Create Connection dialog, specify an existing catalog or create a new one and select OK.
- In the Catalog Manager, right-click a data source and select New JDBC Connection from the shortcut menu, then select Oracle, MySQL, SQL Server, InterSystems IRIS, or PostgreSQL in the Select Connection Type dialog.
- In the Catalog Manager, select a data source and select New Data Source on the toolbar. In the New Data Source dialog, specify the name of the data source, then select the Oracle, MySQL, SQL Server, InterSystems IRIS, or PostgreSQL connection type and select OK.
- For MySQL, if its driver cannot be found, the Add Driver dialog is displayed. Select Add to select the MySQL driver jar file from your local disk. Then select OK and the driver will be loaded into the MySQL connection plug-in.
- The Connect to Oracle, Connect to MySQL, Connect to SQL Server, Connect to InterSystems IRIS, or Connect to PostgreSQL dialog appears (below shows a sample dialog).
- The Driver drop-down list displays the driver included in the connection plug-in by default.
- For Oracle, choose whether to use Service Name, SID, or TNS to connect to the database from the Connection Type drop-down list.
- Type the host name or IP address of the database server in the Server text box.
- Type the port of the database server in the Port text box.
- For Oracle, specify the database instance in the text box that corresponds to the connection type. Logi Report Designer will connect with the specified database instance by default. If you select to connect to the Oracle database server using the TNS connection type, you can specify the TNS either by inputting the definition of the TNS entry, or the alias of the TNS entry if you have defined the alias in a tnsnames.ora file.
For MySQL, specify the name of the database or schema in the Database text box that you want Designer to connect with by default.
For SQL Server or PostgreSQL, specify the name of the database in the Database text box that you want Designer to connect with by default.
For InterSystems IRIS, specify the namespace in the Namespace text box that you want Designer to connect with by default.
- Specify the user ID and password used for accessing the database in the User and Password text boxes.
- Select Show URL if you want to view the URL that is formulated by the information you have provided. You can see the URL in the URL text box. You can also specify the valid JDBC URL in the URL text box to establish the connection to the database server. The URL format is regulated by the driver itself.
- Select the Test Connection button to test whether the specified information is correct for setting up the connection.
- Select the More Options button if your database has special requirements to modify the options accordingly.
- Select OK and Logi Report Designer adds the connection in the specified catalog data source in the Catalog Manager.
You can then add DBMS objects from the database into the Logi Report catalog via the connection.
Notes:
- If your MySQL database server is configured to use SSL, you need to make sure the URL you provide contains SSL information, for example,
jdbc:mysql://<host>:<port>/test_db?useSSL=true&clientCertificateKeyStoreUrl=C:\SSL_Client\ca-cert.pem&clientCertificateKeyStorePassword=1234 - If you want to use alias to specify TNS, you need to add the
-Doracle.net.tns_admin=<folder-containing-tnsnames.org-file>Java VM property in the file JReport.bat which is located in<designer_install_root>\binbefore starting Designer.