ETL Knowledge base
Getting started
6 Articles
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
Running and monitoring jobs
8 Articles
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
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
Press Enter to see full results
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