SAP database?

Is there any experience with implementing chemical awareness in SAP databases? Our product/stock management at university is SAP based and I would like to see structure searching implemented there. I'm not an ICT person myself, just a plain chemist, so please excuse me if this is a silly question.

Wim,

What database type are you using in your SAP solution?

I'm guessing Oracle, so probably your best bet is to check out the JChem Cartridge.

https://www.chemaxon.com/products/jchem-cartridge/

 

Online you can read the installation guide

https://www.chemaxon.com/jchem/doc/admin/cartridge.html

and the users guide

https://www.chemaxon.com/jchem/doc/dev/cartridge/index.html

 

For example, you could run a search like this to return the IDs of a structure that matched the query SMILES string:

select id from plaintable where jc_contains(structure, 'CN1C=NC2=C1C(=O)N(C)C(=O)N2C') = 1;