If you require to read a file from Microsoft SharePoint and load it into some database or any other flat files then you can use IICS standard Microsoft SharePoint online connector.
You need to create a connection first but before that you need to generate below 4 things which are required while creating a connection. You can ref this link for more details Administration of Microsoft Sharepoint Online Connector (informatica.com)
1. Generate the client ID and client secret2. Generate the bearer realm of your site
3. Generate the authorization code
4. Generate the refresh token
Once you have everything ready let's create a connection and test it.
You can use this connection in mapping or synchronization tasks.
You may think that I will connect directly to a file that is present in some location in SharePoint but that is not TRUE! You need to know a few things more about this connector.
When you select this connection in source transformation, it will list out all the objects, so you need to select any of them.
And in the target, you need to select the local directory or Amzon S3 bucket connection, where all these files get downloaded first.
When you run the mapping or task, the selected object gets downloaded into your local directory. And if your object contains many files or subfolders then it will download all files from the main folder and subfolders.
Then you need to create another mapping with a flat-file connection and read the required file from the local directory and then load it into the target.
Few useful links for your ref.
If you have any doubt feel free to comment.
