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

Posted on 2014-08-13
Last Modified: 2014-08-15
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,
Question by:Putoch
    LVL 32

    Accepted Solution

    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.

    Author Comment

    Thank you ste5an. I will look into this using SSIS perhaps its my best shot.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Working settings for French ISP Orange "Prêt à Surfer" SIM cards for data connections only. Can't be found anywhere else !
    You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now