To connect to a Sharepoint datasource, start by adding the Sharepoint node to the data flow. With the node selected, go to the Properties panel. Select the required Sharepoint server from the drop-down list. The list exposes the Sharepoint sources that have been configured in Pyramid by an Admin. If the required Sharepoint source doesn't appear in the list, you can add it if you are an Admin user.
Next, select the required Sharepoint database from the second drop-down list.
To perform data ingestion, go to the Tables window and select the tables that you want to copy from Sharepoint and add them to the data flow.