Skip to main content
System StatusContact Support

Documentation related to the following products will soon be moved to a new portal: ( Agility, Agility Connect and Agility Integrations Continuum and ALM Connect
Links from the site will automatically redirect to the new site.
If you have any questions, please contact Support. Agility Community

How can I export or query data in Datamart?

For Hosted Instances:

There is no way to export data from the Datamart using the API or the SDK. The only thing would be to get a full SQL backup of the data in the Datamart. However, again, after discussing this with the team, it would not make much sense to do that as the data in the datamart is the same data that is in Agility. You can get the same data from Agility using the API / SDK and manipulate it to get the same information as you would from doing the same with the datamart data. 

The main issue with trying to get large amounts of data from Agility or anywhere else is that you will run into query timeout issues. If you submit very broad queries to bring back everything, it will cause issues as the hosted environment has limits on how much you can pull at once. The best practice would be to have focused queries that will bring back smaller data sets which will not cause query timeout issues. 

If necessary, we can request a full backup of the Agility database which they can use for the reporting project they have but they will need to realize that all of the data will only be up to a specific point in time. 


For Local Instances:

You can use SQL Server tools to query the Datamart database as much as necessary. Review the other articles on the Community site for the Datamart Schema.