His side's 20-16 victory ended a run of seven consecutive defeats for the Welsh region and seven wins in a row for Connacht.
It was only the third home league match of the season for Blues, and Wilson hopes it can lead to improved form.
"Hopefully it's given us a springboard to build some confidence," he said.
"I'm relieved after the last seven minutes of that game, but pleased with a big effort form the players to beat the league leaders."
Wilson believes the lack of home games has been a factor in the Blues' poor start to the Pro12 season.
"It's only our third home game of the season and people forget that and we've had two wins at home and a loss to Glasgow.
"We've talked about building that home record and if we are ever to give ourselves a chance to get where we want to be we have got to be winning at home."
The Blues' Cardiff Arms Park ground was out of commission during the Rugby World Cup when it was used as a fanzone.
It meant the Blues playing five of their opening seven Pro12 matches away from home - and losing all of them.
The former Wales Under-20 coach says it is important for his players to bond around the victory.
"I want the boys to have a beer and get that winning feeling back," he added.
"Winning pulls the squad together.
"It's not coming to work on a Monday on the back of another loss because that can get negative.
"We can gel from this win - pull together and get close and enjoy it. When you get the win you cherish it and build on it."
Cardiff Blues' win over Pro12 leaders Connacht can act as a springboard for the rest of the season, according to head coach Danny Wilson.