All articles

  1. ABS

  2. ACOS

  3. AddDuration

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

  5. Allow Xplenty access to my Google Cloud Spanner instance

  6. Allow Xplenty access your data on Salesforce

  7. Allowing Xplenty access to Azure SQL Databases

  8. Allowing Xplenty access to data on Amazon S3

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

  10. Allowing Xplenty access to MongoDB

  11. Allowing Xplenty access to my data on Bing Ads

  12. Allowing Xplenty access to my data on Google AdWords

  13. Allowing Xplenty access to my data on Google Analytics

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

  15. Allowing Xplenty access to my data on Intercom

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

  17. Allowing Xplenty access to my Google BigQuery dataset

  18. Allowing Xplenty access to my Redshift cluster

  19. Allowing Xplenty access to my server

  20. Allowing Xplenty access to NetSuite

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

  22. ASIN

  23. ATAN

  24. BagToString

  25. BagToTuple

  26. Base64Decode

  27. Base64DecodeToString

  28. Base64Encode

  29. Base64EncodeToString

  30. BrowserFamily

  31. BrowserFullName

  32. BrowserMajor

  33. BrowserMinor

  34. BrowserPatch

  35. BrowserVersion

  36. CBRT

  37. CCurl

  38. CCurlWithPagination

  39. CEIL

  40. Changing your password

  41. CityNameFromIP

  42. ClockTime

  43. COALESCE

  44. CONCAT

  45. COS

  46. COSH

  47. CountryCodeFromIP

  48. CountryNameFromIP

  49. Create a package from a template

  50. Creating a cluster

  51. Creating a new package

  52. Curl

  53. CurlWithPagination

  54. CurrentTime

  55. DateDiffDays

  56. DateDiffHours

  57. DateDiffMinutes

  58. DateDiffMonths

  59. DateDiffSeconds

  60. DateDiffYears

  61. DaysBetween

  62. Defining connections

  63. DeviceFamily

  64. DistInMilesHaversine

  65. Editing and scaling clusters

  66. Email Hooks

  67. ExecuteBQInsert

  68. ExecuteSqlBoolean

  69. ExecuteSqlDateTime

  70. ExecuteSqlDouble

  71. ExecuteSqlFloat

  72. ExecuteSqlInt

  73. ExecuteSqlLong

  74. ExecuteSqlNonQuery

  75. ExecuteSqlString

  76. EXP

  77. ExtractQueryStringParam

  78. ExtractSearchQuery

  79. ExtractUABrowserID

  80. ExtractUABrowserName

  81. ExtractUrlPart

  82. Flatten

  83. FLOOR

  84. GetBytes

  85. GetDay

  86. GetHour

  87. GetMilliSecond

  88. GetMinute

  89. GetMonth

  90. GetSecond

  91. GetWeek

  92. GetWeekYear

  93. GetYear

  94. HipChat Hooks

  95. HoursBetween

  96. How Do I Move data incrementally between databases

  97. How Do I Process JSON data

  98. How Do I Read data from S3 incrementally

  99. How Do I Work with Datetime Data

  100. How to create a delivery

  101. Importing Heroku Connections

  102. INDEXOF

  103. IntervalIntersection

  104. IsBase64

  105. IsEmpty

  106. IsISODatetime

  107. ISOAddDuration

  108. ISODatetimeToString

  109. ISODatetimeToTimestampFormat

  110. ISOSubtractDuration

  111. ISOToDay

  112. ISOToHour

  113. ISOToMinute

  114. ISOToMonth

  115. ISOToSecond

  116. ISOToWeek

  117. ISOToYear

  118. JsonExtract

  119. JsonExtractScalar

  120. JsonStringToBag

  121. JsonStringToMap

  122. LAST_INDEX_OF

  123. LatitudeFromIP

  124. LCFIRST

  125. Length

  126. List of Salesforce objects

  127. LOG

  128. LOG10

  129. LongitudeFromIP

  130. LOWER

  131. Managing your account settings

  132. Managing your SSH keys

  133. Managing your Xplenty account members

  134. MapToBag

  135. MapToQueryString

  136. MD2

  137. MD5

  138. MilliSecondsBetween

  139. MinutesBetween

  140. Modifying your personal settings

  141. Monitoring clusters

  142. Monitoring jobs

  143. MonthsBetween

  144. OsFamily

  145. OsFullName

  146. OsMajor

  147. OsMinor

  148. OsPatch

  149. OsPatchMinor

  150. OsVersion

  151. PagerDuty Hooks

  152. ParseDate

  153. ParseDoubleOrDefault

  154. ParseFloatOrDefault

  155. ParseIntOrDefault

  156. ParseLongOrDefault

  157. PlatformFamily

  158. POW

  159. QueryStringToMap

  160. RANDOM

  161. REGEX_EXTRACT

  162. REGEX_EXTRACT_ALL

  163. REGEX_FIND_ALL

  164. RegionCodeFromIP

  165. RegionNameFromIP

  166. REPLACE

  167. Reverse

  168. ROUND

  169. ROUND_TO

  170. Running jobs

  171. Scheduling Package Execution

  172. SecondsBetween

  173. Selecting a plan

  174. Selecting the account to work in

  175. Service Hooks

  176. Set up a reverse SSH tunnel from Windows

  177. Setting account member roles

  178. SHA1

  179. SHA256

  180. SHA256WithRSA

  181. SHA384

  182. SHA512

  183. Signing out from Xplenty

  184. SIN

  185. SINH

  186. SIZE

  187. Slack Hooks

  188. Sleep

  189. SPRINTF

  190. SQRT

  191. StringToISODatetime

  192. STRSPLIT

  193. STRSPLITTOBAG

  194. SUBSTRING

  195. SubtractDuration

  196. SwitchTimeZone

  197. TAN

  198. TANH

  199. Terminating a cluster

  200. TimestampFormatToISODatetime

  201. To view job progress details

  202. TOBAG

  203. ToDate

  204. ToDateCustomFormats

  205. ToHexString

  206. TOKENIZE

  207. TOMAP

  208. ToMilliSeconds

  209. ToString

  210. TOTUPLE

  211. ToUnixTime

  212. TRIM

  213. UCFIRST

  214. UPPER

  215. URLDecode

  216. URLEncode

  217. Using and setting variables in your packages

  218. Using components: Aggregate

  219. Using components: Amazon Redshift Destination

  220. Using components: Amazon Redshift Source

  221. Using components: Assert

  222. Using Components: Bing Ads Source

  223. Using components: Clone

  224. Using components: Cross Join

  225. Using components: Cube and Rollup

  226. Using components: Database Destination

  227. Using components: Database Source

  228. Using components: Distinct

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

  230. Using components: File Storage Destination

  231. Using components: File Storage Source

  232. Using components: Filter

  233. Using components: Google AdWords Source

  234. Using Components: Google Analytics Source

  235. Using components: Google BigQuery Destination

  236. Using Components: Google BigQuery Source

  237. Using components: Google Cloud Spanner Destination

  238. Using components: Google Cloud Spanner Source

  239. Using components: Join

  240. Using components: Limit

  241. Using components: MongoDB Destination

  242. Using components: MongoDB Source

  243. Using components: NetSuite Source

  244. Using components: Rank

  245. Using Components: Rest API Source

  246. Using Components: Salesforce Destination

  247. Using Components: Salesforce Source

  248. Using components: Sample

  249. Using components: Select

  250. Using components: Sort

  251. Using components: Union

  252. Using Components: Window

  253. Using Expressions in Xplenty

  254. Using ISO 8601 string functions

  255. Using pattern-matching in source component paths

  256. UUID

  257. Validating a package

  258. Viewing all jobs in the account

  259. Viewing and modifying your billing information and account usage

  260. Viewing and setting web and email notifications

  261. Viewing completed tasks outputs

  262. Viewing job error details for failed jobs

  263. Viewing jobs in a specific cluster

  264. WeeksBetween

  265. Working in the package designer

  266. XPath

  267. XPathToBag

  268. Xplenty Functions

  269. Xplenty terminology

  270. Xplenty's API

  271. Xplenty's clusters

  272. Xplenty's IP list

  273. Xplenty's packages

  274. xplenty_rb.bags_difference

  275. xplenty_rb.bags_intersect

  276. xplenty_rb.bags_union

  277. xplenty_rb.concat_bag

  278. xplenty_rb.transform

  279. xplenty_rb.transform_bag

  280. YearsBetween

Feedback and Knowledge Base