Base Data Activities

Overview

appConnector Base Activities are made up the most commonly used activity modules in the appRules product suite.

appConnector Base Activities

Base Data Module

The Base Data activities module provides activities for generalized data access in your project.

Base Data Activities

BaseData Activities

Activities

The table below shows the activities in the Base Data Activities module and their key properties. The Base Data activities can be applied to all data sources defined in the current project.

Activity	Description
ClearRecord	This activity clear the current record content of a selected source or target
CloseSource	This activity closes a selected source
CloseTarget	This activity closes a selected target
CopyRecord	This activity copies the record content from the specified source to the specified target (source and target must have the same data definition)
DeleteRecord	This activity deletes a target record(s) based on a filter defined
ExecuteSQLScript	Execute a SQL script on a specific target
ExecuteStatements	Execute a SQL statement on a specific datasource
ExecuteStoredProcedure	Execute a storedprocedure of a specific datasource
InitializeSource	Initialize a datasource table/entity for reading
InitializeTarget	Initialize a datasource table/entity for Insert/Update/Delete
GetNextRecord	Read the next record of an InitializeSource loading multiple records.
InitializeSourceList	Creates and read an organized list of values (can be set from a csv file or adhoc (activity preset))
InitializeTargetFile	Initialize a text/csv file target
LookupRecord	This activity is used to lookup a record based on filters (example: loads the company record from a company table based on the contact table companyid field)
MapAndSaveRecords	Maps and Save multiple records in a target based on the source content.
MapRecordsFields	Maps the target fields from multiple sources (records, variables, transformedfields etc)
PerformRecordListAction	Perform a specific action on a preloaded list of records
SaveRecord	Save a specific target record (Insert,Update,Upsert,Skipsert)