Integrate.io
  • Integrate.io
  • Platform
    ETL
    ETL & Reverse ETL
    CDC
    ELT & CDC
    API
    API Generation
    API
    Data Observability
    API
    DWH Insights
  • Pricing
  • Connectors
  • More
    Blog
    Compare Us
    SUPPORT
    Support & Resources
    Security
    COMPANY
    Customers
    White Papers
    Webinars
    Documentation
    About
    Partners
    Join Us
  • Sign In
  • GET A DEMO
  • (888) 884 6405
  • Sign In
  • GET A DEMO
Press Enter to see full results

ETL & Reverse ETL
Knowledge Base

ETL & Reverse ETL Knowledge base

Getting started

6 Articles
  • Advanced Package Search
  • Getting Started
  • Integrate.io ETL terminology
  • Integrate.io ETL's Workspaces
  • Integrate.io ETL's clusters
  • Integrate.io ETL's packages

How Do I ...

9 Articles
  • 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 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

Connectivity And Security

46 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
  • 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 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 File Transfer Protocol Secure (FTPS)
  • Allowing Integrate.io ETL access to my data on Google AdWords
  • 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 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 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
  • Set up a reverse SSH tunnel from Windows
  • Single Sign-On

Creating packages

53 Articles
  • Creating a new package in New Integrate.io ETL
  • Creating a workflow
  • Integrate.io ETL Functions
  • System and pre-defined variables
  • Using Components: Google Ads Destination
  • Using Components: Google Analytics 4 (GA4) Source
  • Using Components: 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 Adwords 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

195 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
  • xplenty_rb.bags_difference
  • xplenty_rb.bags_intersect
  • xplenty_rb.bags_union
  • xplenty_rb.concat_bag
  • xplenty_rb.transform
  • xplenty_rb.transform_bag

New Releases

16 Articles
  • 2-Factor Authentication
  • Allowing Integrate.io ETL access to Hubspot
  • Allowing Integrate.io ETL access to my Google Analytics 4 (GA4)
  • Component Previewer
  • Dynamic connections
  • Encrypt and Decrypt Sensitive Data
  • Integrate.io ETL's Workspaces
  • New Connector: AS400
  • New Connector: DB2
  • 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

Ensure Data Quality Ensure Data Quality Ensure Data Quality Ensure Data Quality Ensure Data Quality

©2023 Integrate.io

SIGN UP FOR “THE STACK” - OUR MONTHLY NEWSLETTER
Solutions
  • Solutions Home
  • Connectors
  • Marketing
  • Sales
  • Support
  • Developers
Support
  • Blog
  • Live Chat
  • Support & Resources
  • Developers
  • Documentation
  • Documentation API
  • Security
  • Service Status
  • Privacy Policy
  • Terms of Service
  • Glossary
Company
  • Customers
  • White Papers
  • Webinars
  • About
  • Partners
  • Join Us
Language
  • English
  • 日本語
  • 한국어

©2023 Integrate.io

Get the Integrate.io Newsletter

Don’t worry, we hate spam as much as you do.
I'm already subscribed. No thanks.

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.