I'm discovering Instant JChem in order to answer one question: Can I do with Instant JChem, what I'm doing in Java using JChem API.
Basically, I'm working with two databases, one is a source for tools and the second source and output.
From the first database I read a small table (structure are stored as MDL Molfile in Clob field) and store all structure as Molecule object in an java Array.
Then in the second database I process all the structure (stored as MDL Molfile in CLOB field). The process convert String molecule to Molecule object and detect fragment using the first table. I remove the identified fragment from the molecule object and extract data which I store in a new fields (as for example a new CLOB field to store format of new structure without identified fragment).
I didn't see any possibility in Instant JChem to have a relation between two schema (two databases).
Is it possible to load SDFile has array of structure and use it to detect fragment from a structure table?
When I need to write the result of transformation (e.g. strandardizer) can I write it as output in a field of a table or do I always need to write output SDFile?
Can I do the same things using Groovy script as I'm doing in java using JChem API?
Is it possible to use java classes or java script in Instant JChem as plugins?
Thank you very much for your help?
Thank you ver