When you use the JDBC V2 connection, some rules and guidelines apply while you import data or configure queries.
Consider the following rules and guidelines for JDBC V2 data objects:
When you import the JDBC V2 object metadata, you cannot import synonyms.
You cannot select the JDBC V2 connection from the Connection Explorer.
When you add resources while importing the JDBC V2 data object, the advanced search is disabled. Type the table name in the
Name
field in the
Add Resources
dialog box to search the table.
If the schema of the tables is modified in the JDBC V2 database, you cannot synchronize the data objects. The synchronize option for the data object in the object explorer is disabled.
Insert and truncate queries configured for data objects in mappings that run on the Spark engine are not logged in the Spark logs.