Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Teams
, (opens new window)
Recipes
Results will update as you type.
  • Building the Examplegear Database
    • Installation Instructions for Examplegear Database v1.0
    • Installation Instructions for Examplegear Database v2.0
    • Installation Instructions for Examplegear Database v3.0
    • Installation Instructions for Examplegear Database v4.0
    • Installation Instructions for MySQL
  • How to Automate the Creation of HipChat Users and Room Assignments from Data in Another System
  • How to Automatically add a Comment to a Linked Issue During a Workflow Transition
  • How to Automatically Create a Formatted Table From SQL Data
  • How to Automatically Create a JIRA Project Using the JIRA CLI
  • How to Automatically Create a Standard Story When Creating an Epic
  • How to Automatically Create HipChat Rooms for High Priority Ticket Discussions
  • How to Create a Business Intelligence (BI) Dashboard
  • How to Create a Chart From SQL Data
  • How to Create a Confluence Space Using the Confluence CLI
  • How to Create a Self-Service Report From SQL Data
  • How to Display an Attached CSV File as a Confluence Table
  • How to Import Data into JIRA from External Systems or Databases
  • How to Monitor Language in Public Chat Rooms (Advanced)
  • How to Monitor Language in Public Chat Rooms (Intermediate)
    Calendars
You‘re viewing this with anonymous access, so some content might be blocked.
/
Building the Examplegear Database
Unable to render {include} The included page could not be found.

Building the Examplegear Database

Feb 22, 2016

Our Recipes for Business Intelligence & Automation are based off a fictitious software company known as Examplegear, Inc. with growing international sales across several products.

If you would like to follow along with our recipes on your own, please feel free to download and build the following Examplegear database locally. It is intended for use with the Community edition of MySQL, but the instructions and DDL statements can be adjusted for another DBMS if desired.

(info) Before installing the database, be sure to install MySQL.

Examplegear Database Release History

VersionDate ReleasedNotes
Installation Instructions for Examplegear Database v4.02016-02-22v4.0 release of database, adding additional an additional employee to the Employees table.
Installation Instructions for Examplegear Database v3.02016-01-29v3.0 release of database, adding additional releases to the Products table, additional departments to the Departments table, and additional employees to the Employees table.
Installation Instructions for Examplegear Database v2.02015-05-13v2.0 release of database, adding additional employees to the Employees table.

Installation Instructions for Examplegear Database v1.0

2015-04-27Initial release of database

 

 

 

, multiple selections available,
Unable to render {include} The included page could not be found.
{"serverDuration": 15, "requestCorrelationId": "d5f6eda3a13c4b72a5011f0110e3226f"}