1 of 100

appRules® Documentation

Welcome to appRules®

Welcome to appRules® Online Guide

appRules offers a next-generation, no-code development environment that can be utilized by business and technical users to tackle data migration, data integration, business rules, and automation projects. appRules projects are developed using your preferred web browser and a drag and drop designer with activity modules that can be associated to compose simple or complex business processes, linked to a large choice of data sources.

appRules® – Powerful, No-Code Solutions

Data Migration, Replication, and Synchronization
Data Integration and Data Cleansing
Business Rules Engine
Process Automation
Machine Learning
Hundreds of connectors including CRM, ERP, Big Data, No-SQL, Analytics, and more
Dynamics 365, Salesforce, SAP, SharePoint, etc.

Why appRules®?

appRules is a popular choice when choosing a Business Rules, Data Migration, Data Integration and Process Automation software and has many advantages:

The appRules Platform powers our best-in-class product family and white label offerings by our platinum partners:

appRules Data Migration Engine

appRules Integration & Automation Engine

appRules Enterprise 360

On-Premise and Cloud
User-friendly; drag-and-drop workflow designer
Data Source Browser
Data Migration Engine offering migration, replication and synchronization
Business Rules Engine offering decision tables, rulesets and more.
Web API Service
Scheduler Service
Powerful and configurable Conditions
Powerful and configurable Actions
Powerful and configurable Workflow Activities

PLATFORM

appRules® Concepts & Features

Overview

Before jumping in to start composing and orchestrating your projects with appRules, it is recommended that you review this section to get a basic idea of the concepts that drive appRules.

The concepts are not discussed in detail here but are rather presented in a concise manner to help you hit the ground running. In addition to understanding the concepts and features, this section will also introduce you to the most frequently used terms in appRules.

While appRules features so many options, only the key common features are included in this section.

No-Code Environment

appRules is a no-code environment that includes thousands of configurable options for performing all design and runtime tasks for data migration, data integration, business rules and process automation.

Conditions

Simple and complex conditions to be evaluated by the system can be defined and maintained without writing code.

Actions

Simple and complex actions to be performed by the system during processing can be defined and maintained without writing code.

Workflow Activities

The actual work performed by appRules projects are done through the execution of one or more workflow activities. Workflow activities in appRules are actually actions and conditions participating in orchestration.

A workflow activity takes input and gives output and contains user-configurable variables and properties. appRules workflow activities are grouped into modules that can be configured to complete a process. appRules activities are able to move and share data between modules and also with external systems.

Each module is specific to the features of the application that it supports -- including files, databases, SaaS etc.

The process of composing your projects (workflows), involves dragging activities on to the designer, configuring the associated properties, and associating them in a logical sequence order.

appConnector Modules

appRules is based on appStrategy’s appConnector technology. appConnector technology delivers software libraries that connect a wide variety of applications and data sources.

appConnector functionality is based on workflow activities that are packaged in modules related to the job they perform as a group.

To use a module, refer to its documentation in the Data Sources section.

The appRules Data Migration Engine

The appRules Data Migration Engine is a powerful engine based on the appRules platform that supports several data migration options include replication and synchronization. appRules Data Migration engine works with hundreds of data sources. It is sold as a separate appRules platform product.

The appRules Integration & Automation Engine

The appRules Integration & Automation Engine is a powerful engine based on the appRules platform that supports integration, automation, and business rules processes. Decision Tables, Rule Sets and other features are included in the appRules Integration & Automation Engine. It is sold as a separate appRules platform product.

appRules Enterprise 360

appRules Enterprise 360 is the enterprise suite that includes the appRules Data Migration Engine and the appRules Integration & Automation Engine - the All-In-One package.

Composing And Orchestrating Projects

In appRules, projects are composed and orchestrated as opposed to being programmed or developed. Using appConnector modules with powerful activities featuring easy-to-use and reusable editors makes this possible.

To compose projects in appRules, you simply drag and drop activities from the toolbox onto the designer and associate them in sequence using control flow activities (while, if, sequence …):

The appRules Embedded Database

appRules includes a Microsoft SQL Server compatible embedded database that you can use to host your small and mid-size projects. No installation or configuration is required for the appRules Embedded Database - it is automatically installed and configured.

