Using FME2018.1 and SQLcreator reading attributes from an Oracle database, the attribute names always are in uppercase (although written lowercased in the SQL-select statement). Is there a way to avoid forcing the names to uppercase (I know the use of attributemanager or bulkattributerenamer, but am looking for a way to just leave it as specified by my SQLselect-statement)? Is there e.g. some ..\\FME\\2018\\metafile-file where one can parameterise the behaviour?
SQLCreator forces uppercase attribute names
Userlevel 4
- 8177 replies
-
12 February 2019
Oracle defaults to upper case column names unless you use double quotes to force the case, so this is not specific to FME. Since attributes in FME are case sensitive, they are created exactly as returned by Oracle.
Example using a column alias to force lower case in query result:
select my_column_1 as "my_column_1"
from my_tableWill be interpreted by Oracle as:
SELECT MY_COLUMN_1 AS "my_column_1"
FROM MY_TABLEYou can then expose my_column_1 in FME.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.