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
Here is the JMP journal that i shared at our users group meeting yesterday. Feel free to dig through it and if you have any questions about it, please reach out.