Tables

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

CData Tableau Connector for Act! CRM Tables


Name	Description
Activities	[DEPRECATED] Create, update, delete and query the Activities in your Act! CRM database.
CompaniesInternal	Create, update, delete and query the Companies created in your Act! CRM database.
CompanyContactsInternal	Query, delete the Contacts belonging to a Company.
ContactNotes	Query and delete the Notes for a given Act! CRM Contact.
ContactsInternal	Create, update, delete and query the Contacts in your Act! CRM database.
GroupContactsInternal	Query and delete the Contacts belonging to a Group.
GroupsInternal	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.
OpportunitiesInternal	Create, update, delete and query the Opportunities in your Act! CRM database.
OpportunityCompaniesInternal	Query and delete the Companies related to an Act! CRM opportunity.
OpportunityContacts	Query and delete the Contacts associated with an Opportunity.
OpportunityGroupsInternal	Query and delete the Act! CRM Groups associated with an Opportunity.
OpportunityProductsInternal	Update, delete and query the Products associated with an Opportunity.
ProductsInternal	Create, update, delete and query the Products in your A ct! CRM database.