CData SharePoint SSIS Components

ByHariharan Rajendran

CData SharePoint SSIS Components

I had a requirement to extract the data from SharePoint (only Metadata) and I was looking for a task to handle this in SSIS.

Then I found a simple 3rd party plugin to fulfil my requirement. In this post, I am explaining how to use the CData SSIS components.

You can download the component from https://www.cdata.com/drivers/sharepoint/ssis/.

The above link will take you directly to the download page. You need to buy this tool to use it on your production packages. If you want to test, then you can go with a trial version.

Download and install where you installed the SQL Server Data tools.

Once you installed then you can start creating an SSIS package using CData SharePoint Source and Destination tasks.

You need to create a connection manager to speak with on your SharePoint server either on-premises or online.

Right click on the connection manager section and choose “CDATA_SHAREPOINT”.

You need to enter your SharePoint site URL and credentials.

Once everything is done then drag and drop the “CData SharePoint Source” task. Point the created Connection manager. Under Table or View, you can choose any of the resources from SharePoint.

Check the columns and ensure everything is working. Then you can map the output to the destination tasks.

About the Author

Hariharan Rajendran author

Hariharan Rajendran is a Microsoft Certified Trainer and Lead BI Solutions Consultant with 8+ years of experience in Database, BI and Azure platforms. Hariharan is also an active community leader, speaker & organizer and leads the Microsoft PUG (Power BI User Group – Chennai), SQLPASS Power BI Local Group – Chennai and an active speaker in SQL Server Chennai User Group and also a leader in Data Awareness Program worldwide events. Hariharan also frequently blogs (www.dataap.org/blog), provides virtual training (on ad-hoc basis) on Microsoft Azure, Database Administration, Power BI and database development to worldwide clients/audience.

Comments Are Closed!!!