Fine Tuning Data Access

You can use the following properties to gain more control over the data returned from Azure DevOps:

• Catalog: Specifies the name or ID of the specific project to which you would like to connect. To get a list of project IDs and names, execute a SELECT query against the Projects table.
  • If you want to query data for a specific project, set Catalog to the name of that project OR to Project_projectname. For example, to query a project named dev with the ID 2ee729d6-804d-4ece-84af-d5befa94abe8, you can set Catalog to either Project_dev or Project_2ee729d6-804d-4ece-84af-d5befa94abe8.
  • If you want to query information that is independent of a specific project, set Catalog to CData.
• Schema: Specifies the schema to be used. Available schemas depend on the repository specified. For a list of repository IDs and names, execute a SELECT query against the Repositories table.
  • If Catalog is set to CData, the only schema available is Information.
  • If Catalog is set to a project catalog, you can set Schema to either Analytics, Project, or one of the Repository schemas. Once you set the appropriate schema, you can query data within a specific repository. For example, to query data a repository with the ID 3ee729d6-804d-4ece-84af-d5befa94abe8, first set Catalog to Repository_3ee729d6-804d-4ece-84af-d5befa94abe8.