SQLTeam.com | Weblogs | Forums

Facebook data



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


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.