I have to support both Oracle DB and PostgreSQL in my workflow. All identifiers in Postgre are for some reason lower-cased whereas the same objects in Oracle DB have upper-cased identifiers. My workflow works pretty well in Oracle. Now I invoked just a few initial nodes and I’ve learned it’s going to be difficult.
First, DB Table Selector claims data object does not exist. I’ve read somewhere in this forum, KNIME sends all DB objects identifiers quoted so that it would support identifiers that contain spaces. Well, I’d coin people who use spaces in DB identifiers deserve solving problems these results, whereas people who don’t should benefit from the fact DB identifiers are case-insensitive (unless you intentionally force your database to behave case-sensitive).