All articles

  1. ABS

  2. ACOS

  3. AddDuration

  4. Allow Xplenty access to my data on Azure Blob Storage

  5. Allow Xplenty access to my data on Google Cloud Storage

  6. Allow Xplenty access to my Google Cloud Spanner instance

  7. Allow Xplenty access your data on Salesforce

  8. Allowing Xplenty access to Azure SQL Databases

  9. Allowing Xplenty access to data on Amazon S3

  10. Allowing Xplenty access to Facebook Ads Insights data (Beta)

  11. Allowing Xplenty access to MongoDB

  12. Allowing Xplenty access to my data on Bing Ads

  13. Allowing Xplenty access to my data on Google AdWords

  14. Allowing Xplenty access to my data on Google Analytics

  15. Allowing Xplenty access to my data on Google Sheets

  16. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)

  17. Allowing Xplenty access to my data on Instagram

  18. Allowing Xplenty access to my data on Intercom

  19. Allowing Xplenty access to my data on Linkedin

  20. Allowing Xplenty access to my data on Pinterest

  21. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)

  22. Allowing Xplenty access to my data on Shopify

  23. Allowing Xplenty access to my data on Xero (Beta)

  24. Allowing Xplenty access to my data on YouTube

  25. Allowing Xplenty access to my Google BigQuery dataset

  26. Allowing Xplenty access to my Redshift cluster

  27. Allowing Xplenty access to my server behind a firewall

  28. Allowing Xplenty access to my Snowflake account

  29. Allowing Xplenty access to NetSuite

  30. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS

  31. API Endpoints with pagination support

  32. ASIN

  33. ATAN

  34. BagToString

  35. BagToTuple

  36. Base64Decode

  37. Base64DecodeToString

  38. Base64Encode

  39. Base64EncodeToString

  40. BinaryCCurl

  41. BinaryCurl

  42. BrowserFamily

  43. BrowserFullName

  44. BrowserMajor

  45. BrowserMinor

  46. BrowserPatch

  47. BrowserVersion

  48. ByteArrayToString

  49. CBRT

  50. CCurl

  51. CCurlPoll

  52. CCurlWithPagination

  53. CEIL

  54. Changing your password

  55. CityNameFromIP

  56. ClockTime

  57. COALESCE

  58. CONCAT

  59. ContinentCodeFromIP

  60. ContinentNameFromIP

  61. COS

  62. COSH

  63. CountryCodeFromIP

  64. CountryNameFromIP

  65. Create a package from a template

  66. Creating a cluster

  67. Creating a new package

  68. Creating a new package in New Xplenty

  69. Creating a workflow

  70. CSVSPLIT

  71. Curl

  72. CurlPoll

  73. CurlWithPagination

  74. CurrentTime

  75. DateDiffDays

  76. DateDiffHours

  77. DateDiffMinutes

  78. DateDiffMonths

  79. DateDiffSeconds

  80. DateDiffYears

  81. DaysBetween

  82. Defining connections

  83. DeviceFamily

  84. DistInMilesHaversine

  85. Editing and scaling clusters

  86. Email Hooks

  87. ExecuteBQInsert

  88. ExecuteSqlBoolean

  89. ExecuteSqlDateTime

  90. ExecuteSqlDouble

  91. ExecuteSqlFloat

  92. ExecuteSqlInt

  93. ExecuteSqlLong

  94. ExecuteSqlNonQuery

  95. ExecuteSqlString

  96. EXP

  97. ExtractQueryStringParam

  98. ExtractSearchQuery

  99. ExtractUABrowserID

  100. ExtractUABrowserName

  101. ExtractUrlPart

  102. Flatten

  103. FLOOR

  104. GetBytes

  105. GetDay

  106. GetHour

  107. GetMilliSecond

  108. GetMinute

  109. GetMonth

  110. GetSecond

  111. GetWeek

  112. GetWeekYear

  113. GetYear

  114. HipChat Hooks

  115. HoursBetween

  116. How Do I Move data incrementally between databases

  117. How Do I Process JSON data

  118. How Do I Read data from S3 incrementally

  119. How do I select my file input format

  120. How Do I Work with Datetime Data

  121. How to create a delivery

  122. Importing Heroku Connections

  123. INDEXOF

  124. IntervalIntersection

  125. IsBase64

  126. IsEmpty

  127. IsISODatetime

  128. ISOAddDuration

  129. ISODatetimeToString

  130. ISODatetimeToTimestampFormat

  131. ISOSubtractDuration

  132. ISOToDay

  133. ISOToHour

  134. ISOToMinute

  135. ISOToMonth

  136. ISOToSecond

  137. ISOToWeek

  138. ISOToYear

  139. JsonExtract

  140. JsonExtractScalar

  141. JsonStringToBag

  142. JsonStringToMap

  143. LAST_INDEX_OF

  144. LatitudeFromIP

  145. LCFIRST

  146. Length

  147. List of Salesforce objects

  148. LOG

  149. LOG10

  150. LongitudeFromIP

  151. LOWER

  152. Managing your account settings

  153. Managing your SSH keys

  154. Managing your Xplenty account members

  155. MapToBag

  156. MapToQueryString

  157. MD2

  158. MD5

  159. MilliSecondsBetween

  160. MinutesBetween

  161. Modifying your personal settings

  162. Monitoring clusters

  163. Monitoring jobs

  164. MonthsBetween

  165. OsFamily

  166. OsFullName

  167. OsMajor

  168. OsMinor

  169. OsPatch

  170. OsPatchMinor

  171. OsVersion

  172. PagerDuty Hooks

  173. ParseDate

  174. ParseDoubleOrDefault

  175. ParseFloatOrDefault

  176. ParseIntOrDefault

  177. ParseLongOrDefault

  178. PlatformFamily

  179. POW

  180. QueryStringToMap

  181. RANDOM

  182. REGEX_EXTRACT

  183. REGEX_EXTRACT_ALL

  184. REGEX_FIND_ALL

  185. RegionCodeFromIP

  186. RegionNameFromIP

  187. REPLACE

  188. Reverse

  189. ROUND

  190. ROUND_TO

  191. Running jobs

  192. Scheduling Package Execution

  193. SecondsBetween

  194. Selecting a plan

  195. Selecting the account to work in

  196. Service Hooks

  197. Set up a reverse SSH tunnel from Windows

  198. Setting account member roles

  199. SHA1

  200. SHA256

  201. SHA256WithRSA

  202. SHA384

  203. SHA512

  204. Signing out from Xplenty

  205. SIN

  206. SINH

  207. SIZE

  208. Slack Hooks

  209. Sleep

  210. SPRINTF

  211. SQRT

  212. StringToISODatetime

  213. STRSPLIT

  214. STRSPLITTOBAG

  215. SUBSTRING

  216. SubtractDuration

  217. SwitchTimeZone

  218. System and pre-defined variables

  219. TAN

  220. TANH

  221. Terminating a cluster

  222. TimestampFormatToISODatetime

  223. To view job progress details

  224. TOBAG

  225. ToDate

  226. ToDateCustomFormats

  227. ToHexString

  228. ToJson

  229. TOKENIZE

  230. TOMAP

  231. ToMilliSeconds

  232. ToString

  233. TOTUPLE

  234. ToUnixTime

  235. TRIM

  236. UCFIRST

  237. UPPER

  238. URLDecode

  239. URLEncode

  240. Using and setting variables in your packages

  241. Using components: Aggregate

  242. Using components: Aggregate Transformation

  243. Using components: Amazon Redshift Destination

  244. Using components: Amazon Redshift Destination

  245. Using components: Amazon Redshift Source

  246. Using components: Amazon Redshift Source

  247. Using components: Assert

  248. Using components: Assert Transformation

  249. Using components: Bing Ads Source

  250. Using Components: Bing Ads Source

  251. Using components: Clone

  252. Using components: Clone transformation

  253. Using components: Cross Join

  254. Using components: Cross Join Transformation

  255. Using components: Cube and Rollup

  256. Using components: Database Destination

  257. Using components: Database Destination

  258. Using components: Database Source

  259. Using components: Database Source

  260. Using components: Distinct

  261. Using components: Distinct Transformation

  262. Using components: Facebook Ads Insights Source

  263. Using Components: Facebook Ads Insights Source (Beta)

  264. Using components: File Storage Destination

  265. Using components: File Storage Destination

  266. Using components: File Storage Source

  267. Using components: File Storage Source

  268. Using components: Filter

  269. Using components: Filter Transformation

  270. Using components: Google AdWords Source

  271. Using components: Google Adwords source

  272. Using Components: Google Analytics Source

  273. Using components: Google Analytics Source

  274. Using components: Google BigQuery Destination

  275. Using components: Google BigQuery Destination

  276. Using Components: Google BigQuery Source

  277. Using components: Google BigQuery Source

  278. Using components: Google Cloud Spanner Destination

  279. Using components: Google Cloud Spanner Source

  280. Using components: Google Cloud Spanner Source

  281. Using components: Google Spanner Destination

  282. Using components: Join

  283. Using components: Join Transformation

  284. Using components: Limit

  285. Using components: Limit Transformation

  286. Using components: MongoDB Destination

  287. Using components: MongoDB Destination

  288. Using components: MongoDB Source

  289. Using components: MongoDB Source

  290. Using components: NetSuite Source

  291. Using components: NetSuite Source

  292. Using components: Rank

  293. Using components: Rank Transformation

  294. Using Components: Rest API Source

  295. Using components: Rest API Source

  296. Using Components: Salesforce Destination

  297. Using components: Salesforce Destination

  298. Using Components: Salesforce Source

  299. Using components: Salesforce source

  300. Using components: Sample

  301. Using components: Select

  302. Using components: Select Transformation

  303. Using components: Snowflake Destination (beta)

  304. Using components: Snowflake Destination (beta)

  305. Using components: Sort

  306. Using components: Sort Transformation

  307. Using components: Union

  308. Using components: Union Transformation

  309. Using Components: Window

  310. Using Expressions in Xplenty

  311. Using ISO 8601 string functions

  312. Using pattern-matching in source component paths

  313. UUID

  314. Validating a package

  315. Validating a package

  316. Viewing all jobs in the account

  317. Viewing and modifying your billing information and account usage

  318. Viewing and setting web and email notifications

  319. Viewing completed tasks outputs

  320. Viewing job error details for failed jobs

  321. Viewing jobs in a specific cluster

  322. WeeksBetween

  323. Working in the new package designer

  324. Working in the package designer

  325. XPath

  326. XPathToBag

  327. Xplenty Functions

  328. Xplenty terminology

  329. Xplenty's API

  330. Xplenty's clusters

  331. Xplenty's IP list

  332. Xplenty's packages

  333. xplenty_rb.bags_difference

  334. xplenty_rb.bags_intersect

  335. xplenty_rb.bags_union

  336. xplenty_rb.concat_bag

  337. xplenty_rb.transform

  338. xplenty_rb.transform_bag

  339. YearsBetween

Feedback and Knowledge Base