Hi Deepika Mehta,
Yes it is possible to connect to Sharepoint and there is a module in market place- https://marketplace.mendix.com/link/component/119305
For Azure , what data you want to get/ update, You can Make use of Rest call if your data are stored in Azure Blob storages. You can go through Microsoft docs for Connecting blob storage with Rest API’s.