Read

Write / Edit Data

Custom Actions

Database

• Microsoft SQL Server & Azure

Any query including dynamic parameters

All column with explicit or sub-query data validation

Any query including context parameters

• MySQL

Any query

• OleDB

Any query

• OData

Any url

• PosgreSQL

Any query

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

Custom Apps

• Asite Web API

Any workspace or folder, recursive

• Primavera P6 Web Services 8.2/8.3

Any program with udf and codes

• SiteSense Web API

Any project

• AIMS

Asset code, recursive including dynamic parameters

Generic attributes and some root properties

Hard coded asset creation

• BIMWatcher

Any published site with read permission

All columns edit permission

Publish over existing data

• BIMCollab

Issues list of any project

• SharePoint

Fields of any list

All fields as per user permissions, with values list detection when applicable

Create and delete items as per user permissions