Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Module | Type | Description |
---|---|---|
ExactOnline
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection for saving output data records.
LookupRecord
Gets a specific record from a data source
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
FinancialEdgeNXT
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
FreshBooks
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
QuickBooks
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
QuickBooksOnline
CloseSource
The CloseQuickBooksOnlineSource activity closes the specified source connection
CloseTarget
The CloseQuickBooksOnlineTarget activity closes the specified target connection
DeleteRecord
The DeleteQuickBooksOnlineRecord activity deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
The InitializeQuickBooksOnlineTarget is used for initializing a connection where output records will be saved. Multiple InitializeQuickBooksOnlineTarget activites can be included in the workflow.
LookupRecord
The LookupQuickBooksOnlineRecord activity fetches a specific record from a source connection
MapRecordFields
The MapAndSetQuickBooksOnlineFields activity is used for setting the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
QuickBooksPOS
CloseSource
The CloseQuickBooksPOSSource activity closes the specified source connection
CloseTarget
The CloseQuickBooksPOSTarget activity closes the specified target connection
DeleteRecord
The DeleteQuickBooksPOSRecord activity deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
The InitializeQuickBooksPOSTarget is used for initializing a connection where output records will be saved. Multiple InitializeQuickBooksPOSTarget activites can be included in the workflow.
LookupRecord
The LookupQuickBooksPOSRecord activity fetches a specific record from a source connection
MapRecordFields
The MapAndSetQuickBooksPOSFields activity is used for setting the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Reckon
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Sage50UK
CloseSource
The CloseSage50UKSource activity closes the specified source connection
CloseTarget
The CloseSage50UKTarget activity closes the specified target connection
DeleteRecord
The DeleteSage50UKRecord activity deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
The InitializeSage50UKTarget is used for initializing a connection where output records will be saved. Multiple InitializeSage50UKTarget activites can be included in the workflow.
LookupRecord
The LookupSage50UKRecord activity fetches a specific record from a source connection
MapRecordFields
The MapAndSetSage50UKFields activity is used for setting the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
SageIntacct
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Xero
CloseSource
The CloseXeroSource activity closes the specified source connection
CloseTarget
The CloseXeroTarget activity closes the specified target connection
DeleteRecord
The DeleteXeroRecord activity deletes the specified target record
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
The InitializeXeroTarget is used for initializing a connection where output records will be saved. Multiple InitializeXeroTarget activites can be included in the workflow.
LookupRecord
The LookupXeroRecord activity fetches a specific record from a source connection
MapRecordFields
The MapAndSetXeroFields activity is used for setting the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
AdobeAnalytics | CloseSource | The CloseAdobeAnalyticsSource activity closes the specified source connection |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|
Module | Type | Description |
---|
Module | Type | Description |
---|
Module | Type | Description |
---|
GetNextRecord
The GetNextAdobeAnalyticsRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupAdobeAnalyticsRecord activity fetches a specific record from a source connection
AzureAnalysisServices
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupRecord activity fetches a specific record from a source connection
GoogleAnalytics
CloseSource
The CloseGoogleAnalyticsSource activity closes the specified source connection
GetNextRecord
The GetNextGoogleAnalyticsRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupGoogleAnalyticsRecord activity fetches a specific record from a source connection
SAS
CloseSource
Closes the specified source connection
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Loads a specific record from a source connection
YouTubeAnalytics
CloseSource
The CloseYouTubeAnalyticsSource activity closes the specified source connection
GetNextRecord
The GetNextYouTubeAnalyticsRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupYouTubeAnalyticsRecord activity fetches a specific record from a source connection
GoogleCalendar
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
GoogleContacts
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Alfresco
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Kintone
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
QuickBase
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
ApacheHBase
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading data records
LookupRecord
Fetches a specific record from a source connection
ApacheHive
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading data records
LookupRecord
Fetches a specific record from a source connection
Greenplum
CloseSource
The CloseSource activity closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
The LookupGreenplumRecord activity fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
HPCC
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupHPCCRecord activity fetches a specific record from a source connection
SparkSQL
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupSparkSQLRecord activity fetches a specific record from a source connection
JIRA | CloseSource | Closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time |
LookupRecord | Fetches a specific record from a source connection |
ServiceNow | CloseSource | Closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time |
LookupRecord | Fetches a specific record from a source connection |
Zendesk | CloseSource | Closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time |
LookupRecord | Fetches a specific record from a source connection |
AmazonS3 | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
CopyObject | Copies an object from one bucket to another |
DownloadObjects | Downloads objects |
DownloadObjectTorrent | Uses the BitTorrent protocol to retrieve any publicly-accessible objects |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
UploadObject | Uploads objects in a single operation |
AzureTables | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
CreateEntityWithTypes | Creates a new record with the given data types. If a column is not found on an existing entity, you will need to use this procedure to set the type of the property to something other than string. |
CreateSchema | Creates a schema file for the specified table or view |
CreateTable | Creates a new table in the Azure system |
DropTable | Drops an existing table in the Azure system |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
IBMCloudObjectStorage | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
CopyObject | Copies an object from one bucket to another |
DeleteRecord | Deletes the specified target record |
DownloadObject | Downloads and object |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
UploadObject | Uploads an object |
Wasabi | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
CopyObject | Copies an object from one bucket to another |
DownloadObjects | Downloads objects |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
UploadMultipleObjects | Uploads a single object as a set of parts |
UploadObject | Uploads objects in a single operation |
Asana | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Box | AddMetadataTemplatestoFile | Applies an instance of a metadata template to a file. |
CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
CopyFile | Copy a File |
CopyFolder | Copy a Folder |
DeleteRecord | Deletes the specified target record |
DownloadFile | Downloads a File |
EmptyTrash | Clear the recycle bin/trash. |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LockFile | Lock a file |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
ShareAnItem | Shares a File, Folder or Bookmark. |
UnlockFile | Unlock a file. |
UploadFile | Uploads a File. |
UploadFileVersion | Uploads a new version of an existing File. |
Dropbox | CheckJobStatus | Check the status of an asynchronous job. Requires the sharing.write scope. |
CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeletePermanently | Delete a folder or file permanently. Requires the files.permanent_delete scope. |
DeleteRecord | Deletes the specified target record |
DownloadFile | Downloads a File. Requires the files.content.read scope. |
GetNextRecord | Fetches the next record from the specified source |
GetSpaceUsage | Check the memory space management of your Dropbox account. Requires the account_info.read scope. |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
ShareFolder | Shares a folder. Requires the sharing.write scope. |
UnshareFolder | Unshares a folder. Requires the sharing.write scope. |
UploadFile | Uploads a File. Requires the files.content.read scope. |
Exchange | CloseSource | The CloseExchangeSource activity closes the specified source connection |
CloseTarget | The CloseExchangeTarget activity closes the specified target connection |
DeleteRecord | The DeleteExchangeRecord activity deletes the specified target record |
GetNextRecord | The GetNextExchangeRecord activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeExchangeTarget is used for initializing a connection where output records will be saved. Multiple InitializeExchangeTarget activites can be included in the workflow. |
LookupRecord | The LookupExchangeRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetExchangeFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
GoogleDrive | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
MSTeams | CloseSource | The CloseMSTeamsSource activity closes the specified source connection |
CloseTarget | The CloseMSTeamsTarget activity closes the specified target connection |
DeleteRecord | The DeleteMSTeamsRecord activity deletes the specified target record |
GetNextRecord | The GetNextMSTeamsRecord activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeMSTeamsTarget is used for initializing a connection where output records will be saved. Multiple InitializeMSTeamsTarget activites can be included in the workflow. |
LookupRecord | The LookupMSTeamsRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetMSTeamsFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Office365 | CloseSource | The CloseOffice365Source activity closes the specified source connection |
CloseTarget | The CloseOffice365Target activity closes the specified target connection |
DeleteRecord | The DeleteOffice365Record activity deletes the specified target record |
GetNextRecord | The GetNextOffice365Record activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeOffice365Target is used for initializing a connection where output records will be saved. Multiple InitializeOffice365Target activites can be included in the workflow. |
LookupRecord | The LookupOffice365Record activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetOffice365Fields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
OneDrive | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
CopyResource | Copy a resource from one directory in your drive to another. |
CreateFolder | Create a new folder in your drive |
DeleteRecord | Deletes the specified target record |
DeleteResource | Delete a resource from your drive. |
DownloadFile | Download an existing file from your drive. |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
MoveResource | Move a resource from one directory in your drive to another. |
SaveRecord | Saves the specified target record |
UploadFile | Upload a new file or update content to an existing file. |
OneNote | CloseSource | The CloseOneNoteSource activity closes the specified source connection |
CloseTarget | The CloseOneNoteTarget activity closes the specified target connection |
DeleteRecord | The DeleteOneNoteRecord activity deletes the specified target record |
GetNextRecord | The GetNextOneNoteRecord activity fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | The InitializeOneNoteTarget is used for initializing a connection where output records will be saved. Multiple InitializeOneNoteTarget activites can be included in the workflow. |
LookupRecord | The LookupOneNoteRecord activity fetches a specific record from a source connection |
MapRecordFields | The MapAndSetOneNoteFields activity is used for setting the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
SharePoint | AddAttachment | Add an attachment to a SharePoint list item |
CheckInDocument | Checks in a document to SharePoint and releases the lock on the document |
CheckOutDocument | Checks out a document from SharePoint |
CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
CopyDocument | Copies a document from the SharePoint library |
CreateFolder | Creates a folder to a document library on a SharePoint site |
DeleteAttachment | Delete an attachment from a SharePoint list item |
DeleteDocument | Delete a document on the SharePoint library. |
DeleteRecord | Deletes the specified target record |
DiscardCheckOutDocument | Discards a check out on a document in SharePoint. This does not check a new file into SharePoint, it just releases the lock on the document |
DownloadDocument | Download a document from a SharePoint library |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
UploadDocument | Upload a document to a SharePoint library |
Slack | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
Smartsheet | CloseSource | Closes the specified source |
CloseTarget | Closes the specified target |
DeleteRecord | Deletes the specified target record |
GetNextRecord | Fetches the next record from the specified source |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a target for writing records |
LookupRecord | Fetches a specific record from a source |
MapRecordFields | Sets the values of the specified DataFields in a target |
SaveRecord | Saves the specified target record |
ActCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
BullhornCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Dynamics365 | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
CreateAssociation | Creates an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this activity. |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeAssociationsSource | Lists associations for a given table and navigation property into a Source. Set the IncludeNavigationProperties connection property to true in order to use this workflow activity. |
InitializeNavigationPropertiesSource | Lists navigation properties for a given table and the tables they are associated with into a Source. Navigation properties are used by the Association stored procedures. Set the IncludeNavigationProperties connection property to true in order to use this workflow activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
DynamicsCRM | Assign | Assigns a target record to a user or team |
AssociateRequest | Adds link between two entity instances in a many to many relationship |
CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
DisassociateRequest | Removes a link between two entity instances in a many to many relationship |
ExecuteStatements | Executes custom SQL statements on a data source |
ExecuteWorkflow | Executes a Dynamics CRM workflow request |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SetState | Sets the state and the status of an entity instance |
Highrise | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
OracleSalesCloud | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Salesforce | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
DeleteRecord | Deletes the specified target record |
DownloadAttachment | Downloads the attachment or attachments associated with a specific object |
DownloadDocument | Downloads the selected document or documents |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
GetUserInformation | Retrieves personal information for the user associated with the current session. |
InitializeDeletedSource | Initializes a source of deleted records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
InitializeUpdatedSource | Initializes a source of updated records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
Merge | Combines up to 3 records of the same type into 1 record. |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Undelete | Restores a deleted record from the RecycleBin |
UploadAttachment | Uploads an attachment and associates it with an object in Salesforce |
UploadDocument | Uploads a document in Salesforce |
SAPHybrisC4C | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SugarCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SuiteCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
VeevaCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
DeleteRecord | Deletes the specified target record |
DownloadAttachment | Downloads the attachment or attachments associated with a specific object |
DownloadDocument | Downloads the selected document or documents |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
GetUserInformation | Retrieves personal information for the user associated with the current session. |
InitializeDeletedSource | Initializes a source of deleted records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
InitializeUpdatedSource | Initializes a source of updated records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
Merge | Combines up to 3 records of the same type into 1 record. |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Undelete | Restores a deleted record from the RecycleBin |
UploadAttachment | Uploads an attachment and associates it with an object in Salesforce |
UploadDocument | Uploads a document in Salesforce |
ZohoCRM | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|
Module | Type | Description |
---|
Module | Type | Description |
---|
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Gmail
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
AmazonMarketplace
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Magento
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Shopify
CloseSource
Closes the specified source connection
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
WooCommerce
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
ADLSGen1
AppendToFile
Appends content or a file to a file
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
Concat
Concatenate a group of files to another file
DeletePath
Delete a file or a directory.
DownloadFile
Downloads a file
GetContentSummary
Get the content summary of a file/folder.
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MakeDirectory
Create a directory in the specified path
RenamePath
Rename a file or a directory.
SetPathOwner
Set owner and group of a path.
SetPermission
Set permission of a path
UploadFile
Uploads a File
ADLSGen2
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
CreateFile
Create a file.
CreateFolder
Create a folder
DeleteObject
Delete a file or directory
DownloadFile
Download a file
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
RenameObject
Rename a file or a directory
UploadFile
Uploads a file
AzureSynapse
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
Databricks
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
GoogleBigQuery
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Redshift
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
Snowflake
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SAPConcur | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a source for reading data records |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
CSVDatabase | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
DelimitedFile | AppendFile | Appends the contents of one file to another |
CloseSourceFile | Closes the specified Source data source |
CloseTargetFile | Closes the specified target delimited file |
CopyFileRecords | Copies specific records from one file to another |
CreateFileFromSource | Creates a delimited file from a Source |
DeleteFile | Deletes the specified file |
GetNextFileRecord | Fetches the next record from the specified delimited Source file |
InitializeSourceFile | Initializes a Source for reading data records from a delimited file |
InitializeTargetFile | Initializes a Target for writing data records to a delimited file |
MapRecordFields | Sets the values of the specified DataFields in a target delimited file |
SaveValueInNewFile | Saves a field value to a file |
SplitFile | Splits a large delimited file into multiple files |
WriteTargetFileRecord | Inserts a record into the specified delimited file |
FileSystem | DirACLAddEntry | The DirectoryAddACLEntry activity adds an Access Control List (ACL) entry to a directory |
DirACLRemoveEntry | The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory |
DirCloseDirInfoSource | The DirectoryCloseDirectoryInfoSource activity closes the Directoryinfo source and frees up resources |
DirCloseFileInfoSource | The CloseSourceFileFile activity closes the DirectoryFileInfo source and frees up resources |
DirectoryCreate | The DirectoryCreate activity creates all the directories and subdirectories in the specified path |
DirectoryDelete | The DirectoryDelete activity deletes a directory and its subdirectories if specified |
DirectoryMove | The DirectoryMove activity moves a directory from a source to a destination |
DirectoryZip | The DirectoryZip activity zips a directory |
DirGetNextDirInfoRecord | The DirGetNextDirInfoRecord activity loads the next record from the specified list of selected Directoryinfo |
DirGetNextFileInfoRecord | The DirectoryGetNextFileInfoRecord activity loads the next record from the specified list of selected fileinfo |
DirInitializeDirInfoSource | The DirectoryInitializeDirectoryInfoSource activity initializes a list of directory information that can be accessed sequentially using the GetNextDirectoryInfoRecord |
DirInitializeFileInfoSource | The DirectoryInitializeFileInfoSource activity initializes a list of file information that can be accessed sequentially using the GetNextFileInfoRecord |
FileACLAddEntry | The FileACLAddEntry activity adds an Access Control List (ACL) entry to a file |
FileACLRemoveEntry | The FileACLRemoveEntry activity removes Access Control List (ACL) entry from a file |
FileCopy | Copies files from one location to another |
FileDelete | The FileDelete activity deletes a file |
FileFTPDownload | The FileFTPDownload activity downloads a file from an ftp site |
FileFTPUpload | The FileFTPUpload activity uploads a file from an ftp site |
FileMove | Moves a file from a source to a destination |
FileUnzip | The FileZip activity unzips a file |
FileZip | The FileZip activity zips a file |
SaveValueInNewFile | The SaveValueInNewFile activity is used for saving field values to a file |
FixedLengthFile | AppendFile | Appends the contents of one file to another |
CloseSourceFile | Closes the specified Source file data source |
CloseTargetFile | Closes the specified target file |
CopyFileRecords | Copies specific records from one file to another |
DeleteFile | Deletes the specified file |
GetNextFileRecord | Fetches the next record from the specified Source file data source |
InitializeSourceFile | Initializes a Source for reading data records from a fixed length file |
InitializeTargetFile | Initializes a Target for writing data records to a fixed length text file |
MapRecordFields | Sets the values of the specified DataFields in a Target data source |
SaveValueInNewFile | The SaveValueInNewFile activity is used for saving a field value to a file |
SplitFile | Splits a large delimited file into multiple files |
WriteTargetFileRecord | Inserts a record into the specified text file |
Acumatica | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
D365BusinessCentral | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Dynamics365 | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
DynamicsGP | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
DynamicsNAV | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
NetSuite_SuiteQL | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
NetSuite_SuiteTalk | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Odoo | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SAPBusinessOne | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
SAPERP | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
Workday | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|
Module | Type | Description |
---|
Module | Type | Description |
---|
OFX
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
Quandl
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Gets a specific record from a data source
DynamicDataSource
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record
AmazonDynamoDB
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Cassandra
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Cloudant
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
CosmosDB
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Couchbase
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MongoDB
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Redis
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
SimpleDB
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
BingAds
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
GoogleAds
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
HubSpot
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MailChimp
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Marketo
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
OracleEloqua
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
SurveyMonkey
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
YouTube
CloseSource
The CloseYouTubeSource activity closes the specified source connection
GetNextRecord
The GetNextYouTubeRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupYouTubeRecord activity fetches a specific record from a source connection
Propel | CloseSource | Optional activity to close a specified source connection. Note: All connections are automatically closed at the end of the job run |
CloseTarget | Optional activity to close a specified target connection. Note: All connections are automatically closed at the end of the job run |
ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
DeleteRecord | Deletes the specified target record |
DownloadAttachment | Downloads the attachment or attachments associated with a specific object |
DownloadDocument | Downloads the selected document or documents |
ExecuteStatements | Executes custom SQL statements on a data source |
GetNextRecord | Gets the next record from the specified source connection |
GetUserInformation | Retrieves personal information for the user associated with the current session. |
InitializeDeletedSource | Initializes a source of deleted records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
InitializeUpdatedSource | Initializes a source of updated records within the given timespan for the specified object. Records can be iterated using the GetNextRecord activity. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
Merge | Combines up to 3 records of the same type into 1 record. |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) |
Undelete | Restores a deleted record from the RecycleBin |
UploadAttachment | Uploads an attachment and associates it with an object in Propel |
UploadDocument | Uploads a document in Propel |
Basecamp | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
MicrosoftProject | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
AuthorizeNet | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
PayPal | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
Square | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Stripe | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
The Actions-Fields-Library-Financial module which is filled with Microsoft Excel compatible functions contains the following types:
The Execution action category contains the following actions in the modules shown below:
The Fields-Field actions are grouped in the modules shown below:
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|---|---|
Module | Type | Description |
---|
Type | Description |
---|
Module | Type | Description |
---|
Module | Type | Description |
---|
ActiveDirectory
CloseSource
The CloseSource activity closes the specified source connection
CloseTarget
The CloseTarget activity closes the specified target connection
DeleteRecord
The DeleteRecord activity deletes the specified target record
ExecuteStatements
The ExecuteActiveDirectoryStatement activity is used to execute a custom sql statement on a connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
The InitializeSource activity initializes a connection for reading data records at run time. Multiple InitializeActiveDirectorySource activites can be included in the workflow.
InitializeTarget
The InitializeTarget is used for initializing a connection where output records will be saved. Multiple InitializeActiveDirectoryTarget activites can be included in the workflow.
LookupRecord
The LookupRecord activity fetches a specific record from a source connection
MapRecordFields
The MapRecordFields activity is used for setting the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
JSON
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
LDAP
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MicrosoftDataverse
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
OData
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Execute a custom sql statement on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
REST
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
The InitializeSource activity initializes a connection for reading data records at run time. Multiple InitializeRESTSource activites can be included in the workflow.
LookupRecord
The LookupRecord activity fetches a specific record from a source connection
RSS
CloseSource
Closes the specified source connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Fetches a specific record from a source connection
XML
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
FedEx
CloseSource
The CloseFedExSource activity closes the specified source connection
GetNextRecord
The GetNextFedExRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupFedExRecord activity fetches a specific record from a source connection
UPS
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupUPSRecord activity fetches a specific record from a source connection
USPS
CloseSource
The CloseUSPSSource activity closes the specified source connection
GetNextRecord
The GetNextUSPSRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupUSPSRecord activity fetches a specific record from a source connection
Bing
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupBingRecord activity fetches a specific record from a source connection
Elasticsearch
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a source for reading data records
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
GoogleSearch
CloseSource
The CloseSource activity closes the specified source connection
GetNextRecord
The GetNextRecord activity fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
The LookupGoogleSearchRecord activity fetches a specific record from a source connection
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Excel | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records. Records can be iterated using the GetNextRecord activity. |
InitializeTarget | Initializes a connection for saving output data records. |
LookupRecord | Gets a specific record from a data source |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
ExcelOnline | CloseSource | The CloseExcelOnlineSource activity closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
ExcelServices | CloseSource | The CloseExcelServicesSource activity closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
LookupRecord | Fetches a specific record from a source connection |
GoogleSheets | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
ACCRINT | Returns the accrued interest for a security that pays periodic interest |
ACCRINTM | Returns the accrued interest for a security that pays interest at maturity |
AMORDEGRC | Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets. |
AMORLINC | Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. |
COUPDAYS | Returns the number of days in the coupon period that contains the settlement date. |
COUPDAYSBS | Calculates the number of days from the beginning of a coupon's period to the settlement date. |
COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date. |
COUPNCD | Returns a number that represents the next coupon date after the settlement date. |
COUPNUM | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. |
COUPPCD | Returns a number that represents the previous coupon date before the settlement date. |
CUMIPMT | Returns the cumulative interest paid on a loan between start_period and end_period. |
CUMPRINC | Returns the cumulative principal paid on a loan between start_period and end_period. |
DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |
DDB | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. |
DISC | Returns the discount rate for a security. |
DOLLARDE | Excel DOLLARDE Function |
DOLLARFR | Excel DOLLARFR Function |
DURATION | Excel DURATION Function |
EFFECT | Excel EFFECT Function |
FV | Calculates the future value of an investment based on a constant interest rate. |
FVSCHEDULE | Returns the future value of an initial principal after applying a series of compound interest rates. |
INTRATE | Returns the interest rate for a fully invested security. |
IPMT | Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. |
IRR | Returns the internal rate of return for a series of cash flows represented by the numbers in values. |
ISPMT | Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. |
MDURATION | Returns the modified Macauley duration for a security with an assumed par value of $100. |
MIRR | Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash. |
NOMINAL | Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. |
NPER | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
NPV | Calculates the net present value of an investment by using a discount rate and a series of future payments(negative values) and income(positive values). |
ODDFPRICE | Returns the price per $100 face value of a security having an odd (short or long) first period. |
ODDFYIELD | Returns the yield of a security that has an odd (short or long) first period. |
ODDLPRICE | Returns the price per $100 face value of a security having an odd (short or long) last coupon period. |
ODDLYIELD | Returns the yield of a security that has an odd (short or long) last period. |
PDURATION | Returns the number of periods required by an investment to reach a specified value. |
PMT | Calculates the payment for a loan based on constant payments and a constant interest rate. |
PPMT | Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. |
PRICE | Returns the price per $100 face value of a security that pays periodic interest. |
PRICEALLOWNEGATIVEYIELD | Returns the price per $100 face value of a security that pays periodic interest. |
PRICEDISC | Returns the price per $100 face value of a discounted security. |
PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity |
PV | Calculates the present value of a loan or an investment, based on a constant interest rate. |
RATE | Returns the interest rate per period of an annuity. |
RECEIVED | Returns the amount received at maturity for a fully invested security. |
RRI | Returns an equivalent interest rate for the growth of an investment. |
SLN | Returns the straight-line depreciation of an asset for one period. |
SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period. |
TBILLEQ | Returns the bond-equivalent yield for a Treasury bill. |
TBILLPRICE | Returns the price per $100 face value for a Treasury bill. |
TBILLYIELD | Returns the yield for a Treasury bill. |
VDB | Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance. |
XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function |
XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function. |
YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). |
YIELD | Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. |
YIELDDISC | Returns the annual yield for a discounted security. |
YIELDMAT | Returns the annual yield of a security that pays interest at maturity. |
Base | CallWebService | The CallWebService activity calls a web service |
CloseActivity | Closes the specified activity (including any open connections) |
Delay | The Delay activity delays the execution of a workflow for a specified amount of time. |
EndWorkflow | The EndWorkflow activity ends the current workflow |
EvaluateCondition | Evaluates a condition and returns True or False |
ExecuteConnectorActivity | Executes a special activity in a connector (not a basic activity contained in BaseData) |
ExecuteWorkflow | Executes a workflow and optionally passes the required parameters to it. |
ExecuteWorkflowActivity | The ExecuteWorkflowActivity action executes a workflow activity |
PerformAction | Performs an action |
ResetActivityResult | Resets the execution result of an activity |
ResetLastResult | Resets the last execution result |
SendEmail | Sends an emal |
SetValues | The SetValues activity is used for setting values in the workflow |
UpdateWorkflowState | This activity updates the State of the currently running instance of the workflow |
WriteAuditLogsEntry | This activity is used for writing entries to the audit logs detail table. The Description and/or Message property is required |
WriteLogEntry | This activity is used for writing entries to the log. Log entries can include Source and Target records/statistics, messages, errors, warnings, etc. |
BaseData | ClearRecord | This activity clears the values in a specific record in memory. It does not clear the record from the data source. |
CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
CommitTransaction | Optional action to Commit a transaction on the Target and start a new transaction |
DeleteRecord | Deletes the specified target record |
ExecuteSQLScript | Executes a SQL Script on a data source (Dynamics365, Salesforce, MySQL, Oracle, etc.) |
ExecuteStatements | Executes custom SQL statements on a connection |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity |
GetNextRecord | The GetNextRecord activity loads the next record from the specified Source |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeSourceFile | Initializes a Source for reading data records from a file |
InitializeSourceList | Initializes a Source for reading data records from a file |
InitializeTarget | Initializes a connection for saving output records. |
InitializeTargetFile | Initializes a Target for writing data records to a file |
LookupRecord | Loads a specific record from a source |
MapAndSaveRecords | Maps and saves values to specified DataFields in a target connection |
MapRecordFields | Maps values to specified DataFields in a target connection |
RestartSource | Restarts a source by re-executing the query and re-reading the records using the GetNextRecord activity |
RollbackTransaction | Optional action to Rollback a transaction on the Target and start a new transaction |
SaveRecord | Saves the specified target record |
BusinessRules | EvaluateConditions | Executes a group of conditions |
EvaluateDecisionTable | Defines and executes a decision table |
ExecuteRuleSet | Initializes and executes a rule set |
PerformActions | Executes a group of actions |
Cache | LoadSourceRecordsIntoCache | The LoadSourceRecordsIntoCache action loads source records into the cache. They can be retrieved using the LookupCachedRecord action |
LookupCachedRecord | Loads a record from the cache |
SaveCustomValueInCache | Saves a custom value in the cache |
SaveKeyValueInCache | DataSource entity record keys are automatically saved in cache when that option is set. This action allows you to save a key in cache at any time and to retrieve it using the LookupCachedKeyValue action |
SaveRecordInCache | Saves a record in cache |
Custom | Composite | Executes selected defined or pre-defined actions in sequence |
Expression | The Expression action executes a simple expression (javascript). The expression does NOT return a value |
Function | Executes a .Net custom function and does NOT returns a value. |
Script | The Script field action executes a script (javascript). The script does not return a value. |
DataMigration | MigrateData | Migrates, replicates or synchronizes data from one or more source data sources to one or more target data sources |
Dialogs | DisplayMessage | Displays a message |
EditRecord | Displays data records for viewing and editing |
EditWorkflowValues | The ViewRuntimeValues activity is used for viewing selected values at run time. |
PromptForValue | Prompts the user for a value |
ViewRuntimeRecords | Displays data records at runtime |
ViewRuntimeStatistics | The ViewRuntimeStatistics activity is used for viewing DataManager statistics at run time |
ViewRuntimeValues | The ViewRuntimeValues activity is used for viewing selected values at run time. |
Cache | LookupCachedCustomValue | Returns a custom value saved in the cache |
LookupCachedKeyValue | Returns a table key value that has been saved in the cache |
Counters | GetCurrentCounterValue | Returns the specified counter value |
IncrementCounter | Initializes, Increments the value of a specified counter and returns it |
Custom | Composite | Executes selected defined or pre-defined actions in sequence and returns the result of executing the last action in the list. |
Expression | The Expression action executes a simple expression (javascript). The expression must return a value |
Function | Executes a .Net custom function and returns a value |
Script | The Script field action executes a script (javascript). The script must return a value. |
DateTime | AddDaysToDate | Adds (or subtracts) the specified number of days to a date |
AddMonthsToDate | Adds (or subtracts) the specified number of months to a date |
AddTimeSpanToDateTime | Adds (or subtracts) the specified TimeSpan (00:00:00:00) to a datetime. To subtract place - in front of TimeSpan value. |
AddYearsToDate | Adds (or subtracts) the specified number of years to a date |
GetDateDay | Gets the Day (integer) from the date |
GetDateMonth | Gets the Month (integer) from the date |
GetDateThisDayLastMonth | Gets this day last month (date) |
GetDateThisDayLastWeek | Gets this day last week |
GetDateThisDayLastYear | Gets this day last year (date) |
GetDateThisDayNextMonth | Gets this day next month (date) |
GetDateThisDayNextWeek | Gets this day next week |
GetDateThisDayNextYear | Gets this day next year (date) |
GetDateThisMonthEnd | Gets this month's end date |
GetDateThisMonthStart | Gets this month's start date |
GetDateThisYearEnd | Gets this year's end date |
GetDateThisYearStart | Gets this year's start date |
GetDateTimeNow | Gets the current date/time |
GetDateToday | Gets today's date |
GetDateTomorrow | Gets tomorrow's date |
GetDateYear | Gets the Year (integer) from the date |
GetDateYesterday | Gets yesterday's date |
GetElapsedTimeDays | Returns the integer number of days between two dates |
GetElapsedTimeHours | Returns the integer number of hours between two datetimes |
GetElapsedTimeMilliseconds | Returns the integer number of milliseconds between two datetimes |
GetElapsedTimeMinutes | Returns the integer number of minutes between two datetimes |
GetElapsedTimeMonths | Returns the integer number of years between two dates |
GetElapsedTimeSeconds | Returns the integer number of seconds between two datetimes |
GetElapsedTimeWeeks | Returns the integer number of weeks between two dates |
GetElapsedTimeYears | Returns the integer number of years between two dates |
GetYearWeekNumber | Gets the number of the week in the year |
SetTime | Sets the time for a date/time |
File | GetFileContentsAsBytes | Gets the contents of a file as a string |
GetFileContentsAsString | Gets the contents of a file as a string |
GetFileRecordSubstring | Gets a substring from a fixed length file record |
Lookup | LookupBulkLoadRecordId | Gets a record Id retrieved from a bulk load on a parent target |
LookupDataFieldValue | Loads a record and returns a specific data field |
LookupMappedFieldValue | The LookupMappedFieldValue initializes a table to be used for replacing an input value with a defined output value. Useful for mapping picklist or option set values. |
LookupPickListValue | Gets the key or description for a picklist |
LookupRetrievedIdFromAuditLog | Returns a table key value that has been saved in the audit logs table |
LookupRoundRobinValue | Supports the lookup of values in a round-robin fashion. This can be used for lead distribution, record assignment, etc. |
Numeric | CalculateRunningTotal | Adds a value to a running total |
FormatNumber | Returns the string representation of an integer, adding extra 0's to the right if the string is smaller than the specified number of characters. |
GetCurrentCounterValue | Returns the current value of a counter. |
GetNextCounterValue | Increments a counter and returns the new value. |
GetRunningTotal | Gets a running total |
GetRunningTotalAverage | Gets the average value in a running total |
GetRunningTotalCount | Gets the count of number of entries in a running total |
GetRunningTotalMaximum | Gets the maximum value in running total |
GetRunningTotalMinimum | Gets the minimum value in running total |
InitializeCounter | Initializes a counter of integer values. At any time, executing this action returns the current value of the counter. Use GetNextCounterValue to increment and get next counter value. |
InitializeRunningTotal | Initializes a running total. At any time, executing this action returns the current value of the counter. Use GetNextCounterValue to increment and get next counter value. |
String | AlternateCases | Returns a string with alternated letter casing(upper/lower). First character of the string stays the same |
Base64Decode | Decodes a Base64 string |
Base64Encode | Encodes a Base64 string |
Capitalize | Capitalizes the first character in a string |
CharMid | Returns the character at a position given by the startingIndex plus the given count. |
CharRight | Returns the character in a string at a given index counting from the right. |
Concatenate | Concatenates values into a string |
ConcatenateHtml | Inserts values into Html using the Html editor |
ConvertHtmlToPlainText | Converts a string from Html to plain text |
ConvertRtfToString | Converts Rtf to a string |
ConvertStringToRtf | Converts a string to Rtf |
Format | Returns a string formatted to match the format string |
FormatDataType | Returns a formatted datetime, decimal, double, integer or single value using .Net formatting |
GetEmptyString | Returns an empty string value |
GetHashCodePolynomial | Returns the hash code of a string based on a polynomial function with a specified factor. |
GetInitials | Returns the initials of each word in a string. Words are separated according to the sepecified string sequence. |
GetKeyFromGuid | Gets a Guid key |
GetKeyFromRandomNumber | Returns a key based on randomly generated number |
GetKeyFromTimestamp | Gets a Timestamp key |
GetLength | Returns the length of a string. |
GetNullString | Returns a null string value |
GetTitle | Returns the initials of each word in a string. Words are separated according to the sepecified string sequence. |
IndentLines | Returns a string with the given number of spaces prepended to the beginning of each line. |
InsertSeparator | Returns a string with a given seperator inserted after a specified interval of characters. |
InsertString | Inserts a string at a specified index position in the source string (0 origin) |
KeepAlphaNumeric | Returns a string with only alpha-numeric characters preserved. |
KeepVowels | Returns a string with only the vowel characters. |
PadLeft | Pads a string on the left with a specified character |
PadRight | Pads a string on the right with a specified character |
PrependLinesWithCharacter | Returns a string with the given number of a specific character prepended to the beginning of each line. |
RegexReplace | Within the source input string, replaces strings that match a regular expression pattern with a specified replacement string. |
RemoveCharacter | Removes a specified character from a string |
RemoveCharacters | Deletes a specified numer of characters in a string starting an index position (0 origin) |
RemoveLetters | Returns a string with any letter characters removed. |
RemoveNumeric | Returns a string with any numeric characters removed. |
RemoveRepeats | Returns a string with all characters repeated in a row removed. |
RemoveSegment | Returns a string with the first occurence of the specified string segment removed. |
RemoveVowels | Returns a string with any vowel character removed. |
ReplaceFirstOccurence | Returns a string with the first occurence of the specified value replaced with a new value. |
ReplaceLastOccurence | Returns a string with the last occurence of the specified value replaced with a new value. |
ReplaceLeadingCharacters | Returns a string with the first given number of characters replaced with a new character. |
ReplaceString | Replaces all occurences of an old string value with new string value |
ReplaceTrailingCharacters | Returns a string with the last given number of characters replaced with a new character. |
ReplaceWithEmptyString | Replaces all occurences of an old string value with an empty string value |
ReverseCharacters | Returns a string with characters in reverse order. |
Split | Gets a string by spliting a string and selecting from an index position (0 origin) |
SplitWithCharacterLimit | Splits a string into an array each no longer than the given character limit and selecting from an index position in the result (0 origin). |
Substring | Gets a substring from a string starting at an index position (0 origin) |
SubstringOfLength | Gets a substring of a specified length from a string starting at an index position (0 origin) |
SubstringOfRange | Returns a segment of a string, marked by the start and end index (exclusive). |
SwapCases | Returns a string with the opposite letter casing for each character. |
SwapCharacters | Returns a string the swapped characters at specified indices. |
ToLowercase | Converts a string to lowercase |
ToUppercase | Converts a string to UPPERCASE |
TrimAll | Removes all whitespace from a string |
TrimLeadingCharacters | Removes all leading occurences of a specified character from a string |
TrimTrailingCharacters | Removes all trailing occurences of a specified character from a string |
UrlDecode | Decodes a Url |
UrlEncode | Encodes a Url |
WordWrap | Returns a string that is no longer than the maximum width given in pixels. Excess words are moved to a new line. |
appRules Actions deliver a centralized and consistent approach for performing actions in all operations. The Actions Editor is shown below:
To select an Action type, simply navigate the action tree and configure the properties for the selected type. Once an action is created, it can be executed at any point in the running project by using the PerformAction activity in the BaseActivities module or through other built-in access points in appRules (SetValues, MapRecordfields...).
The Utility-Automation actions category includes the following modules and types:
The Actions-Fields-Library-Math module contains the following types:
The Utility-FileSystem actions category includes the following modules and types:
Module | Type | Description |
---|
Type | Description |
---|
Module | Type | Description |
---|
Module | Type | Description |
---|
Maintenance | PurgeLogEntries | The PurgeLogEntries activity is used for purging log entries from the project database |
RefreshDataSource | This activity refreshes the metadata for a data source |
RemoveDataSource | This activity removes the metadata for a data source |
UnlockProjectRecords | This activity unlocks project records |
Services | RunPowerShellScript | The RunPowerShellScript activity runs a PowerShell script |
RunSSISPackage | The RunSSISPackage activity runs an SSIS package |
StartService | The StartService activity starts a service on a server |
StopService | The StopService activity stops a service running on a server |
Abs | Returns the absolute value of a specified number. |
Acos | Returns the angle whose cosine is the specified number. |
Asin | Returns the angle whose sine is the specified number. |
Atan | Returns the angle whose tangent is the specified number. |
Atan2 | Returns the angle whose tangent is the quotient of two specified numbers. |
Cos | Returns the cosine of the specified angle. |
Cosh | Returns the hyperbolic cosine of the specified angle. |
DivideInt32GetQuotient | Calculates the quotient of two 32-bit signed integers |
DivideInt32GetRemainder | Calculates the remainder of dividing two 32-bit signed integers |
DivideInt64GetQuotient | Calculates the quotient of two 64-bit signed integers |
DivideInt64GetRemainder | Calculates the remainder of dividing two 64-bit signed integers |
E | Returns constant e - Euler's number |
Exp | Returns e raised to the specified power |
Log | Returns the natural (base e) logarithm of a specified number. |
Log10 | Returns the base 10 logarithm of a specified number. |
Max | Returns the maximum number from a list of numbers. |
Min | Returns the minimum number from a list of numbers. |
Pi | Returns the value of mathematical constant pi. |
Pow | Returns a double of a specified number raised to the specified power |
Sin | Returns the sine of the specified angle. |
Sinh | Returns the hyperbolic sine of the specified angle. |
Sqrt | Returns the square root of a specified number. |
Tan | Returns the tangent specified angle. |
Tanh | Returns the hyperbolic tangent specified angle. |
TruncateDecimal | Calculates the integral part of a specified decimal number. |
TruncateDouble | Calculates the integral part of a specified double number. |
DataRobot | CloseSource | Closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
LookupRecord | Fetches a specific record from a source connection |
SFEinsteinAnalytics | CloseSource | Closes the specified source connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
LookupRecord | Fetches a specific record from a source connection |
Splunk | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection |
DeleteRecord | Deletes the specified target record |
ExecuteStatements | Executes custom SQL statements on a connection |
GetNextRecord | Fetches the next record from the specified source connection |
InitializeSource | Initializes a connection for reading data records at run time. |
InitializeTarget | Initializes a connection where output records will be saved. |
LookupRecord | Fetches a specific record from a source connection |
MapRecordFields | Sets the values of the specified DataFields in a target connection |
SaveRecord | Saves the specified target record |
Files | FileACLAddEntry | The FileACLAddEntry activity adds an Access Control List (ACL) entry to a file |
FileACLRemoveEntry | The FileACLRemoveEntry activity removes Access Control List (ACL) entry from a file |
FileCopy | Copies files from one location to another |
FileDelete | The FileDelete activity deletes a file |
FileFTPDownload | The FileFTPDownload activity downloads a file from an ftp site |
FileFTPUpload | The FileFTPUpload activity uploads a file from an ftp site |
FileMove | Moves a file from a source to a destination |
FileUnzip | The FileZip activity unzips a file |
FileZip | The FileZip activity zips a file |
SaveValueInNewFile | The SaveValueInNewFile activity is used for saving field values to a file |
Folders | DirACLAddEntry | The DirectoryAddACLEntry activity adds an Access Control List (ACL) entry to a directory |
DirACLRemoveEntry | The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory |
DirCloseDirInfoSource | The DirectoryCloseDirectoryInfoSource activity closes the Directoryinfo source and frees up resources |
DirCloseFileInfoSource | The CloseSourceFileFile activity closes the DirectoryFileInfo source and frees up resources |
DirectoryCreate | The DirectoryCreate activity creates all the directories and subdirectories in the specified path |
DirectoryDelete | The DirectoryDelete activity deletes a directory and its subdirectories if specified |
DirectoryGetNextFileInfoRecord | The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory |
DirectoryInitializeDirectoryInfoSource | The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory |
DirectoryInitializeFileInfoSource | The DirectoryACLRemoveEntry activity removes an Access Control List (ACL) entry from a directory |
DirectoryMove | The DirectoryMove activity moves a directory from a source to a destination |
DirectoryZip | The DirectoryZip activity zips a directory |
DirGetNextDirInfoRecord | The DirGetNextDirInfoRecord activity loads the next record from the specified list of selected Directoryinfo |
Module | Type | Description |
---|---|---|
Access
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Btrieve
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
DB2
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a Source for reading data records
InitializeTarget
Initializes a Target for saving data records
LookupRecord
Fetches a specific record from a Source
MapRecordFields
Setting the values of the specified DataFields in a target
SaveRecord
Saves the specified target record
EmbeddedDB
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection for saving output data records.
LookupRecord
Gets a specific record from a data source
MapRecordFields
Maps values to specified DataFields in a target connection
SaveRecord
Saves the specified target record
Firebird
CloseSource
The CloseFirebirdSource activity closes the specified source connection
CloseTarget
The CloseFirebirdTarget activity closes the specified target connection
DeleteRecord
The DeleteFirebirdRecord activity deletes the specified target record
ExecuteStatements
The ExecuteFirebirdStatement activity is used to execute a custom sql statement on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
The GetNextFirebirdRecord activity fetches the next record from the specified source connection
InitializeSource
The InitializeFirebirdSource activity initializes a connection for reading data records at run time. Multiple InitializeFirebirdSource activites can be included in the workflow.
InitializeTarget
The InitializeFirebirdTarget is used for initializing a connection where output records will be saved. Multiple InitializeFirebirdTarget activites can be included in the workflow.
LookupRecord
The LookupFirebirdRecord activity fetches a specific record from a source connection
MapRecordFields
The MapAndSetFirebirdFields activity is used for setting the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Informix
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MariaDB
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
MySQL
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Odbc
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Loads a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
OleDb
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
LookupRecord
Loads a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Oracle
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
PostgreSQL
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
SqlAzure
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Loads a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
SqlServer
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteSQLScript
Executes a SQL Server Script file
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection for saving output data records.
LookupRecord
Gets a specific record from a data source
MapRecordFields
Sets the values of the specified DataFields in a target connection
RunSSISPackage
Runs a SSIS package
SaveRecord
Saves the specified target record - (Insert, Update, Upsert, Skipsert)
SqlServerCe
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
The ExecuteSqlServerCeStatement activity is used to execute a custom sql statement on a connection
GetNextRecord
Gets the next record from the specified source connection
InitializeSource
Initializes a source for reading records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Gets a specific record from a data source
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record - (Insert, Update, Upsert, Skipsert)
Sybase
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Teradata
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
Vertica
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
ExecuteStoredProcedure
Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializes a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record
xBase
CloseSource
Closes the specified source connection
CloseTarget
Closes the specified target connection
DeleteRecord
Deletes the specified target record
ExecuteStatements
Executes custom SQL statements on a connection
GetNextRecord
Fetches the next record from the specified source connection
InitializeSource
Initializes a connection for reading data records at run time.
InitializeTarget
Initializing a connection where output records will be saved.
LookupRecord
Fetches a specific record from a source connection
MapRecordFields
Sets the values of the specified DataFields in a target connection
SaveRecord
Saves the specified target record