Data Transfer - Data Source/Destination "JDBC"
Here you will find instructions for configuring a data transfer if, in the first step of creating the connection, you selected "JDBC" as the data source type or data destination type.
Source / Target - JDBC Database
This dialog is used for the source and, if you selected "JDBC" as the destination in the previous step, also for the connection to the destination database.
Enter the drivers, the URL, and the time zone here, and enter the login credentials for the database connection in the "Authentication" tab at the bottom. On the "Connection Parameters" tab, you can specify driver-specific parameters.
INTREXX GmbH assumes no liability for errors caused by incorrect connection parameters entered in this dialog box.
To configure the connection, you can also use a wizard that will guide you through the process. To do this, click the "Wizard" button to the right of the URL field. However, there is no guarantee that every external data source will be supported by the wizard.
Click "Next" once you have entered the connection parameters. For some source types, such as a PostgreSQL database, you can select the desired database in the next step.
In the final step, you can complete the configuration of the data transfer connection by clicking "Finish."
"JDBC" as the target
If you have selected the "JDBC" type as the destination in the data transfer configuration, you can create an SQL query in the "Transformation - Field Mapping" dialog by clicking " 
" and then "Add Query."
SQL Query in the Target
If you want to import filtered data, you can create a target query here. The query result can then be mapped as usual in the field mapping.
Enter the name of the SQL query here.
"Standard Catalog" tab
Select the desired item here.
"Search" tab
Here, you can search for specific tables. 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 the selected table
Select the column you want here.
Available source fields for comparison
Here, you can select the fields from the source whose values you want to compare.
Clicking the " 
" arrow button automatically adds the selected object to the query.
Query
Here you can see the query that is automatically generated based on the objects selected above. When formulating the query, please use the correct, database-specific syntax.