Integrating Facebook insights, iTunes connect data and Google Play stats into a SQL server Database

Hi There,
I had previously asked about being able to integrate and view some mobile app insights from the following sources:
Facebook insights
Admob advertising
Google play developer stats
iTunes connect data

I received some suggestions to use the Localytics or Flurry or cubub,
I had found two also that I've used now and find very good App Annie and Appfigures.

However, now I would like to try and pull the data from these platforms into my own warehouse.
I know Facebook and iTunes offer API's I believe Google Play does also, I've been looking for some information on that:
Google Play:
iTunes connect:

Has anyone setup these API's before to connect to?
i don't know where to begin, I've not done anything like this before,
I am not even sure if i'm meant to download something before starting to pull these "class files".

Would anyone have some online literature that they could direct me to on how to get started with this?
I've been looking up how to use an api to connect to my sql server 2005- but in most cases the write assumes you know what your doing. which I don't unfortunately but i'd really like to give it a go.
I also use SSIS which I was thinking perhaps I can work with while doing this.

Thank you,
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
These APIs only define how to access the data. You need to program it yourself or look for a ready connector (I know only some commercial ones). This means you need .NET or Java or PHP or Ruby to implement the data retrieval and push it to your database.

Another approach would be using SSIS and a script task, which has the same level of complexity. E.g. How to Configure an SSIS Package to Access a Web Service using WCF.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PutochAuthor Commented:
Thank you ste5an. I will look into this using SSIS perhaps its my best shot.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.