Read

Write

Custom Actions

Database

• Microsoft SQL Server & Azure

any query + parametrised

all column with explicit or sub-query data validation

any query including SQL parameters, inferred from selected row(s), model object(s) or user input

• MySQL

any query

no

no

• OleDB

any query

no

no

• PosgreSQL

any query

no

no

File

• Text Files

all columns

all columns

add/delete a row with all columns

• Microsoft Excel NPOI

any sheet, pick columns

all columns with explicit or cell data validation

add/delete, pick included columns

• Microsoft Excel OleDB

any query

no

no

Custom Apps

• Asite Web API

any workspace or folder, recursive

no

no

• Primavera P6 Web Services 8.2/8.3

any program with udf and codes

no

no

• SiteSense Web API

any project

no

no

• AIMS

Asset code, recursive + parametrised

generic attributes and some root properties

hard coded asset creation