Project Databases

appRules stores projects in project databases. Your project database can contain a few, or unlimited number of projects. You can also maintain several project databases and synchronize data between project databases. This feature makes it easy for you to maintain separate environments for Development, Test and Production.

Project databases are not just used for storing your job definitions. They also store other data including data source definitions, lists, settings and logs. appRules currently supports the appRules Embedded Database and Microsoft SQL Server as project databases. The appRules Embedded database is used mostly for development and for small and medium deployments. It requires little or no resources to create and maintain. The samples supplied with appRules are in the appRules Embedded database.

appRules includes utilities (CheckIn/CheckOut) that allow you to move your project database from one format to another.

The Samples Project Database

A project database named Samples is installed along with your edition of the appRules software product.

The Samples database contains several examples that show you how to hit the ground running with appRules.

In addition, a database named Northwind containing test data is also automatically installed on your computer.

Before running other sample projects (non-Northwind samples), make sure that you properly configure the required settings (connection strings, authentication etc.).

Runtime Settings

Most software projects consume a lot of time at runtime (configuring registry settings, checking activations, connection strings, file locations, location specific defaults, etc.). To alleviate these problems, appRules includes Runtime Settings that you can use to define how your projects will be deployed -- even before the projects are composed. For example, you can create runtime settings for Development, Test and Production. You can also create runtime settings for departments, teams and locations. There is no limit to the number of runtime settings that you can define. Runtime Settings are linked to users running the projects.

Data Source Settings

appRules relies on data source metadata for all processing. Metadata is generated from the data sources and stored in the project database.

When creating a data source, appRules gathers not only information related to entities or table metadata, but also any additional information included in the database of applications including pick lists and data mapping information.

Sourced Values

To deliver a code-free environment where projects can be created and deployed quickly, appRules employs “Sourced Values”. In simple terms, a Sourced Value allows you to quickly select a source for a value and an identifier for it. To specify a sourced value, you select the Source and then specify a value identifier (Source Value Identifier). Below are some examples of the many sourced values used in appRules:

Source

Value Identifier

String

The String source allows you to enter any value in the value identifier. Example: “Constant:John Smith”

DataFieldValue

The DataFieldValue source gets a value from a record that exists in a specific Source or Target in the project. Example: “Employees.LastName” gets the value of the LastName column in the Employees record.

DateTime

The DateTime sourced value points to a date/time related value. They can also be used to specify other date/time related data. Example: “DateTime.DateTimeNow” generates the current date/time.

ActionField

The ActionField source allows you to select results of specific actions

The above examples give you an idea of how Sourced Values are defined and used in appRules. There are over one hundred Sourced Values and associated types that you can use to specify data anywhere in your projects.

By providing a rich set of editors and controls to manage Sourced Values, appRules is able to provide a very powerful and flexible combination that gives users the fastest and most compact environment for configuring actions, conditions, activities and orchestrating processes.

Sourced Values in Property Grid

Below are examples of Sourced Value controls on the property grid at design time:

Data Managers

Data Managers are a special set of workflow activities that can be initialized as Sources or Targets in the appRules project. Source Data Managers retrieve data records from a data source and make the records and values in them available for other modules in the project. Target Data Managers are used for saving records to a specific data source. The properties, connectors configuration options, and execution context of Data Managers is based on the parent module of the Data Manager.

appRules projects can support an unlimited number of Source and Target Data Managers in the same project. And you can define configuration values using values from unrelated Sources/Targets and even dynamic values. A standard Source can be initialized using an InitializeSource activity and a standard Target activity can be initialized using an InitializeTarget activity.

In addition to standard Data Managers (Source & Target), appRules also supports derived Data Managers such as Lists, Lookups, PreloadedRecords, PickLists, etc.

appRules persists the values of the current records of Data Managers so they can be utilized by other activities using the DataFieldValue Sourced Value. Some appConnector modules provide additional Data Managers that are specific to the data source.

Logs and Statistics

You can configure your appRules project to log as much information as possible regarding the process. Several selections are included for viewing logs and other project runtime data. After running the job or while it is still running, you can view all details related to the job, including Condition, Action and Activity statistics, Source and Target statistics, performance logs and error logs.

Platform Overview

Powerful & Configurable Engine

