ODBC Adapter Limitations

• Supported Types
• Common to all processing
• Read Table
• Execute Select SQL
• Write table
• Execute Update SQL
• Main exceptions

Supported Types

Common to all processing

Specification Limits

Notes

• ODBC data source need to be pre-registered.

Read Table

Specification Limits

• Depending on the connecting database, some functions may not be available.


• If column names which need to be enclosed in double quotes are specified in the [Target] of [Schema definition], error will occur.
  However, this will not apply if all columns are selected.

Execute Select SQL

Specification Limits

• Depending on the connecting database, some functions may not be available.

Write table

Specification Limits

• Depending on the connecting database, some functions may not be available.


• If column names which need to be enclosed in double quotes are specified in the [Schema definition] of [Target] or as [Key], error will occur.


• Getting keys automatically is not available.
  If you want to update the rows that match with the keys, select "true" in the key of schema definition.

Execute Update SQL

Specification Limits

• Depending on the connecting database, some functions may not be available.

Main exceptions