icon-arrow-down-xplenty
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
How Do I ...
Connectivity And Security
Creating packages
Using clusters
Running and monitoring jobs
Configuring your Xplenty environment
Programming and API
New Releases
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
Get the Integrate.io newsletter.
Subscribe
Don’t worry, we hate spam as much as you do.
I'm already subscribed.
No thanks.