The appRules Platform is a powerful and configurable engine that powers the appStrategy product suite.

Unique & Simple Design

At its core, the platform utilizes metadata, sourced values, actions and conditions to deliver the most robust and configurable environment on the market today.

For Mission-Critical Projects

appRules offers purpose-built engines for business rules, data migration, integration, automation, and machine learning.

Unmatched Scalability

The appRules Platform offers unmatched scalability. You can run on a single desktop or on a multi-server configuration.

On-Premise, Cloud and Web

Deploy on-premise, in the cloud and on the web.

Platform Features

Sourced Values

Overview

Sourced Values Overview

Source

Value Identifier

The above examples give you an idea of how Sourced Values are defined and used in appRules. They can be used to get and set data anywhere in your projects.

By providing a rich set of editors to manage Sourced Values, appRules is able to provide a very powerful and flexible combination that gives users the fastest and most compact environment for configuring workflow activities, actions, conditions, and orchestrating processes.

Sourced Values Examples

Sourced Values in Query Configuration

Below is an example of Sourced Values used for configuring a query:

Sourced Values in Mapping

The example below shows Sourced Values in use for mapping.

Sourced Values List

Below is the full list of Sourced Values:

Source

Value Identifier

ActionField

Argument

Get/Set value using an argument passed to the project. Use button to select or define arguments.

CalendarYear

Concatenation

Get/Set value by concatenating multiple values including text, Data Fields, etc.

ConditionResult

Get/Set result of executing a Condition

ConnectionString

Get/Set value by configuring a connection string.

DataFieldValue

Get/Set value using the current value of a field in the current record of a Source or Target activity in the project.

Date

Get/Set value using a Date. Use editor button to enter a Date, select Date function, add TimeSpan etc.

DateTime

Get/Set value using a DateTime. Use button to enter a DateTime, select DateTime function, add TimeSpan, etc.

Decimal

Get/Set value using a Decimal value.

RuntimeSettingField

Get/Set value from a pre-defined runtime setting field. Use editor button to select or define Runtime Setting Fields.

Double

Get/Set a value using a Double data type.

DynamicValue

Get/Set value using an appRules dynamic value. You can use one of the predefined values or enter a unique name.

Expression

Get/Set value from the result of executing an expression (JavaScript). Use editor button to enter Expression.

FilePath

Get/Set value as file path in file system

FiscalYear

Guid

Html

Single

Get/Set value as Single data type.

SourceDataFieldValue

Gets a data field value in the current Source.

String

Get/Set value as String data type.

TargetDataFieldValue

Gets a data field value in the current Target.

System

Get/Set a System value

TimeSpan

Get/Set value as TimeSpan

Variable

Get/Set value using a pre-defined Variable. Use button to select or define Variables

Actions

Overview

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...).

Action Categories

Actions-DataSource

Accounting

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

AIMachineLearning

Module

Type

Description

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

Analytics

AdobeAnalytics

CloseSource

The CloseAdobeAnalyticsSource activity closes the specified source connection

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

ApplicationPlatforms

Module

Type

Description

CalendarsAndContactMgrs

Module

Type

Description

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

CloudStorage

Module

Type

Description

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

Collaboration

Module

Type

Description

ECommercePlatforms

Module

Type

Description

Accounting

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

DataWarehouse

Module

Type

Description

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

CRM

Module

Type

Description

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)

Databases

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

ERP

Module

Type

Description

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)

Conditions-Fields

The Fields condition category contains the following conditions categorized as follows:

Workflow Activities

Overview

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

appConnector Base Activities

Control Flow Module

The Control Flow activities module provides activities for controlling flow of execution within your project.

Control Flow Activities

Note that while activities such as the Parallel and schedule multiple child activities for execution simultaneously, only a single thread is used for a workflow. Each child activity of these activities executes sequentially and successive activities do not execute until previous activities either complete or go idle. As a result, these activities are most useful for applications in which several potentially blocking activities must execute in an interleaved fashion. If none of the child activities of these activities go idle, a Parallel activity executes just like a Sequence activity.

Activities

The table below shows the activities in the Control Flow activities module and their key properties.

Activity

Description

FlowDecision

Parallel

Sequence

While

Switch

Base Module

