The CData ADO.NET Provider for Veeva Vault models Veeva Vault objects as relational views. A Veeva Vault object has relationships to other objects; in the views, these relationships are expressed through foreign keys. The following sections show the static endpoints of the Veeva Vault API.

However, the rest of the views are dynamically determined, using the metadata exposed on the Veeva Vault API. All vault objects are exposed by the provider. However, the provider only lists views for which it can determine all available columns at design time. Examples of Veeva objects available with the CData ADO.NET Provider for Veeva Vault but not displayed in the help include:

• Documents (Query the available documents, VQL is used when possible for this object.)
• Users (Query the existing users, VQL is used when possible for this object.)
• Groups (Query the existing groups, VQL is used when possible for this object.)
• {Every Vault Object} (Query any vault object on its own view. VQL is always used to query Vault Object's views.)

About Veeva Vault Query

Veeva Vault Query (VQL) is a query language similar to SQL. It is available to use via the Veeva Vault API. When the query can be handled server-side, the provider transforms SQL to VQL and sends it to Veeva Vault. Optimizing in this way decreases the execution time, since the filtering is done server-side.

If you set the QueryPassthrough connection property to True, the provider executes VQL queries directly against the Veeva Vault API.