ArcSDE Case Sensitivity | Attributes Not Written Correctly to ArcSDE

Symptoms

Data is not correctly written to the ArcSDE database. Attribute names have changed case and/or attribute values are null or missing.

Cause

The data being written into the ArcSDE database does not match the preferred case. Attribute names must match database preference, for example Oracle uses UPPERCASE while PostgreSQL uses lowercase. SQL Server uses Mixed Case as noted in this ArcSDE question.

Development is aware of the issue, PR#11319.

Workaround

Use the BulkAttributeRenamer to change the case of the attribute names and set the Writer Feature Type Definition to Automatic or Manual when adding a new feature type.