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
How Do I ...

How Do I ...

  • 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
Back to ETL Knowledge Base

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.