Link to home
Start Free TrialLog in
Avatar of Putoch
PutochFlag for Afghanistan

asked on

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,
P
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Putoch

ASKER

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