The appRules Base activities module includes activities that are used for initializing your project, closing the project, executing functions, calling other projects and more.

Activities

The table below shows the activities in the appRules Base module including their key properties.

Activity

Description

CallWebService

This activity is used to make a webservice call.

Delay

This activity is used to delay the workflow execution.

ExecuteCustomCode

Executes a custom function, expression or script

ExecuteConditionCode

Executes a condition function, a condition expression or a condition script.

ExecuteWorkflow

This activity executes a workflow WorkflowName The name of the project to execute Parameters Parameters to pass to the workflow. Parameters must match the workflow arguments. SaveResultIn If the job returns a value, this specifies where to save the returned value.

MapAndSaveRecords

Most appConnector activity modules contain a mapping activity. For example, the MapAndSetFields in the File module maps file fields to be saved to file. The MapAndSaveRecords activity is a generic mapping activity for bulk-loading of records since it automatically inserts all Source records into the Target. The “SQL -- Batch Export to File” project in the Samples database demonstrates the use of this activity

SendEmail

This activity is used for sending an email to one or more recipients. You can also use this activity to send bulk emails. FromEmail The Email address that will be used for sending the email FromName Optionally, the name to use for sending the email ReplyTo The ReplyTo email address Subject The subject of the email To Recipients of the email BCC The blind carbon copy recipients of the email CC The carbon copy recipients of the email. Body The body of the email. This can be defined using Text or Html.

SetValues

TransformValues

UpdateWorkflowState

This is an optional activity for updating the current state of a running job -- normally this is done automatically.

WriteLogEntry

This is an optional activity for logging entries in the project database: LogEntryType The type of entry to be logged DataSourceRecord, DataSourceStatistics, Error, Message, Warning, or SelectedValues LogText The message to display if LogEntryType is Message DataManager Specifies the Source or Target if LogEntryType is DataSourceRecord, DataSourceStatistics or SelectedValues. SelectedValues Values to log if LogEntryType is SelectedValues

Dialogs Module

The appConnector Dialogs activities module contains activities for entering or viewing values during runtime or test runs of your project.

Activities

The table below shows the activities in the Dialogs module. The activities display the values when the project is run. Viewers activities are displayed when the workflow is run in debug mode.

Activity

Description

EditRecord

Edit the content of a source or target record (et with a InitializeSource a LookupRecord or a InitializeTarget activity)

EditWorkflowValues

