[#55453364] Disconnect from remote db when testing crededtials prior to opening workflows

 - connect! creates a connection but does not disconnect - using with_connection will disconnect
   after the passed block
 - Additionally pull the attempt connection logic up to data_source so oracle and jdbc benefit
   from the credentials check