Solved

Using SSIS to connect to the Facebook API to load data to a SQL Server db.

Posted on 2014-11-04
6
644 Views
Last Modified: 2016-02-11
Hi There,
Has anyone experience in using SSIS when connecting to the Facebook API?
I have very little experience in this, but I'm I've been trying to follow some websites.
One website directed me to a RSSBusFacebookConnectionManager add in for SSIS -
I tried using this - but ive been getting some errors about my connections.
However this is only a trial version.

what I would really like to do is use the Script Task tool so that will call facebook api using SSIS.

Has anyone does this before/ if so could you give me some guild lines on what steps I should take please?
Thank you!!
P
0
Comment
Question by:Putoch
  • 4
  • 2
6 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 40424016
Which one are you using? "RSSBus ADO.NET Provider for Facebook"?
Regardless of trial/full the connection must work - can you post the error you are getting? Remember to scratch any confidential info if any.
Do you have the token and properly configured the connection string in Connection Manager as described below?

http://www.rssbus.com/kb/help/RBS1-A/pg_connectionr.rst
0
 

Author Comment

by:Putoch
ID: 40424175
Hi there, I downloaded the RSSBus SSIS Components For Facebook Provider V2.

so I setup the configuration, to look at one app only, rather than our whole company.
So I added the app id, the secret id, got the access token, and added the callback url (I used our canvas page)*

*Under the settings of the app, I could not see anywhere that reflected the word 'callback url'
this is why I used the canvas page url. But I noticed the app domain that was in our settings are different to the url used for our canvas page url
Also the canvas url was different to the canvas page url. Does this all matter?

The error I am getting back now is about an active access token.
I don't understand this, as I only ran the command to get the access token.

(replacing actual id with XX)
https://graph.facebook.com/oauth/access_token?client_id=XXXXXXXXXXXXXXXXXXX&client_secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX&grant_type=client_credentials

Thank you.
Facebook-oauth.png
Error-Message.png
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 40424248
"The error I am getting back now is about an active access token. "

I assume you copy/paste the token in the Connection Manager right? I have sometimes issues due to the Clipboard copy as Unicode or UTF8 char then when paste garbage will mess up the actual string - please try paste in a pure text first then take the token from there and put it in connection manager.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Putoch
ID: 40424584
Ok, thank you, I took your advice and redid that. It seems that the token access I had copied was a little off. But the new error message I am receiving is a little different.
I think it may have something to do with the call back URL.
 
I'm not sure exactly what URL is a ''Call back url''
There is no website url on my facebook app settings for me to copy
the only urls' available are
the domain url
the canvas page
the canvas url
Page tab url
Secure page tab url

I'm unsure what to use, Would you have any advice?
Error-2.png
0
 

Author Comment

by:Putoch
ID: 40424638
Just to add, there was no platform for website on my app settings.
I wonder is this an issue?
Only for Canvas page,
iOS
Android,
Page Tab

Do I need a website platform?
What URL would I have to add there, since the app is based on Facebook and mobile devices only
Thank you
0
 

Author Comment

by:Putoch
ID: 40439035
i create a new platform and appid for auth purposes only
but instead of using the app token access key I used the client token
this seemed to work for now.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
An overview of how to create reports in Adobe Analytics (formerly Omniture Site Catalyst) using pageNames, events, eVars and props. This video will show you how to install the Omniture Debugger tool so can see (and test) what is being passed int…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question