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 | [DEPRECATED] 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. |
| CompanyAccessControl | Query and update the access control level for a company. |
| CompanyContacts | Query, delete 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. |
| Documents | Query, create and delete the document history records. |
| GroupAccessControl | Query and update the access control level for a group. |
| 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. |
| OpportunityAccessControl | Query and update the access control level for an opportunity. |
| 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. |
| OpportunityProcesses | Query, create, update and delete opportunity process definitions. |
| OpportunityProcessStages | Query and create stage definitions within an opportunity process. |
| OpportunityProducts | Update, delete and query the Products associated with an Opportunity. |
| Products | Create, update, delete and query the Products in your A ct! CRM database. |
| ProductsInternal | Create, update, delete and query the Products in your A ct! CRM database. |
| RecurringTasks | Query, create, update and delete recurring task records. |
| SecondaryContacts | Query, create, update and delete secondary contacts for a contact. |
| Tasks | Query, create, update and delete the tasks. |
| Teams | Query, create, update and delete teams. |
| Users | Query, create and delete user accounts. |