Getting Started
Concept Overview
- Data Transformations
- Sending Data
- Receiving Data
- Data Processing
- Process Queues
- Observers
- Progress Tracking
- Template Syntax
- Data Transform Scripting
- Memory Management
- Data Flow Reporting
- Connectors
- Authorizations
- Project Variables
Basic Data Flow Actions
Advanced Data Flows Actions
Transforms

DATABASE_READ

Allows data to be read from external databases. Supported databases include MySQL, SQL and Postgres.

Properties

Database Connection
dbread_connection

Collection / Table name
dbread_collection

Sort Key
dbread_sortKey

Sort Direction
dbread_sortDir

Page Size
dbread_pageSize

Page Number
dbread_pageNumber

Out Key
dbread_outkey

Record Identifier Template
dbread_recordIdentifierTemplate

Do Raw Query?
dbread_doRawQuery

Raw Query Value
dbread_rawQuery

Parse List Values (MSSQL)
dbread_allowListParsing

Include these query fields...
queryFields

A set of records that are used to define conditionals for use in database queries.