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?
Question
SQLCreator forces uppercase attribute names
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.