Please visit our new TrackAbout Knowledge Base at https://supportkb.trackabout.com for the most-up-to-date documentation on TrackAbout and TrackAbout Mobile.
OpenData
About
TrackAbout OpenData is a beta feature. OpenData enables customers to access a restricted view of their SQL data stored by TrackAbout. If you're interested in being able to write your own SQL queries to retrieve TrackAbout data, please contact support@trackabout.com.
Accessing OpenData
OpenData is served up from Microsoft Azure SQL Database. To access OpenData, customers will need to be able to log into an Azure SQL Database. Connecting to Azure SQL Database is practically identical to connecting to a Microsoft SQL Server database.
There are many tools that are capable of connecting to Azure SQL Database. Microsoft's SQL Server Management Studio (SSMS) became a standalone, free product in January 2017. We highly recommend using the latest version.
If you have signed up for the OpenData offering, TrackAbout will share connection string and credential data through support channels.
Frequently Asked Questions
- The data I need isn't in the OpenData views. Can you add it?
- Not every TrackAbout customer needs the same data. We can work with you to add data to your views.
- There's data in the views I don't care about. Can you remove it?
- To offer a service that can scale with customer growth, TrackAbout needs the OpenData views to remain identical across all customers. Maintaining dozens of different database schemas would require raising the price significantly to cover the cost. This means you may have tables or columns you don't want or care about. With SQL, you can always query only the tables and columns you do care about, and ignore the rest.