Spinify Academy

Get the most out of Spinify, learn proven strategies and master best practices to crush your team's KPIs.

After creating your Spinify Account you can connect directly to your SQL database with Spinify and sync changes to tables in SQL to your leaderboards in Spinify.

Steps to integrate a SQL database

1. Go to the integrations page

  • Log into your MySpinify account
  • From the top-right menu click "Settings"
    mceclip0.png
  • You should automatically land on the Integrations section, but double-check by ensuring the "Integrations" tab is highlighted in orange
    mceclip1.png

2. Connect SQL with Spinify

  • Choose "Connect" on the SQL Integration
  • Fill in the details on the form
      • Name - Description of the query to be used when connecting to leaderboards
      • Database Type - The type of database to connect
      • Username
      • Password
      • Host - Database Host
      • Port - Optional port to connect to
      • Database - Database name to connect
      • Query - Select query or stored procedure to run
        SQLInt.gif
  • Important: The query must return two columns named Email and Score
    • Email corresponds to your participants' email addresses and is used to identify which player the score returned by the query belongs to
    • Score corresponds to the participants' score that you'd like to appear on the leaderboard
  • The column names must match exactly or the data will not sync to your leaderboards.
  • Click 'Activate' to save the connection
  • Spinify will then automatically query this table every 15 minutes and update the scores of any leaderboards running on this integration based on the query response.

3. If needed add additional connections by clicking the 'Connect to SQL' button

Next steps

See How to Create a Competition on SQL data to learn how to use data returned by your SQL integration on a leaderboard.

Was this article helpful?
0 out of 0 found this helpful