icon-arrow-down-xplenty
Integrate.io
  • Integrate.io
  • Product
    • ETL & Reverse ETL
    • ELT & CDC
    • Performance Monitoring
    • API Management
  • Solutions  
    • Customer 360
    • Data Security
    • Data Ingestion
    • Reverse ETL
    • Business Intelligence
    • Data Science Team
    • Salesforce Team
    • Engineering Team
    • Data Team
    • SaaS
    • SaaS
    • Media & Entertainment
    • Travel
    • E-learning
    • Healthcare
  • Integrations
  • Resources
    • Customers
    • Webinars
    • Books & Guides
    • Documentation
    • Blog
  • Tel +1 (888) 884 6405
  • Sign In
  • Get Started
  • Sign In
  • Get Started

ETL Knowledge Base

ETL Knowledge base

Getting started

6 Articles
  • Advanced Package Search
  • Getting Started
  • Xplenty terminology
  • Xplenty's Workspaces
  • Xplenty's clusters
  • Xplenty'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

41 Articles
  • 2-Factor Authentication
  • Allow Xplenty access to my data on Azure Blob Storage
  • Allowing Xplenty access to Azure SQL Databases
  • Allowing Xplenty access to Facebook Ads Insights data
  • Allowing Xplenty access to Google Cloud SQL for MySQL databases
  • Allowing Xplenty access to Google Cloud SQL for PostgreSQL databases
  • Allowing Xplenty access to Heroku Postgres Databases
  • Allowing Xplenty access to Marketing Cloud (SOAP)
  • Allowing Xplenty access to Microsoft SQL Server Databases
  • Allowing Xplenty access to MongoDB
  • Allowing Xplenty access to MySQL Databases
  • Allowing Xplenty access to NetSuite
  • Allowing Xplenty access to Oracle databases
  • Allowing Xplenty access to PostgreSQL Databases
  • Allowing Xplenty access to data on Amazon S3
  • Allowing Xplenty access to my Amazon Athena instance
  • Allowing Xplenty access to my Google BigQuery dataset
  • Allowing Xplenty access to my Google Cloud Spanner instance
  • Allowing Xplenty access to my Marketing Cloud (REST)
  • Allowing Xplenty access to my Redshift cluster
  • Allowing Xplenty access to my Snowflake account
  • Allowing Xplenty access to my data on Bing Ads
  • Allowing Xplenty access to my data on File Transfer Protocol Secure (FTPS)
  • Allowing Xplenty access to my data on Google AdWords
  • Allowing Xplenty access to my data on Google Analytics
  • Allowing Xplenty access to my data on Google Cloud Storage
  • Allowing Xplenty access to my data on Google Drive
  • Allowing Xplenty access to my data on Google Sheets
  • Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  • Allowing Xplenty access to my data on Instagram
  • Allowing Xplenty access to my data on Intercom
  • Allowing Xplenty access to my data on Linkedin
  • Allowing Xplenty access to my data on Salesforce
  • Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  • Allowing Xplenty access to my data on Shopify
  • Allowing Xplenty access to my data on Xero
  • Allowing Xplenty access to my data on YouTube
  • Allowing Xplenty access to my server behind a firewall
  • Allowing Xplenty access to relational databases on Amazon RDS
  • Set up a reverse SSH tunnel from Windows
  • Single Sign-On

Creating packages

48 Articles
  • Creating a new package in New Xplenty
  • Creating a workflow
  • System and pre-defined variables
  • Using Components: Rest API Destination
  • Using Components: Window
  • Using Expressions in Xplenty
  • 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 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: Join Tranformation
  • Using components: Limit Transformation
  • Using components: MongoDB Destination
  • Using components: MongoDB Source
  • 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
  • Xplenty Functions

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 Xplenty environment

13 Articles
  • Changing your password
  • Defining connections
  • Managing your SSH public keys
  • Managing your Xplenty account members
  • 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 Xplenty
  • Viewing and modifying your billing information and account usage
  • Viewing and setting web and email notifications

Programming and API

5 Articles
  • Email Hooks
  • PagerDuty Hooks
  • Service Hooks
  • Slack Hooks
  • Xplenty's API

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
  • 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
  • Xplenty Support Rates
  • Xplenty's IP list
  • 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

9 Articles
  • 2-Factor Authentication
  • Component Previewer
  • Dynamic connections
  • Encrypt and Decrypt Sensitive Data
  • New Connector: DB2
  • Salesforce PK Chunking
  • Scheduling Package Execution
  • Single Sign-On
  • Xplenty's Workspaces
Press Enter to see full results
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 Xplenty environment
Configuring your Xplenty 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
  • Xplenty Functions
  • Using Expressions in Xplenty
  • 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
  • Xplenty's API
  • Using components: Rest API Source
  • Using and setting variables in your packages

hello@integrate.io

+1-888-884-6405

Solutions
  • Marketing
  • Sales
  • Support
  • Developers

  • Integrations
  • Integrate.io Platform
Industries
  • Retail
  • Hospitality
  • Advertising
Resources
  • Webinars
  • Books and Guides
  • Blog
  • Glossary
Compare
  • Alooma
  • Fivetran
  • Talend
  • ETLeap
  • Stitch
  • Matillion
Support
  • Live Chat
  • Documentation
  • Developers
  • Security
  • Service Status
  • Privacy Policy
  • Terms of Service
Company
  • About
  • Customers
  • Partners
Language
  • English
  • 日本語
  • 한국어
© 2022 Integrate. All Rights Reserved.

Get the Integrate.io newsletter.

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