I am pleased to announce that we have just officially released a set of KNIME nodes that facilitate querying and retrieving data from the ChEMBL bioactivity database via our RESTful web services.
The nodes allow the user to retrieve bioactivity information for a given compound, assay or protein target in ChEMBL. Furthermore, the user can perform similarity, substructure and exact searches.
Further information, including example workflows can be found here.
You can find several related examples in the EXAMPLES Server. Just go to the KNIME explorer panel, login to the server and navigate to 099_Community/08_ChEMBL_WebService. Then drag this folder and drop it on your LOCAL folder. There are enough workflows there to get you started.