Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2014-11-04
6
Medium Priority
?
799 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 1500 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
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!

 

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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ranking ecommerce websites is a vital process. You need to have a strong SEO (Search Engine Optimization) strategy. If you don’t have one, you are losing out on brand impressions, clicks and sales. Check this guide on how to improve website traffic …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
Suggested Courses

571 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