Facebook data with SSIS

Question

Post reply

Facebook data with SSIS

Borut Olenik

Old Hand

Points: 399
More actions
January 5, 2016 at 3:08 pm

#307426

Hi,
Did anyone ever tried to import facebook data to SQL with SSIS? I know that I have to use API. Can anybody share a sample?
Thanks
Borut

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Eric M Russell SSC Guru Points: 125596 More actions · Answer 1

PragmaticWorks TaskFactory has a 'Facebook Source' task.

http://help.pragmaticworks.com/taskfactory/

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Borut Olenik Old Hand Points: 399 More actions · Answer 2

Thanks. But I need something that is Free.

BR, Borut

pietlinden SSC Guru Points: 63594 More actions · Answer 3

You can query Facebook with PowerBI and then once it's there, probably import that using SSIS.

Borut Olenik Old Hand Points: 399 More actions · Answer 4

Yes.That was my though. But there is no direct link between Power BI (Power Query) and SQL.

I was thinking (beside using API) to:

1. Import in Power Query

2. Load to Excel

3. Load Excel to SQL

BR, Borut

rpdouglas SSC Enthusiast Points: 100 More actions · Answer 5

You could have PowerQuery load a table in excel, create macro to refresh upon open, use windows events to schedule the book to open and refresh, have SSIS read from excel. Kinda wonky but would work.