Data transfer - data source / destination "JDBC"
Here you will find the instructions for configuring a data transfer if you selected "JDBC" as the type of data source or type of data destination in the first step when creating the connection.
Source / destination - JDBC database
This dialog is used for the source and, if you selected "JDBC" as the target in the previous step, also for the connection to the target database.
Enter the driver, URL, time zone and the login data for the connection to the database in the "Authentication" tab at the bottom. Driver-dependent parameters can be specified on the "Connection parameters" tab.
INTREXX GmbH accepts no liability for errors caused by entering incorrect connection parameters in this dialog.
You can also use a wizard to help you configure the connection. To do this, click on the "Wizard" button to the right of the URL field. However, it cannot be guaranteed that every external data source will be supported by the wizard.
Click "Next" when the connection parameters have been entered. For some source types, such as a PostgreSQL database, the desired database can be selected in the next step.
In the last step, you can complete the configuration of the data transfer connection by clicking on "Finish".
Type "JDBC" as destination
If you have selected the "JDBC" type as the target in the data transfer configuration, you can create an SQL query in the "Transformation - Field mapping" dialog by clicking on 
" Add query".
SQL query in the target
If data is to be filtered and transferred, you can formulate a target query here. Afterwards, the query result can be assigned in the field assignment as usual.
Enter a name for the SQL query.
Standard catalog" tab
Select the desired object.
Search" tab
You can search for specific tables here. To do this, enter a search term in "Filter".
Search
Triggers the search.
Search all catalogs
The search is performed across all catalogs.
Columns in selected table
Select the desired column.
Available source fields for comparison
The fields from the source, whose values should be compared, can be selected here.
Clicking on the 
arrow button automatically enters the selected object as part of the query.
Query
You can see the request, which was created automatically based on the object selected above, at the bottom of the dialog. Please make sure to use the correct, database-dependent syntax when formulating the query.
Send us an e-mail