I think you need to be much more specific about what you mean by "Business Analytics solution" to get a complete answer, but yes it should be possible. You could use Splunk DB Connect to query the SQL server for data and then process it in Splunk. Address security by indexing as little HBI/MBI data as possible and restricting access to that which is indexed.