RDKit Cartridge Insert Molecules

0 ×

Insert rows into an existing PostgreSQL table with a rdkit mol column from the RDKit cartridge.

The component requires the Python envrionment to be configured correctly and psycopg2 (PostgreSQL moldule) to be installed in this envrionment.

The input table must contain 1 rdkit molecule column and all other columns that need to be inserted. The column naming must be an exact match to database column names (case-sensitive).
Date/time handlng was only tested for timestamp column + KNIMEs Local Date Time type.

Options

Molecule Column:

Select column with chemical structures

Port:

Table:

Fully qualified table name

Host:

Database:

username:

Password:

Nodes

• String Configuration5 ×
• Merge Variables2 ×
• Column Selection Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• Show all 8 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Python 2 Integration (legacy)
• FeatureKNIME Quick Forms

Links

• No links available