Thanks for your response Robert however this is not the information I am trying to extract. 

The 'Ens.Config.Credentials' table was simply an example in my request, sorry if i confused issues.

I am after information stored in the Manage Portal under

System > Configuration > SQL Gateway Connectons

These details are not kept in the 'Ens.Config.Credentials' table.

many thanks

Jonathan