JDBC data sources

New FileWalker

Selecting Data source menu / New will open a wizard where 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.