• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

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:https://support.google.com/googleplay/android-developer/answer/6071616?hl=en&ref_topic=3450988
Facebook: https://developers.facebook.com/docs/payments/developer_reports_api/?ref=cr
iTunes connect: http://www.apple.com/itunesnews/docs/AppStoreReportingInstructions.pdf

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,
1 Solution
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.
PutochAuthor Commented:
Thank you ste5an. I will look into this using SSIS perhaps its my best shot.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now