Catalysis of the reaction: NAD+ + H2O = nicotinamide + ADP-ribose without proceeding through a cyclic ADP-ribose intermediate.