ODBC Driver for Act! CRM

Build 24.0.8963

Tables

The driver models the data in Act! CRM as a list of tables in a relational database that can be queried using standard SQL statements.

CData ODBC Driver for Act! CRM Tables

Name Description
Activities Create, update, delete and query the Activities in your Act! CRM database.
Companies Create, update, delete and query the Companies created in your Act! CRM database.
CompanyContacts Query the Contacts belonging to a Company.
ContactNotes Query and delete the Notes for a given Act! CRM Contact.
Contacts Create, update, delete and query the Contacts in your Act! CRM database.
GroupContacts Query and delete the Contacts belonging to a Group.
Groups Create, update, delete and query the Groups participating in your Act! CRM database.
Histories Get, Create, Update or Delete all history items.
Notes Create, update, delete and query the Notes in your Act! CRM database.
Opportunities Create, update, delete and query the Opportunities in your Act! CRM database.
OpportunityCompanies Query and delete the Companies related to an Act! CRM opportunity.
OpportunityContacts Query and delete the Contacts associated with an Opportunity.
OpportunityGroups Query and delete the Act! CRM Groups associated with an Opportunity.
OpportunityProducts Update, delete and query the Products associated with an Opportunity.
Products Create, update, delete and query the Products in your Act! CRM database.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963