(888) 884 6405
Sign In
Integrate.io
  • Integrate.io
  • Home
  • Products
    Bidrectional Salesforce Sync
    Transform and load enriched data into Salesforce. Easier than MuleSoft, more powerful than Data Loader.
    Learn More
    Data Transformation
    Build low-code pipelines to load and transform data from any source. Accelerate your path to analytics-ready data.
    Learn More
    Database Replication
    Effortlessly replicate to your data warehouse with sub 60-second latency. Power real-time dashboards & AI/ML initiatives.
    Learn More
    File Prep & Delivery
    Automate the chaos of file-based workflows. From SFTP & Excel to clean, transformed outputs.
    Learn More
  • Solutions
    Our Superpowers
    It’s time consuming trying to understand what each platform’s strengths are. Here are ours on a plate.
    Learn More
    Initiative
    Loading Data to Salesforce
    B2B Data Sharing
    File Data Preparation
    Power Data Products
    See All Initiatives
    Industry
    Employee Benefits
    Manufacturing
    Healthcare
    Financial Services
    See All Industries
    Integrate.io AI
    Bring AI to every step of your data process: prepare your data, apply models at scale, access GPU power instantly, and create pipelines with simple prompts.
    Learn More
  • Connectors
  • Plans
  • More
    Blog
    Compare Us
    Support & Resources
    Security
    Case Studies
    White Papers
    Webinars
    Documentation
    About
  • Get A Demo
Press Enter to see full results

ETL & Reverse ETL
Knowledge Base

ETL & Reverse ETL Knowledge base

Getting started

5 Articles
  • Getting Started
  • Integrate.io ETL terminology
  • Integrate.io ETL's Workspaces
  • Integrate.io ETL's clusters
  • Integrate.io ETL's packages

How Do I ...

12 Articles
  • API Ingestion Guide with Integrate.io
  • Encrypt and Decrypt Sensitive Data
  • How Do I Import or Export a Package's JSON Source Code
  • How Do I Move data incrementally between databases
  • How Do I Process JSON data
  • How Do I Process XML data
  • How Do I Process a Different Encoding
  • How Do I Read data from file storage incrementally
  • How Do I Use Package Version Control
  • How Do I Work with Datetime Data
  • How do I select my file input format
  • Ingesting A Working Postman API Call With Integrate.io's API Connector

Connectivity And Security

52 Articles
  • 2-Factor Authentication
  • Allow Integrate.io ETL access to my data on Azure Blob Storage
  • Allowing Integrate.io ETL access to Azure SQL Databases
  • Allowing Integrate.io ETL access to Azure Synapse Analytics
  • Allowing Integrate.io ETL access to Facebook Ads Insights data
  • Allowing Integrate.io ETL access to Google Cloud SQL for MySQL databases
  • Allowing Integrate.io ETL access to Google Cloud SQL for PostgreSQL databases
  • Allowing Integrate.io ETL access to Heroku Postgres Databases
  • Allowing Integrate.io ETL access to Hubspot
  • Allowing Integrate.io ETL access to Marketing Cloud (SOAP)
  • Allowing Integrate.io ETL access to Microsoft SQL Server Databases
  • Allowing Integrate.io ETL access to MongoDB
  • Allowing Integrate.io ETL access to MySQL Databases
  • Allowing Integrate.io ETL access to NetSuite JDBC(Source)
  • Allowing Integrate.io ETL access to NetSuite SOAP
  • Allowing Integrate.io ETL access to Oracle databases
  • Allowing Integrate.io ETL access to PostgreSQL Databases
  • Allowing Integrate.io ETL access to SAP HANA Databases
  • Allowing Integrate.io ETL access to data on Amazon S3
  • Allowing Integrate.io ETL access to my Amazon Athena instance
  • Allowing Integrate.io ETL access to my Google Analytics 4 (GA4)
  • Allowing Integrate.io ETL access to my Google BigQuery dataset
  • Allowing Integrate.io ETL access to my Google Cloud Spanner instance
  • Allowing Integrate.io ETL access to my Marketing Cloud (REST)
  • Allowing Integrate.io ETL access to my Redshift cluster
  • Allowing Integrate.io ETL access to my Snowflake account
  • Allowing Integrate.io ETL access to my data on Bing Ads
  • Allowing Integrate.io ETL access to my data on Dynamics 365
  • Allowing Integrate.io ETL access to my data on File Transfer Protocol Secure (FTPS)
  • Allowing Integrate.io ETL access to my data on Google Ads
  • Allowing Integrate.io ETL access to my data on Google Analytics
  • Allowing Integrate.io ETL access to my data on Google Cloud Storage
  • Allowing Integrate.io ETL access to my data on Google Cloud Storage
  • Allowing Integrate.io ETL access to my data on Google Drive
  • Allowing Integrate.io ETL access to my data on Google Sheets
  • Allowing Integrate.io ETL access to my data on Hadoop Distributed File System (HDFS)
  • Allowing Integrate.io ETL access to my data on Instagram
  • Allowing Integrate.io ETL access to my data on Intercom
  • Allowing Integrate.io ETL access to my data on Linkedin
  • Allowing Integrate.io ETL access to my data on Salesforce
  • Allowing Integrate.io ETL access to my data on Salesforce (SOAP)
  • Allowing Integrate.io ETL access to my data on Salesforce using Customer-Managed OAuth
  • Allowing Integrate.io ETL access to my data on Secure File Transfer Protocol (SFTP)
  • Allowing Integrate.io ETL access to my data on Shopify
  • Allowing Integrate.io ETL access to my data on Xero
  • Allowing Integrate.io ETL access to my data on YouTube
  • Allowing Integrate.io ETL access to my server behind a firewall
  • Allowing Integrate.io ETL access to relational databases on Amazon RDS
  • Allowing access to my file data on SFTPToGo
  • Set up a reverse SSH tunnel from Windows
  • Single Sign-On
  • User Management Overview

Creating packages

55 Articles
  • Advanced Package Search
  • Creating a new package in New Integrate.io ETL
  • Creating a workflow
  • Global Variables (Account Level)
  • Integrate.io ETL Functions
  • System and pre-defined variables
  • Using Components: Google Ads Destination
  • Using Components: Google Analytics 4 (GA4) Source
  • Using Components: Select with Curl as Rest API Destination
  • Using Components: Window
  • Using Expressions in Integrate.io ETL
  • Using ISO 8601 string functions
  • Using and setting variables in your packages
  • Using components: Aggregate Transformation
  • Using components: Amazon Redshift Destination
  • Using components: Amazon Redshift Source
  • Using components: Assert Transformation
  • Using components: Bing Ads Source
  • Using components: Clone transformation
  • Using components: Cross Join Transformation
  • Using components: Cube transformation
  • Using components: Database Destination
  • Using components: Database Source
  • Using components: Distinct transformation
  • Using components: Facebook Ads Destination
  • Using components: Facebook Ads Insights Source
  • Using components: File Storage Destination
  • Using components: File Storage Source
  • Using components: Filter Transformation
  • Using components: Google Ads source
  • Using components: Google Analytics Source
  • Using components: Google BigQuery Destination
  • Using components: Google BigQuery Source
  • Using components: Google Cloud Spanner Source
  • Using components: Google Spanner Destination
  • Using components: HubSpot Destination
  • Using components: Join Tranformation
  • Using components: Limit Transformation
  • Using components: MongoDB Destination
  • Using components: MongoDB Source
  • Using components: NetSuite SOAP Destination
  • Using components: NetSuite Source
  • Using components: Rank Transformation
  • Using components: Rest API Source
  • Using components: Salesforce Destination
  • Using components: Salesforce source
  • Using components: Sample Transformation
  • Using components: Select Transformation
  • Using components: Snowflake Destination
  • Using components: Sort Transformation
  • Using components: Union Transformation
  • Using components: Window Transformation
  • Using pattern-matching in source component paths
  • Validating a package
  • Working in the new package designer

Using clusters

4 Articles
  • Creating a cluster
  • Editing and scaling clusters
  • Monitoring clusters
  • Terminating a cluster

Running and monitoring jobs

8 Articles
  • Monitoring jobs
  • Running jobs
  • Scheduling Package Execution
  • To view job progress details
  • Viewing all jobs in the account
  • Viewing completed tasks outputs
  • Viewing job error details for failed jobs
  • Viewing jobs in a specific cluster

Configuring your Integrate.io ETL environment

13 Articles
  • Changing your password
  • Defining connections
  • Managing your Integrate.io ETL account members
  • Managing your SSH public keys
  • Managing your account settings
  • Modifying your personal settings
  • Pipeline Development Lifecycle Best Practices
  • Selecting a plan
  • Selecting the account to work in
  • Setting account member roles
  • Signing out from Integrate.io ETL
  • Viewing and modifying your billing information and account usage
  • Viewing and setting web and email notifications

Programming and API

5 Articles
  • Email Hooks
  • Integrate.io ETL's API
  • PagerDuty Hooks
  • Service Hooks
  • Slack Hooks

Other

189 Articles
  • ABS
  • ACOS
  • API Endpoints with pagination support
  • ASIN
  • ATAN
  • AddDuration
  • BagToString
  • BagToTuple
  • Base64Decode
  • Base64DecodeToString
  • Base64Encode
  • Base64EncodeToString
  • BinaryCCurl
  • BinaryCurl
  • BrowserFamily
  • BrowserFullName
  • BrowserMajor
  • BrowserMinor
  • BrowserPatch
  • BrowserVersion
  • ByteArrayToString
  • CBRT
  • CCurl
  • CCurlPoll
  • CCurlWithPagination
  • CEIL
  • COALESCE
  • CONCAT
  • COS
  • COSH
  • CSVSPLIT
  • CityNameFromIP
  • ClockTime
  • ContinentCodeFromIP
  • ContinentNameFromIP
  • CountryCodeFromIP
  • CountryNameFromIP
  • Create a package from a template
  • Creating a new package
  • Curl
  • CurlPoll
  • CurlWithPagination
  • CurrentTime
  • DateDiffDays
  • DateDiffHours
  • DateDiffMinutes
  • DateDiffMonths
  • DateDiffSeconds
  • DateDiffYears
  • DaysBetween
  • Decrypt
  • DeviceFamily
  • DistInMilesHaversine
  • EXP
  • Encrypt
  • ExecuteBQInsert
  • ExecuteSqlBoolean
  • ExecuteSqlDateTime
  • ExecuteSqlDouble
  • ExecuteSqlFloat
  • ExecuteSqlInt
  • ExecuteSqlLong
  • ExecuteSqlNonQuery
  • ExecuteSqlString
  • ExtractQueryStringParam
  • ExtractSearchQuery
  • ExtractUABrowserID
  • ExtractUABrowserName
  • ExtractUrlPart
  • FLOOR
  • Flatten
  • GetBytes
  • GetDay
  • GetHour
  • GetMilliSecond
  • GetMinute
  • GetMonth
  • GetSecond
  • GetWeek
  • GetWeekYear
  • GetYear
  • HoursBetween
  • How to create a delivery
  • INDEXOF
  • ISOAddDuration
  • ISODatetimeToString
  • ISODatetimeToTimestampFormat
  • ISOSubtractDuration
  • ISOToDay
  • ISOToHour
  • ISOToMinute
  • ISOToMonth
  • ISOToSecond
  • ISOToWeek
  • ISOToYear
  • Integrate.io ETL Support Rates
  • Integrate.io ETL's IP list
  • IntervalIntersection
  • IsBase64
  • IsEmpty
  • IsISODatetime
  • JsonExtract
  • JsonExtractScalar
  • JsonStringToBag
  • JsonStringToMap
  • LAST_INDEX_OF
  • LCFIRST
  • LOG
  • LOG10
  • LOWER
  • LatitudeFromIP
  • Length
  • List of Salesforce objects
  • LongitudeFromIP
  • MD2
  • MD5
  • MapToBag
  • MapToQueryString
  • MilliSecondsBetween
  • MinutesBetween
  • MonthsBetween
  • OsFamily
  • OsFullName
  • OsMajor
  • OsMinor
  • OsPatch
  • OsPatchMinor
  • OsVersion
  • POW
  • ParseDate
  • ParseDoubleOrDefault
  • ParseFloatOrDefault
  • ParseIntOrDefault
  • ParseLongOrDefault
  • PlatformFamily
  • QueryStringToMap
  • RANDOM
  • REGEX_EXTRACT
  • REGEX_EXTRACT_ALL
  • REGEX_FIND_ALL
  • REPLACE
  • ROUND
  • ROUND_TO
  • RegionCodeFromIP
  • RegionNameFromIP
  • Reverse
  • SHA1
  • SHA256
  • SHA256WithRSA
  • SHA384
  • SHA512
  • SIN
  • SINH
  • SIZE
  • SPRINTF
  • SQRT
  • STRSPLIT
  • STRSPLITTOBAG
  • SUBSTRING
  • SecondsBetween
  • Sleep
  • StringToISODatetime
  • SubtractDuration
  • SwitchTimeZone
  • TAN
  • TANH
  • TOBAG
  • TOKENIZE
  • TOMAP
  • TOTUPLE
  • TRIM
  • TimestampFormatToISODatetime
  • ToDate
  • ToDateCustomFormats
  • ToHexString
  • ToJson
  • ToMilliSeconds
  • ToString
  • ToUnixTime
  • UCFIRST
  • UPPER
  • URLDecode
  • URLEncode
  • UUID
  • WeeksBetween
  • Working in the package designer
  • XPath
  • XPathToBag
  • YearsBetween

New Releases

18 Articles
  • 2-Factor Authentication
  • Allowing Integrate.io ETL access to DB2 databases
  • Allowing Integrate.io ETL access to Hubspot
  • Allowing Integrate.io ETL access to IBM i (AS400)
  • Allowing Integrate.io ETL access to my Google Analytics 4 (GA4)
  • Allowing Integrate.io ETL access to my data on Google Cloud Storage
  • Component Previewer
  • Dynamic connections
  • Encrypt and Decrypt Sensitive Data
  • Global Variables (Account Level)
  • Integrate.io ETL's Workspaces
  • Salesforce PK Chunking
  • Scheduling Package Execution
  • Single Sign-On
  • Using Components: Google Ads Destination
  • Using Components: Google Analytics 4 (GA4) Source
  • Using components: Facebook Ads Destination
  • Using components: HubSpot Destination
Getting started
Getting started
How Do I ...
How Do I ...
Connectivity And Security
Connectivity And Security
Creating packages
Creating packages
Using clusters
Using clusters
Running and monitoring jobs
Running and monitoring jobs
Configuring your Integrate.io ETL environment
Configuring your Integrate.io ETL environment
Programming and API
Programming and API
New Releases
New Releases
All articles
All articles

See Also

  • Set up a reverse SSH tunnel from Windows
  • Integrate.io ETL Functions
  • Using Expressions in Integrate.io ETL
  • How Do I Process JSON data
  • How Do I Move data incrementally between databases
  • System and pre-defined variables
  • How Do I Work with Datetime Data
  • Integrate.io ETL's API
  • Using components: Rest API Source
  • Using and setting variables in your packages
Integrate.io

hello@integrate.io
+1-888-884-6405

Solutions
  • Solutions Home
  • ETL & Reverse ETL
  • ELT & CDC
  • Connectors
  • Marketing
  • Sales
  • Support
  • Developers
  • Release Notes
Support
  • Blog
  • Live Chat
  • Support & Resources
  • Developers
  • Documentation
  • Documentation API
  • Security
  • Service Status
  • Privacy Policy
  • Glossary
  • Consent Preferences
Company
  • Customers
  • White Papers
  • Webinars
  • About
  • Partners
  • Join Us
Language
  • English
  • 日本語
  • 한국어
©2025 Integrate.io Terms of Service
newsletter newsletter

Subscribe to Our Newsletter

Sign up to our newsletter and receive exclusive discounts and promotions.

Choose Your Free Trial

Ensure Data Quality
ETL & Reverse ETL
Formerly Xplenty

Low-code ETL with 220+ data transformations to prepare your data for insights and reporting.

Ensure Data Quality
ELT & CDC
Formerly FlyData

Replicate data to your warehouses giving you real-time access to all of your critical data.

Ensure Data Quality
API Generation
Formerly DreamFactory

Generate a REST API on any data source in seconds to power data products.