Overview

The connector models each portal associated with your account as a catalog, named after the portal. For every project in each of these catalogs, there is a project-specific schema, which is named after the project.

UserProjects provides access to project-scoped entities. To query a project-scoped entity, identify the project using either:

• ProjectId in the connection properties, or
• The project name as the schema in a fully qualified query.

For example:

SELECT * FROM [ProjectName].[TableName]

Alternatively, specify ProjectId in the connection properties and query the entity directly:

SELECT * FROM [TableName]

Tables

Tables describes the available tables. Tables are statically defined to model Zoho Projects entities such as bugs, events, tasks, etc.

Views

Views describes the available views. Views are read-only tables that are statically defined to model Zoho Projects entities such as activities, clients, documents, etc.