Skip to content

Documentation

Early Adopters program


​​​Registration to the program

You can register to our Early adopters program via this form on the home page of this site.  We will contact you to discuss your goals and specific use cases and we will give you the instructions to provide the Jira API token so we can setup the data refresh.

Jira Extract Setup


Generating the API Token

In order to access your Jira data we will need your API Token.  You can generate it using the instructions found here.​

Data Access Setup


Database Connection Info

Database Server : axodbsprod.database.windows.net

Database name : axo

Data Connection Strings

ADO.NET

Server=tcp:axodbsprod.database.windows.net,1433;Initial Catalog=axo;Persist Security Info=False;UserID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

JDBC

jdbc:sqlserver://axodbsprod.database.windows.net:1433;database=axo;user={your_user_name}@axodbsprod;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30; 

ODBC

Driver={ODBC Driver 13 for SQL Server};Server=tcp:axodbsprod.database.windows.net,1433;Database=axo;Uid={your_user_name};Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

Connecting with Microsoft Excel

In order to access your data using Microsoft Excel you can follow these instructions.

Data Model and Queries


Data Model

AXOBOARD

Sample Queries

SELECT
 prj.Name AS "project.name",
 tsk.Name AS "task.name",
 res.Fullname AS "resource.fullname",
 sum(tsh.Hours) AS Hours
FROM
 Tasks AS tsk
JOIN
 Projects AS prj ON tsk.ProjectSk = prj.ProjectSk
LEFT JOIN
 Timesheets AS tsh ON tsh.TaskSk = tsk.TaskSk
LEFT JOIN
 Resources AS res ON res.ResourceSk = tsh.ResourceSk
GROUP BY
 prj.Name,
 tsk.Name,
res.Fullname