connection profile dao and rest api