Edit preselected workflow values (Arguments, Variables, Datafields (from source or target)

MessageBox

Shows a Message Box that can display workflow values or constants If Cancel clicked = ends execution, if Yes or OK Clicked returns Valid, If No Clicked returns Invalid

ShowDialog

Calls an external assembly that displays the dialog

ViewRuntimeArguments

Displays the workflow arguments values.

ViewRuntimeValues

Displays a selected set of values (can be datafields, arguments, variables…)

ViewRuntimeStatistics

Displays the Source and Target stats (Read, Update. Insert, Delete)

Record Module

The appConnector Record activities module contains activities for managing the data field values of active records of Source and Target activities in your project. The module also contains the generic GetNextPreloadedRecord activity which can be used to get the next record from a preloaded list of records.

Activities

The table below shows the activities in the appConnector Record module including their key properties.

Activity

Description

ClearRecord

Removes the field values of the active record of a Source or Target.

CopyRecord

Copy a record from one Source or Target to another.

FormatFields

This activity formats the field values of a Source or Target record.

GetNextPreloadedRecord

Gets the next record from a preloaded list of records in a Source activity.

InitializeRecordFromCustomValues

Initialize a target record with preset values

InitializeRecordFromDelimitedString

Initialize target records from file records

InitializeRecordFromFunction

Initialize target records with a custom function

UnformatFields

This activity removes all formatting from the field values of a Source or Target record.

ValidateRecord

This activity validates the fields in a Source or Target record.

List Module

The appConnector List activities module contains activities for creating ad-hoc lists that can be used in the project. This module also contains activities for managing pick lists that are created in the metadata for systems such as Dynamic CRM, Salesforce.com and others.

Activities

The table below shows the activities in the appConnector List module including their key properties.

Activity

Description

InitializeList

This activity used for defining the list (table). A list can be typed directly or can be loaded from a CSV file (see below) FieldNames Used for specifying the column names of the list Each list contains a uniquekey field and n columns (indicated in the NumberOfFields property) ListEntries Click to display the List creation/update window LoadFirstListItem Check this option in order to preload the first record of the list InitializeFromCsvFile Use this option to load the list from a CSV file.

InitializeListFromCustomValues

Initializes a list from custom values.

InitializeListFromDelimitedString

Initializes a list from a delimited string.

InitializeListFromFunction

Initializes a list from a custom function. The function must return list values in List<string>

CloseList

Closes an open list defined by an InitializeList activity

LookupList

To Lookup a list record List The InitializeList source to lookup ListFilters Collection of filters to query the list records to load ValueNotFoundAction Specifies the action to perform if no record is found ContinueWorkflow: Continues running the process LogNotFoundError: Logs a “RecordNotFound” error ExecuteFunction: Executes an extension function ValueNotFoundFunction Specifies the function to execute if the List item is not found

GetNextListItem

Gets the next List item as a record that can be used in the project

IsPickListValueValid

Checks to see if a PickList Value is valid

LookupPickListRecord

Looks up a picklist record

GetNextListItem

Gets the next list item as a record when iterating a list

IsPickListValueValid

Validates if a picklist value is valid

IsValueInCustomValuesList

Checks to see if a value is in a custom values list

IsValueInDelimitedStringList

Checks to see if a value is in a delimited string list

IsValueInFunctionList

Checks to see if a value is in a function list

LookupPickListRecord

Looks up a picklist as a record

Apache HBase

The connector for Apache HBase connects to Apache HBase via the HBase REST (Stargate) server.

Set the Port and Server properties to connect to Apache HBase.

The Server property will typically be the host name or IP address of the server hosting Apache HBase. If there are multiple nodes, you will use the host name or IP address of the machine running the REST (Stargate) server.

1.1 Starting the Server

Different Hadoop distributions contain different interfaces and means of starting and stopping the HBase REST server, along with different default port settings.

In most distributions, the HBase REST server can be started in the foreground by running the following command: "hbase rest start -p <port>". Please consult your Hadoop distribution's documentation for further information regarding the HBase REST server.

1.2 Authenticating to Apache HBase

The connector for Apache HBase supports authentication over Basic and Negotiate.

1.2.1 No Authentication

By default, no authentication (or anonymous auth) is used. Set AuthScheme to None to explicitly enforce no authentication.

1.2.2 Authenticating with Basic

Basic authentication may be used by setting AuthScheme to Basic. In addition, set the following:

User: The Apache HBase user;
Password: The Apache HBase password;

1.2.3 Authenticating with Kerberos

To authenticate with Kerberos, set AuthScheme to NEGOTIATE and set the User and Password.

To authenticate to Apache HBase using Kerberos, set the following properties:

AuthScheme: Set this to KERBEROS
KerberosKDC: Set this to the host name or IP Address of your Kerberos KDC machine.
KerberosSPN: Set this to the service and host of the Apache HBase Kerberos Principal. This will be the value prior to the '@' symbol (for instance, hbase/MyHost) of the hbase.regionserver.kerberos.principal of the hbase-site.xml file (for instance, hbase/MyHost@EXAMPLE.COM).

1.2.3.1 Retrieve the Kerberos Ticket

You can use one of the following options to retrieve the required Kerberos ticket.

1.2.3.2 MIT Kerberos Credential Cache File

This option enables you to use the MIT Kerberos Ticket Manager or kinit command to get tickets. Note that you won't need to set the User or Password connection properties with this option.

Ensure that you have an environment variable created called KRB5CCNAME.
Set the KRB5CCNAME environment variable to a path pointing to your credential cache file (for instance, C:\krb_cache\krb5cc_0 or /tmp/krb5cc_0). This file will be created when generating your ticket with MIT Kerberos Ticket Manager.
To obtain a ticket, open the MIT Kerberos Ticket Manager application, click Get Ticket, enter your principal name and password, then click OK. If successful, ticket information will appear in Kerberos Ticket Manager and will now be stored in the credential cache file.
Now that the credential cache file has been created, the provider will use the cache file to obtain the kerberos ticket to connect to Apache HBase.

As an alternative to setting the KRB5CCNAME environment variable, you can directly set the file path using the KerberosTicketCache property. When set, the provider will use the specified cache file to obtain the kerberos ticket to connect to Apache HBase.

1.2.3.3 Keytab File

If the KRB5CCNAME environment variable has not been set, you can retrieve a Kerberos ticket using a Keytab File. To do this, set the User property to the desired username and set the KerberosKeytabFile property to a file path pointing to the keytab file associated with the user.

1.2.3.4 User and Password

If both the KRB5CCNAME environment variable and the KerberosKeytabFile property have not been set, you can retrieve a ticket using a User and Password combination. To do this, set the User and Password properties to the user/password combo that you use to authenticate with Apache HBase.

1.2.3.5 Cross-Realm Authentication

More complex Kerberos environments may require cross-realm authentication where multiple realms and KDC servers are used (e.g. where one realm/KDC is used for user authentication and another realm/KDC used for obtaining the service ticket).

In such an environment, the KerberosRealm and KerberosKDC properties can be set to the values required for user authentication. The KerberosServiceRealm and KerberosServiceKDC properties can be set to the values required to obtain the service ticket.

The following are the connection properties for Apache HBase. Not all properties are required. Enter only property values pertaining to your installation. Several properties will be automatically initialized with the appRules defaults.

Property

Description

Authentication

AuthScheme

The scheme used for authentication. Accepted entries are NONE, BASIC, and NEGOTIATE (Kerberos). NONE is the default.

PageSize

The number of results to return per page from Apache HBase.

Password

The password used to authenticate to Apache HBase.

Port

The port for the Apache HBase REST server.

Server

The host name or IP address of the Apache HBase REST server.

User

The user who is authenticating to Apache HBase.

Firewall

FirewallPassword

A password used to authenticate to a proxy-based firewall.

FirewallPort

The TCP port for a proxy-based firewall.

FirewallServer

The name or IP address of a proxy-based firewall.

FirewallType

The protocol used by a proxy-based firewall.

FirewallUser

The user name to use to authenticate with a proxy-based firewall.

Kerberos

KerberosKDC

The Kerberos Key Distribution Center (KDC) service used to authenticate the user.

KerberosKeytabFile

The Keytab file containing your pairs of Kerberos principals and encrypted keys.

KerberosRealm

The Kerberos Realm used to authenticate the user with.

KerberosSPN

The service principal name (SPN) for the Kerberos Domain Controller.

Logging

Logfile

A path to the log file.

MaxLogFileCount

A string specifying the maximum file count of log files. When the limit is hit, a new log is created in the same folder with the date and time appended to the end and the oldest log file will be deleted.

MaxLogFileSize

A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.

Verbosity

The verbosity level that determines the amount of detail included in the log file.

Misc

ConnectionLifeTime

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.

ConnectionString

***

DatetimeFormat

The format used when inserting datetime values into the database.

MaxRows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Other

These hidden properties are used only in specific use cases.

PoolIdleTimeout

The allowed idle time for a connection before it is closed.

PoolMaxSize

The maximum connections in the pool.

PoolMinSize

The minimum number of connections in the pool.

PoolWaitTime

The max seconds to wait for an available connection.

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Readonly

You can use this property to enforce read-only access to Apache HBase from the provider.

RetrieveSelectedColumnsOnly

Specifies whether to retrieve selected columns only when executing a SELECT statement.

RowScanDepth

The number of rows to scan to determine columns for the table.

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

SupportEnhancedSQL

This property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

TypeDetectionScheme

Determines how to determine the data type of columns.

UseConnectionPooling

This property enables connection pooling.

Proxy

ProxyAuthScheme

The authentication type to use to authenticate to the ProxyServer proxy.

ProxyAutoDetect

This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

ProxyExceptions

A semicolon separated list of hosts or IPs that are exempt from connecting through the ProxyServer .

ProxyPassword

A password to be used to authenticate to the ProxyServer proxy.

ProxyPort

The TCP port the ProxyServer proxy is running on.

ProxyServer

The hostname or IP address of a proxy to route HTTP traffic through.

ProxySSLType

The SSL type to use when connecting to the ProxyServer proxy.

ProxyUser

A user name to be used to authenticate to the ProxyServer proxy.