CONNX Data Integration Suite 14.8.0 | DataSync | Settings Menu | Handling Metadata Case
 
Handling Metadata Case
DataSync settings are accessed by clicking Gear Icon -> Settings.
By default, CONNX uses quoted identifiers when creating target tables. If column or table names are mixed-case, then you must use double quotes when you refer to them in SQL statements.
However, it may make more sense for the target metadata to be in all uppercase, or all lowercase. For example, if Oracle metadata is in all uppercase, then it is treated as a case-insensitive identifier and double quotes are not needed. PostgreSQL metadata in lowercase is also treated as case insensitive.
CONNX Data Synchronization allows you to choose the case for the target metadata. The possible options are
*Keep metadata case the same
*Force target metadata to uppercase
*Force target metadata to lowercase