How can I achieve that ?
Depends. What version of SharePoint and what do you want to do with the connection?
I have SharePoint 2013 hosted on our company local server and I need to read a list and do some BI based on its data
See How to Connect QlikSense to a 2013 SharePoint List
Retrieving data ...