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 Secure File Transfer Protocol (SFTP)

  16. Allowing Xplenty access to my Google BigQuery dataset

  17. Allowing Xplenty access to my Redshift cluster

  18. Allowing Xplenty access to my server

  19. Allowing Xplenty access to NetSuite

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

  21. ASIN

  22. ATAN

  23. BagToString

  24. BagToTuple

  25. Base64Decode

  26. Base64DecodeToString

  27. Base64Encode

  28. Base64EncodeToString

  29. BrowserFamily

  30. BrowserFullName

  31. BrowserMajor

  32. BrowserMinor

  33. BrowserPatch

  34. BrowserVersion

  35. CBRT

  36. CEIL

  37. Changing your password

  38. CityNameFromIP

  39. ClockTime

  40. COALESCE

  41. CONCAT

  42. COS

  43. COSH

  44. CountryCodeFromIP

  45. CountryNameFromIP

  46. Create a package from a template

  47. Creating a cluster

  48. Creating a new package

  49. Curl

  50. CurlWithPagination

  51. CurrentTime

  52. DateDiffDays

  53. DateDiffHours

  54. DateDiffMinutes

  55. DateDiffMonths

  56. DateDiffSeconds

  57. DateDiffYears

  58. DaysBetween

  59. Defining connections

  60. DeviceFamily

  61. DistInMilesHaversine

  62. Editing and scaling clusters

  63. Email Hooks

  64. ExecuteBQInsert

  65. ExecuteSqlBoolean

  66. ExecuteSqlDateTime

  67. ExecuteSqlDouble

  68. ExecuteSqlFloat

  69. ExecuteSqlInt

  70. ExecuteSqlLong

  71. ExecuteSqlNonQuery

  72. ExecuteSqlString

  73. EXP

  74. ExtractQueryStringParam

  75. ExtractSearchQuery

  76. ExtractUABrowserID

  77. ExtractUABrowserName

  78. ExtractUrlPart

  79. Flatten

  80. FLOOR

  81. GetBytes

  82. GetDay

  83. GetHour

  84. GetMilliSecond

  85. GetMinute

  86. GetMonth

  87. GetSecond

  88. GetWeek

  89. GetWeekYear

  90. GetYear

  91. HipChat Hooks

  92. HoursBetween

  93. How Do I Move data incrementally between databases

  94. How Do I Process JSON data

  95. How Do I Read data from S3 incrementally

  96. How Do I Work with Datetime Data

  97. How to create a delivery

  98. Importing Heroku Connections

  99. INDEXOF

  100. IntervalIntersection

  101. IsBase64

  102. IsEmpty

  103. IsISODatetime

  104. ISOAddDuration

  105. ISODatetimeToString

  106. ISODatetimeToTimestampFormat

  107. ISOSubtractDuration

  108. ISOToDay

  109. ISOToHour

  110. ISOToMinute

  111. ISOToMonth

  112. ISOToSecond

  113. ISOToWeek

  114. ISOToYear

  115. JsonExtract

  116. JsonExtractScalar

  117. JsonStringToBag

  118. JsonStringToMap

  119. LAST_INDEX_OF

  120. LatitudeFromIP

  121. LCFIRST

  122. Length

  123. List of Salesforce objects

  124. LOG

  125. LOG10

  126. LongitudeFromIP

  127. LOWER

  128. Managing your account settings

  129. Managing your SSH keys

  130. Managing your Xplenty account members

  131. MapToBag

  132. MapToQueryString

  133. MD2

  134. MD5

  135. MilliSecondsBetween

  136. MinutesBetween

  137. Modifying your personal settings

  138. Monitoring clusters

  139. Monitoring jobs

  140. MonthsBetween

  141. OsFamily

  142. OsFullName

  143. OsMajor

  144. OsMinor

  145. OsPatch

  146. OsPatchMinor

  147. OsVersion

  148. PagerDuty Hooks

  149. ParseDate

  150. ParseDoubleOrDefault

  151. ParseFloatOrDefault

  152. ParseIntOrDefault

  153. ParseLongOrDefault

  154. PlatformFamily

  155. POW

  156. QueryStringToMap

  157. RANDOM

  158. REGEX_EXTRACT

  159. REGEX_EXTRACT_ALL

  160. REGEX_FIND_ALL

  161. RegionCodeFromIP

  162. RegionNameFromIP

  163. REPLACE

  164. Reverse

  165. ROUND

  166. ROUND_TO

  167. Running jobs

  168. Scheduling Package Execution

  169. SecondsBetween

  170. Selecting a plan

  171. Selecting the account to work in

  172. Service Hooks

  173. Set up a reverse SSH tunnel from Windows

  174. Setting account member roles

  175. SHA1

  176. SHA256

  177. SHA256WithRSA

  178. SHA384

  179. SHA512

  180. Signing out from Xplenty

  181. SIN

  182. SINH

  183. SIZE

  184. Slack Hooks

  185. Sleep

  186. SPRINTF

  187. SQRT

  188. StringToISODatetime

  189. STRSPLIT

  190. STRSPLITTOBAG

  191. SUBSTRING

  192. SubtractDuration

  193. SwitchTimeZone

  194. TAN

  195. TANH

  196. Terminating a cluster

  197. TimestampFormatToISODatetime

  198. To view job progress details

  199. TOBAG

  200. ToDate

  201. ToDateCustomFormats

  202. ToHexString

  203. TOKENIZE

  204. TOMAP

  205. ToMilliSeconds

  206. ToString

  207. TOTUPLE

  208. ToUnixTime

  209. TRIM

  210. UCFIRST

  211. UPPER

  212. URLDecode

  213. URLEncode

  214. Using and setting variables in your packages

  215. Using components: Aggregate

  216. Using components: Amazon Redshift Destination

  217. Using components: Amazon Redshift Source

  218. Using components: Assert

  219. Using Components: Bing Ads Source

  220. Using components: Clone

  221. Using components: Cross Join

  222. Using components: Cube and Rollup

  223. Using components: Database Destination

  224. Using components: Database Source

  225. Using components: Distinct

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

  227. Using components: File Storage Destination

  228. Using components: File Storage Source

  229. Using components: Filter

  230. Using components: Google AdWords Source

  231. Using Components: Google Analytics Source

  232. Using components: Google BigQuery Destination

  233. Using Components: Google BigQuery Source

  234. Using components: Google Cloud Spanner Destination

  235. Using components: Google Cloud Spanner Source

  236. Using components: Join

  237. Using components: Limit

  238. Using components: MongoDB Destination

  239. Using components: MongoDB Source

  240. Using components: NetSuite Source

  241. Using components: Rank

  242. Using Components: Rest API Source

  243. Using Components: Salesforce Destination (Beta)

  244. Using Components: Salesforce Source

  245. Using components: Sample

  246. Using components: Select

  247. Using components: Sort

  248. Using components: Union

  249. Using Components: Window

  250. Using Expressions in Xplenty

  251. Using ISO 8601 string functions

  252. Using pattern-matching in source component paths

  253. UUID

  254. Validating a package

  255. Viewing all jobs in the account

  256. Viewing and modifying your billing information and account usage

  257. Viewing and setting web and email notifications

  258. Viewing completed tasks outputs

  259. Viewing job error details for failed jobs

  260. Viewing jobs in a specific cluster

  261. WeeksBetween

  262. Working in the package designer

  263. XPath

  264. XPathToBag

  265. Xplenty Functions

  266. Xplenty terminology

  267. Xplenty's API

  268. Xplenty's clusters

  269. Xplenty's IP list

  270. Xplenty's packages

  271. xplenty_rb.bags_difference

  272. xplenty_rb.bags_intersect

  273. xplenty_rb.bags_union

  274. xplenty_rb.concat_bag

  275. xplenty_rb.transform

  276. xplenty_rb.transform_bag

  277. YearsBetween

Feedback and Knowledge Base