JDBC is a protocol for accessing databases. To access your external databases, you'll need a compatible JDBC driver.
A JDBC connection can be created in the "Integration" module. A wizard will guide you through the configuration process.
You can access data in real time using a JDBC connection. The connector allows you to write to and view date values in the correct time zone. Once a data source has been registered, you can process the data in processes and build any applications based on it.
For each portal, you will also find the JDBC connection to the portal's system database here under the data source name "IxSysDb."
The system database contains system tables whose names begin with
- LC
- DS
- VDS
Please do not modify these tables!
Changes to these tables, as well as custom views created for them, are not update-safe.
All existing JDBC connections are listed in the right-hand pane.
You can access all editing functions via the "Data Source" main menu or the corresponding context menu when an existing connection is selected. In addition to the name of the data source, the database type, and the database name, the number of external data groups in which the JDBC connection is used is also displayed here.
Requirements
For a JDBC connection to function properly, TCP/IP must be enabled in the Microsoft SQL Server database, and the dynamic ports must be configured. Configure the server's TCP/IP settings accordingly if a remote database server is used.
To do this, open Microsoft SQL Server Configuration Manager. Under "SQL Server Network Configuration," you'll find the protocols for the data source you're using listed by name. Double-click the name.
Enable TCP/IP in the right-hand pane. Open the TCP/IP Properties. The following settings should be configured on the "Log" tab:
-
Enabled: Yes
-
Monitor All Yes
-
Receive 30,000
Go to IP Addresses. The following settings should be configured here:
-
Active: Yes
-
Dynamic TCP ports 0 (or blank, depending on the configuration)
-
Port through which the connection is to be established (default: 1433)
Restart the SQL Server service and then the SQL Server Browser service using SQL Server Configuration Manager / SQL Server Services. If the connection still does not work with these settings, please check the manufacturer's website for more information.