DataSync settings are accessed from the Gear menu

   
The Metadata page controls how DataSync handles the case of the target table's metadata
 

 

CONNX by default uses quoted identifiers when creating target tables. If column or table names are mixed-case, then double quotes must be used to refer to them in SQL statements.

However, it may make more sense for the target metadata to be in all uppercase, or all lowercase.

• If Oracle metadata is in all uppercase, then it is treated as a case-insensitive identifier and double quotes are not needed.

• If PostgreSQL metadata is in all lowercase, then it is treated as case insensitive.

CONNX Data Synchronization allows you to choose the case for the target metadata.

• Target Metadata Case
  

• • Keep metadata case the same
    Metadata on target will be unchanged
    

  • Force target metadata to uppercase
    Metadata on target will be in uppercase
    

  • Force target metadata to lowercase
    Metadata on target will be in lowercase