Connacht secured a home semi-final in the Amlin Challenge Cup with a tremendous last-quarter fight-back against Bourgoin in brilliant sunshine at the Sportsground.