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?
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_table
Will be interpreted by Oracle as:
SELECT MY_COLUMN_1 AS "my_column_1"
FROM MY_TABLE
You 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.