Microsoft Azure PlayFab logo
    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Add-ons
    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA
  • Runs on PlayFab
  • Pricing
    • Blog
    • Forums
    • Contact us
  • Sign up
  • Sign in
  • Ask a question
  • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges
  • Home /
  • General Discussion /
avatar image
Question by BenMadsen · Jan 02, 2019 at 08:48 PM · dataanalytics

What would be the best way to sync user database with external analytics database?

Our analytics team would like a way to keep the analytics database user table in sync with PlayFab's user data. We are looking at various options, but wanted to know if there was a recommended way to do this since there is no current (or performant) way to "dump" the user table data or certain sections of it so that it could be imported into our analytics database.

Comment

People who like this

0 Show 0
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

1 Reply

· Add your reply
  • Sort: 
avatar image
Best Answer

Answer by SethDu · Jan 03, 2019 at 04:16 AM

For Essential and indie Tier users, a feasible solution is store/update every player information in the database when they login successfully. After a period of time, your team should gather a database of active players of your title.

However if you are professional or enterprise tier customers, you can create a ticket via devrel@playfab.com to ask for help.

Export of all data from PlayFab is not supported, outside the Enterprise tier. We can provide a one-time dump of all data if you choose to leave PlayFab, and we do provide you with the ability to receive 100% of your event data. But reading out 100% of all player data for (potentially) millions of players would be quite expensive, and we work hard to keep costs down, so that we can provide the lowest pricing possible to everyone. Please see Brendan's reply on this thread.

Comment

People who like this

0 Show 2 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image BenMadsen · Jan 03, 2019 at 04:24 AM 1
Share

We're on Enterprise tier, so I sent a request over to devrel. Thanks! I'm always a little hesitant to go private with some of these requests as I feel like a lot of them could benefit the community.

EDIT: and I'm not sure how I missed that other one. I guess I was a little light on my search foo.

avatar image Brendan ♦♦ BenMadsen · Jan 04, 2019 at 09:16 AM 0
Share

So, from our offline thread (for others): For event data, the Event Archive would be the best bet, since it guarantees deliver of the events to your S3 bucket. We'll be offering additional options with the Azure Data Explorer option as we roll that out. For other data (like Player Data), you'd need to send that to your own backend in parallel to the call to send it to PlayFab. You can also potentially use Cloud Script for that, writing data for players to your own servers via a Scheduled Task, but it's important to bear in mind that Cloud Scripts have limited runtimes, so if your own server is delayed on the response, that could cause the script to time out.

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Navigation

Spaces
  • General Discussion
  • API and SDK Questions
  • Feature Requests
  • PlayStream
  • Bugs
  • Add-on Marketplace
  • LiveOps
  • Follow this Question

    Answers Answers and Comments

    3 People are following this question.

    avatar image avatar image avatar image

    Related Questions

    Identifying PlayFab player segments in Snowflake 1 Answer

    I created two custom events - how can i see data based on that inner json body? 1 Answer

    Dashboard->Trends Platform categories 1 Answer

    Event Archive for DEV and LIVE environment 1 Answer

    Can Playfab connect to any DW for analytics, or is it limited to Azure/Snowflake?,Can Playfab connect to other Cloud DW for Analytics than Snowflake or Azure? e.g. BigQuery 1 Answer

    PlayFab

    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Runs on PlayFab
    • Pricing

    Solutions

    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA

    Engineers

    • Documentation
    • Quickstarts
    • API Reference
    • SDKs
    • Usage Limits

    Resources

    • Forums
    • Contact us
    • Blog
    • Service Health
    • Terms of Service
    • Attribution

    Follow us

    • Facebook
    • Twitter
    • LinkedIn
    • YouTube
    • Sitemap
    • Contact Microsoft
    • Privacy & cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2020
    • Anonymous
    • Sign in
    • Create
    • Ask a question
    • Create an article
    • Post an idea
    • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Explore
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges