Skip to main content

Documentation Index

Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

A full index of every article in the Integrate.io ETL & Reverse ETL documentation. Use this page to browse all available guides across getting started, packages, sources, transformations, expressions, destinations, scheduling, alerts, security, and account management.

Getting Started

ETL Terminology

Workspaces

Clusters Overview

Packages Overview

Defining Connections

Creating a New Package

Creating a Workflow

Package Designer

Creating a Package from a Template

Package Creation Guide

Creating a Delivery

Import or Export Package JSON

Package Version Control

Component Previewer

Dynamic Connections

Advanced Search

Validating a Package

Amazon Redshift

Bing Ads

CDC Database

Database

Facebook Ads Insights

File Storage

Google Ads

Google Analytics

Google Analytics 4 (GA4)

Google BigQuery

Google Cloud Spanner

MongoDB

NetSuite

REST API

Salesforce

Mouseflow

SugarCRM

Amazon Athena

Amazon RDS

Amazon S3

DB2

Dynamics 365

FTPS

Google Cloud SQL for MySQL

Google Cloud SQL for PostgreSQL

Google Cloud Storage

Google Drive

Google Sheets

Google Sheets (Service Account)

HDFS

Heroku Postgres

HubSpot

IBM i (AS/400)

Instagram

Intercom

LinkedIn

Marketing Cloud (REST)

Marketing Cloud (SOAP)

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

SAP HANA

SFTP

SFTPToGo

Shopify

TikTok Ads

Universal OAuth

Xero

YouTube

API Ingestion Guide

Ingesting a Postman API Call

Moving Data Incrementally Between Databases

Reading File Storage Data Incrementally

Salesforce Objects Reference

Salesforce PK Chunking

Selecting File Input Format

API Endpoints with Pagination

Pattern Matching in Source Paths

Select Transformation

Filter Transformation

Join Transformation

Cross Join Transformation

Union Transformation

Aggregate Transformation

Distinct Transformation

Sort Transformation

Rank Transformation

Window Transformation

Limit Transformation

Sample Transformation

Clone Transformation

Assert Transformation

Cube Transformation

Functions Reference

Using Expressions

Using and Setting Variables

Global Variables

System and Pre-Defined Variables

ISO 8601 String Functions

Encrypting and Decrypting Data

Processing JSON Data

Processing XML Data

Processing Different Encodings

Working with Datetime Data

ABS

ACOS

AddDuration

ASIN

ATAN

BagToString

BagToTuple

Base64Decode

Base64DecodeToString

Base64Encode

Base64EncodeToString

BinaryCCurl

BinaryCurl

BrowserFamily

BrowserFullName

BrowserMajor

BrowserMinor

BrowserPatch

BrowserVersion

ByteArrayToString

CBRT

CCurl

CCurlPoll

CCurlWithPagination

CEIL

CityNameFromIP

ClockTime

COALESCE

CONCAT

ContinentCodeFromIP

ContinentNameFromIP

COS

COSH

CountryCodeFromIP

CountryNameFromIP

CSVSPLIT

Curl

CurlPoll

CCurlWithPagination

CurrentTime

DateDiffDays

DateDiffHours

DateDiffMinutes

DateDiffMonths

DateDiffSeconds

DateDiffYears

DaysBetween

Decrypt

DeviceFamily

DistInMilesHaversine

Encrypt

ExecuteBQInsert

ExecuteSqlBoolean

ExecuteSqlDateTime

ExecuteSqlDouble

ExecuteSqlFloat

ExecuteSqlInt

ExecuteSqlLong

ExecuteSqlNonQuery

ExecuteSqlString

EXP

ExtractQueryStringParam

ExtractSearchQuery

ExtractUABrowserID

ExtractUABrowserName

ExtractUrlPart

Flatten

FLOOR

GetBytes

GetDay

GetHour

GetMilliSecond

GetMinute

GetMonth

GetSecond

GetWeek

GetWeekYear

GetYear

HoursBetween

INDEXOF

INITCAP

IntervalIntersection

IsBase64

IsEmpty

IsISODatetime

ISOAddDuration

ISODatetimeToString

ISODatetimeToTimestampFormat

ISOSubtractDuration

ISOToDay

ISOToHour

ISOToMinute

ISOToMonth

ISOToSecond

ISOToWeek

ISOToYear

JsonExtract

JsonExtractScalar

JsonStringToBag

JsonStringToMap

LAST_INDEX_OF

LatitudeFromIP

LCFIRST

Length

LOG

LOG10

LongitudeFromIP

LOWER

MapToBag

MapToQueryString

MD2

MD5

MilliSecondsBetween

MinutesBetween

MonthsBetween

OsFamily

OsFullName

OsMajor

OsMinor

OsPatch

OsPatchMinor

OsVersion

ParseDate

ParseDoubleOrDefault

ParseFloatOrDefault

ParseIntOrDefault

ParseLongOrDefault

PlatformFamily

POW

QueryStringToMap

RANDOM

REGEX_EXTRACT

REGEX_EXTRACT_ALL

REGEX_FIND_ALL

RegionCodeFromIP

RegionNameFromIP

REPLACE

Reverse

ROUND

ROUND_TO

SecondsBetween

SHA1

SHA256

SHA256WithRSA

SHA384

SHA512

SIN

SINH

SIZE

Sleep

SPRINTF

SQRT

StringToISODatetime

STRSPLIT

STRSPLITTOBAG

SUBSTRING

SubtractDuration

SwitchTimeZone

TAN

TANH

TimestampFormatToISODatetime

TOBAG

ToDate

ToDateCustomFormats

ToHexString

ToJson

TOKENIZE

TOMAP

ToMilliSeconds

ToString

TOTUPLE

ToUnixTime

TRIM

UCFIRST

UPPER

URLDecode

URLEncode

UUID

WeeksBetween

XPath

XPathToBag

YearsBetween

Amazon Redshift

Database

Facebook Ads

File Storage

Google Ads

Google BigQuery

Google Spanner

HubSpot

MongoDB

NetSuite SOAP

Salesforce

REST API

Snowflake

TikTok Ads

Azure Blob Storage

Azure SQL

Azure Synapse Analytics

Running Jobs

Scheduling Package Execution

Monitoring Jobs

Viewing All Jobs in the Account

Viewing Completed Task Outputs

Viewing Job Error Details

Creating a Cluster

Editing and Scaling Clusters

Monitoring Clusters

Terminating a Cluster

Email Hooks

Slack Hooks

PagerDuty Hooks

Service Hooks

Web and Email Notifications

Two-Factor Authentication

Single Sign-On

User Management

Managing Account Members

Setting Account Member Roles

Changing Your Password

Password Policy

Managing SSH Keys

Reverse SSH Tunnel from Windows

Firewall Setup

IP Allowlist

Managing Account Settings

Modifying Personal Settings

Selecting an Account

Migrating from Development to Production

Selecting a Plan

Billing and Account Usage

Signing Out

Support Rates

Last modified on May 15, 2026