Secular singer says he reached musical enlightenment when he read the ancient Hebrew prayers for his new album 'Tefila,' commissioned by Temple Emanu-El to attract new audiences