ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Act! CRM の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAct! CRM から関連するレスポンスデータを返します。
CData SSIS Components for Act! CRM ストアドプロシージャ
| Name | Description |
| AddCompanyToOpportunity | Associate the company (if it is not already present) to an opportunity |
| AddContactToGroup | Associate the contact (if it is not already present) to a group |
| AddContactToNote | Associate the contact (if it is not already present) to a note |
| AddContactToOpportunity | Associate the contact (if it is not already present) to an opportunity |
| AddGroupToOpportunity | Associate the group (if it is not already present) to an opportunity |
| AddOpportunityProduct | Creates a new Opportunity Product |
| AddOrRemoveContactToActivity | Add or remove the contact to an activity |
| AddOrRemoveContactToCompany | Associate the contact (if it is not already present) to a company. |
| ClearActivity | Clears an activity. |
| ClearActivityAlarms | Clears an activity alarms |
| SubscribeContactToHotLeads | Subscribes a contact to hot-leads |
| UnclearActivity | Unclears an activity. |
| UpdateContactAccessLevel | Updates access level of an already existing contact. |