SQLTeam.com | Weblogs | Forums

Facebook data


#1

Hi,

I would like to import facebook data (post, likes, ... ) to SQL Server for further analysis. Is there any example on how to do it?
I know the way with API, but I haven't find any good samples that demostrate how to do it.

Please, if anybody has any idea to share it.

Thank you
Borut


#2

Have you tried bringing the data in with Power BI https://powerbi.microsoft.com/en-us/? PowerBI works through excel and has great connection features. Then you could save the information off to .csv and import?

From what I am gathering, if you want to connect via SSIS, you would need to do some coding on the connection options for the API.