DB Writer node and SDF molecules

Hi all
I’m using KNIME Analytics Platform 4.7 and I’m trying to write a table with an SDF column and some string columns in an ORACLE DB table (new or existing, I obtain the same error message).
When I execute the DB Writer node I obtain “execute failed. Output type mapping is missing for Molecule(SDF).” There is a way to pass to the DB Writer the correct mapping?

You probably just need to convert the column to type string before using the DB Writer node.
Try the string(x) function in the String Manipulation node.
And for the other direction, the Molecule Type Cast node will convert string to several chemical types.

(the other)
Simon

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.