Data Transfer - Data Source / Destination "Registered JDBC Data Source"

Here you will find instructions for configuring a data transfer if, in the first step of creating the connection, you selected "Registered JDBC Data Source" as the data source or data destination type.

Source / Target - Registered JDBC Data Source

This dialog is used for the source and, if you selected "Registered JDBC Data Source" as the destination in the previous step, also for the connection to the destination database.

Select the desired data source here and click "Next."

Source / Destination - Database Query

"Standard Catalog" tab

Select the desired item here.

"Search" tab

The filter allows you to search for specific tables. Clicking "Search" on starts the search.

When the "Search all catalogs" option is selected, the search is performed across all catalogs.

The name of the catalog is displayed here.

The table below the filter displays the names of the catalog, schema, and object.

Below, you'll see the SQL query that is automatically generated based on the objects selected above. When formulating the query, please use the correct, database-specific syntax.

Click "Test" to test the query. Click "Next" to complete the configuration.

More Information

Data Transfer

Create a connection

Target Options

Transformation Field Mapping

Schedule

Follow-up orders

"Data Transfer" Application