View Single Post
  #6 (permalink)  
Old September 12th, 2017, 09:48 AM
nancyrai37 nancyrai37 is offline
Registered User
Points: 6, Level: 1
Points: 6, Level: 1 Points: 6, Level: 1 Points: 6, Level: 1
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: Aug 2017
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Smile

@John

Yes, you are correct.....

You have to use REST API for import Facebook data to SQL.

But how....

For this, I am sharing you an Article called SSIS Facebook API Integration.

Go through it where will learn how to get data from Facebook using Graph API (OAuth 2.0) using SSIS PowerPack REST API Connectors. Facebook provides a rich set of REST API to access data. Their REST API is also known as Facebook Graph API and it uses OAuth 2.0 Authorization. Traditionally any REST API Integration scenarios in SSIS requires you to use some sort of SDKs using popular programming languages (e.g. C#, Java, Ruby, Python). If you are DBA or SSIS Developer and you prefer to use clean drag and drop approach rather complex programming then this article will show you how to achieve it.

Hope it will help you.....
Reply With Quote