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