Why did he do it?
He did it for a trade routes, his goal was to find a North East passage to Asia from Europe. Also partly for Glory he was a well known explorer and wanted to keep his reputation up.
Were his travels fails?
Yes, He went out to look for a way to Asia through the North East and never could. He discovered the Hudson Bay and the Hudson River but his true goal was never reached.
Who funded his travels
His third voyage was funded by the Dutch East India Company. They would take him to the Bay and River named after him.