Synthesizes cyclic ADP-ribose (cADPR), a second messenger for glucose-induced insulin secretion (PubMed:7961800, PubMed:8253715). Synthesizes the Ca(2+) mobilizer nicotinate-adenine dinucleotide phosphate, NAADP(+), from 2′-phospho-cADPR and nicotinic acid, as well as from NADP(+) and nicotinic acid. At both pH 5.0 and pH 7.4 preferentially transforms 2′-phospho-cADPR into NAADP(+), while preferentially cleaving NADP(+) to cADPR and ADPRP rather than into NADDP(+) (PubMed:16690024). Has cADPR hydrolase activity (PubMed:7961800, PubMed:8253715).