Data transfer - Source - Database query / Target - Target table

You can reach this dialog in the following ways:
Integration module Data transfer / Create new connection Data source type: JDBC, Continue to Source - Database query
Integration module Data transfer / Create new connection Target type: JDBC, Continue to Target - Target table

Standard catalog tab

Select the desired object.

Search tab


Filter

You can search for specific tables here. Simply enter the corresponding search term.

Search
Triggers the search.

Search all catalogs

The search is performed across all catalogs.

Catalog column

The name of the catalog is shown here.

Schema column

The name of the schema is shown here.

Name column

The name of the object is shown here.

SQL 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.

Test

Tests the query.