JDBC data sources
Create new connection
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.
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.
Data source column
The name of the connection
is shown here.
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
- Keep Alive: 30000
- Listen All: Yes
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