JDBC Driver for Act! CRM

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Act! CRM Views

Name Description
ActivityCompanies Query the Companies participating in an Act! CRM Activity.
CompanyContacts Query the Contacts belonging to a Company.
CompanyNotes Query the Notes for a given Act! CRM Company.
ContactActivities Query the Activities for a given Act! CRM Contact.
ContactGroups Query the Act! CRM Groups the Contact belongs to.
GroupNotes Query the Notes for a given Act! CRM Group.
OpportunityNotes Query the Notes for a given Act! CRM Opportunity.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462