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.