Your question is very general query, the solution may be various depend on many situation. e.g. if the execution of SP is just in seconds and return a small data set, then live connect may be a good option. While if the SP takes minutes to run, probably using custom query and extract data regularly is a better solution. So it really depends on your demand and leverage with your system basis.