JDBC data sources

All Intrexx applications are based on data. This data is either stored in the internal Intrexx database or comes from databases used by third-party products. This approach gives you almost universal access to databases in your company. JDBC is a protocol for accessing databases. Accessing your external databases requires the use of a suitable JDBC driver. Almost every database system offers such a driver. A wizard guides you safely through the process of integrating a data source.

Whenever one of the existing connectors does not fit your case, you will achieve success in almost every case by integrating the database. Even if you have very old systems in your company, this connection gives you the opportunity to "retrofit" these systems and make them browser-compatible with a modern interface. You always access your data assets in real time. Consequently, no synchronization of the data is necessary.

The connector allows write access and also display of date values in the correct time zone. Once a data source is registered, you can edit the data in processes and build any applications on it.

New FileWalker

Selecting "Data source / New data source" from the main menu opens a wizard in which a new JDBC connection can be created. This option is available if JDBC data sources is selected under Consume data on the left-hand side. In each configuration dialog, you can reach the corresponding Intrexx Help by pressing F1 or by clicking on the "Help" button.

Edit file storage location

Every JDBC connection created by you is listed in the right-hand area. All of the functions available for editing a connection can be reached via the "Data source" menu, when an existing connection has been selected on the right.

"Source" column

The name of the connection is shown here.

"Type" column

The database type is shown here.

"Database name" column

The name of the connected database is shown here.

"Data groups" column

The number of data groups, which are integrated into applications as external data groups, is shown here.

Portal database connection

In every portal, you will find the IxSysDb connection; this is the JDBC connection to the system database of the portal.

So that a JDBC connection works correctly, TCP/IP needs to be activated in the Microsoft SQL Server database and the dynamic ports need to be defined. Configure the Server TCP/IP accordingly if you are using a remote database server. To do that, open the Microsoft SQL Server Configuration Manager. You will find "Protocols for [name of the instance used by you]" under the point "SQL Server Network Configuration". Activate TCP/IP on the right-hand side. Then open the TCP/IP properties. On the "Protocol" tab, the following settings should be made:

  • Enabled: Yes

  • Listen All: Yes

  • Keep Alive: 30000

Then switch to the "IP Addresses" tab. The following settings should be made here:

  • Active: Yes

  • TCP Dynamic Ports: 0 (can also be left blank depending on the configuration)

  • Port used for establishing the connection (Default: 1433)

Restart the SQL Server Service and then the SQL Server Browser Service via the SQL Server Configuration Manager / SQL Server Services. Should the connection still not work with these settings, please refer to the corresponding pages from the developer.