With the increasing popularity of Sharepoint sites in a lot of shops, wouldn’t it be great to have an easy way to extract data from your Sharepoint lists!? …Well yea. That would be awesome! Fortunately, Pragmatic Works offers such an option for you. Ever since December of last year, Pragmatic Works’ Task Factory product has offered a Sharepoint Source component as one of over twenty-five tasks and components that were developed to make your life, as an SSIS developer, a whole lot easier.
If you find yourself wanting the take Sharepoint Source for a test drive, here are some steps to get you started. Once you’ve added the Task Factory items to you Data Flow and Control Flow items, the setup required to begin pulling data out of your Sharepoint lists is very simple. First, drag over the “TF Sharepoint Source” from your toolbox.
From there, double-click on the source to configure. First you’ll need to create a new connection or you can select an existing one. To create a new connection you’ll need to provide the server URL and the username and password you are going to use to access sharepoint.
Next, you’ll select the list that you want to query.
And lastly, if there is a specific view for the list you selected and you only want to pull the fields that are in that view, you have the option to use a specific view.
You do also have the option to filter your results, kind of like a WHERE clause.
After you’ve configured the connection and set any filters you would like, you can preview the data and see what it will look like when it comes out of Sharepoint.
And there you have it! Now you can do any data cleansing or manipulation you need and load it into your database. Pretty snazzy.