Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Video Gallery
How do you load SQL that joins multiple tablesand performs functions prior to output?