Tables
The driver models the data in Act! CRM into a list of tables that can be queried using standard SQL statements.
Generally, querying Act! CRM tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC 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. |
| 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. |
| 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. |