The choice of operation determines how Cast Iron® Express®
monitors and interacts with your Source and Target endpoints. Support
for individual operations can vary between implementations. For example,
FTP utilizes get and put operations, while salesforce.com supports
the upsert and get updated operations.
Before selecting an operation, review the following information
to ensure that the activity that you want to use, is supported by
the specific endpoint that you are working with.
Table 1. FTP
as a Source endpointOperation |
Resulting activity |
Poll directory |
Monitors the chosen file for updates on a 30
second interval. |
Table 2. Databases (MySQL, SQL Server, DB2®, Oracle) as a Source endpointOperation |
Resulting activity |
Get inserted rows |
Retrieves newly inserted entries from the database
table and triggers the integration. |
Get updated rows |
Retrieves newly modified entries from the database
table and triggers the integration. |
Get deleted rows |
Passes newly deleted entries from the database
table and triggers the integration. |
Table 3. Databases (MySQL, SQL Server, DB2, Oracle) as a Target endpointOperation |
Resulting activity |
Insert rows |
Creates database entries based upon the data
flowing through the integration. |
Update rows |
Modifies database entries based upon the data
flowing through the integration. |
Delete rows |
Deletes database entries based upon the data
flowing through the integration. |
Table 4. salesforce.com as a Source endpointOperation |
Resulting activity |
Get deleted objects |
Passes newly deleted objects of the selected
type from salesforce.com and triggers the integration. |
Get updated objects |
Passes newly modified objects of the selected
type from salesforce.com and triggers the integration. |
Table 5. salesforce.com as a Target endpointOperation |
Resulting activity |
Create objects |
Creates object entries based upon the data flowing
through the integration. |
Update objects |
Modifies object entries based upon the data
flowing through the integration. |
Upsert objects |
Updates and/or inserts object entries based
upon the data flowing through the integration. |
Delete objects |
Deletes object entries based upon the data flowing
through the integration. |