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 data on OpenStack Swift

  10. Allowing Xplenty access to data on Rackspace Cloud Files

  11. Allowing Xplenty access to data on SoftLayer Object Storage

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

  13. Allowing Xplenty access to MongoDB

  14. Allowing Xplenty access to my data on Bing Ads

  15. Allowing Xplenty access to my data on Google AdWords

  16. Allowing Xplenty access to my data on Google Analytics

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

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

  19. Allowing Xplenty access to my Google BigQuery dataset

  20. Allowing Xplenty access to my Redshift cluster

  21. Allowing Xplenty access to my Segment Redshift cluster

  22. Allowing Xplenty access to my server

  23. Allowing Xplenty access to NetSuite

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

  25. ASIN

  26. ATAN

  27. BagToString

  28. BagToTuple

  29. Base64Decode

  30. Base64DecodeToString

  31. Base64Encode

  32. Base64EncodeToString

  33. BrowserFamily

  34. BrowserFullName

  35. BrowserMajor

  36. BrowserMinor

  37. BrowserPatch

  38. BrowserVersion

  39. CBRT

  40. CEIL

  41. Changing your password

  42. CityNameFromIP

  43. ClockTime

  44. COALESCE

  45. CONCAT

  46. COS

  47. COSH

  48. CountryCodeFromIP

  49. CountryNameFromIP

  50. Create a package from a template

  51. Creating a cluster

  52. Creating a new package

  53. Curl

  54. CurlWithPagination

  55. CurrentTime

  56. DateDiffDays

  57. DateDiffHours

  58. DateDiffMinutes

  59. DateDiffMonths

  60. DateDiffSeconds

  61. DateDiffYears

  62. DaysBetween

  63. Defining connections

  64. DeviceFamily

  65. DistInMilesHaversine

  66. Editing and scaling clusters

  67. Email Hooks

  68. ExecuteBQInsert

  69. ExecuteSqlBoolean

  70. ExecuteSqlDateTime

  71. ExecuteSqlDouble

  72. ExecuteSqlFloat

  73. ExecuteSqlInt

  74. ExecuteSqlLong

  75. ExecuteSqlNonQuery

  76. ExecuteSqlString

  77. EXP

  78. ExtractQueryStringParam

  79. ExtractSearchQuery

  80. ExtractUABrowserID

  81. ExtractUABrowserName

  82. ExtractUrlPart

  83. Flatten

  84. FLOOR

  85. GetBytes

  86. GetDay

  87. GetHour

  88. GetMilliSecond

  89. GetMinute

  90. GetMonth

  91. GetSecond

  92. GetWeek

  93. GetWeekYear

  94. GetYear

  95. HipChat Hooks

  96. HoursBetween

  97. How Do I Move data incrementally between databases

  98. How Do I Process JSON data

  99. How Do I Read data from S3 incrementally

  100. How Do I Work with Datetime Data

  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. LOG

  127. LOG10

  128. LongitudeFromIP

  129. LOWER

  130. Managing your account settings

  131. Managing your SSH keys

  132. Managing your Xplenty account members

  133. MapToBag

  134. MapToQueryString

  135. MD2

  136. MD5

  137. MilliSecondsBetween

  138. MinutesBetween

  139. Modifying your personal settings

  140. Monitoring clusters

  141. Monitoring jobs

  142. MonthsBetween

  143. OsFamily

  144. OsFullName

  145. OsMajor

  146. OsMinor

  147. OsPatch

  148. OsPatchMinor

  149. OsVersion

  150. PagerDuty Hooks

  151. ParseDate

  152. ParseDoubleOrDefault

  153. ParseFloatOrDefault

  154. ParseIntOrDefault

  155. ParseLongOrDefault

  156. PlatformFamily

  157. POW

  158. QueryStringToMap

  159. RANDOM

  160. REGEX_EXTRACT

  161. REGEX_EXTRACT_ALL

  162. REGEX_FIND_ALL

  163. RegionCodeFromIP

  164. RegionNameFromIP

  165. REPLACE

  166. Reverse

  167. ROUND

  168. ROUND_TO

  169. Running jobs

  170. Scheduling Package Execution

  171. SecondsBetween

  172. Selecting a plan

  173. Selecting the account to work in

  174. Service Hooks

  175. Set up a reverse SSH tunnel from Windows

  176. Setting account member roles

  177. SHA1

  178. SHA256

  179. SHA256WithRSA

  180. SHA384

  181. SHA512

  182. Signing out from Xplenty

  183. SIN

  184. SINH

  185. SIZE

  186. Slack Hooks

  187. Sleep

  188. SPRINTF

  189. SQRT

  190. StringToISODatetime

  191. STRSPLIT

  192. STRSPLITTOBAG

  193. SUBSTRING

  194. SubtractDuration

  195. SwitchTimeZone

  196. TAN

  197. TANH

  198. Terminating a cluster

  199. TimestampFormatToISODatetime

  200. To view job progress details

  201. TOBAG

  202. ToDate

  203. ToDateCustomFormats

  204. ToHexString

  205. TOKENIZE

  206. TOMAP

  207. ToMilliSeconds

  208. ToString

  209. TOTUPLE

  210. ToUnixTime

  211. TRIM

  212. UCFIRST

  213. UPPER

  214. URLDecode

  215. URLEncode

  216. Using and setting variables in your packages

  217. Using components: Aggregate

  218. Using components: Amazon Redshift Destination

  219. Using components: Amazon Redshift Source

  220. Using components: Assert

  221. Using Components: Bing Ads Source

  222. Using components: Clone

  223. Using components: Cross Join

  224. Using components: Cube and Rollup

  225. Using components: Database Destination

  226. Using components: Database Source

  227. Using components: Distinct

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

  229. Using components: File Storage Destination

  230. Using components: File Storage Source

  231. Using components: Filter

  232. Using components: Google AdWords Source

  233. Using Components: Google Analytics Source

  234. Using components: Google BigQuery Destination

  235. Using Components: Google BigQuery Source

  236. Using components: Google Cloud Spanner Destination

  237. Using components: Google Cloud Spanner Source

  238. Using components: Join

  239. Using components: Limit

  240. Using components: MongoDB Destination

  241. Using components: MongoDB Source

  242. Using components: NetSuite Source

  243. Using components: Rank

  244. Using Components: Rest API Source

  245. Using Components: Salesforce Destination (Beta)

  246. Using Components: Salesforce Source

  247. Using components: Sample

  248. Using components: Select

  249. Using components: Sort

  250. Using components: Union

  251. Using Components: Window

  252. Using Expressions in Xplenty

  253. Using ISO 8601 string functions

  254. Using pattern-matching in source component paths

  255. UUID

  256. Validating a package

  257. Viewing all jobs in the account

  258. Viewing and modifying your billing information and account usage

  259. Viewing and setting web and email notifications

  260. Viewing completed tasks outputs

  261. Viewing job error details for failed jobs

  262. Viewing jobs in a specific cluster

  263. WeeksBetween

  264. Working in the package designer

  265. XPath

  266. XPathToBag

  267. Xplenty Functions

  268. Xplenty terminology

  269. Xplenty's API

  270. Xplenty's clusters

  271. Xplenty's IP list

  272. Xplenty's packages

  273. xplenty_rb.bags_difference

  274. xplenty_rb.bags_intersect

  275. xplenty_rb.bags_union

  276. xplenty_rb.concat_bag

  277. xplenty_rb.transform

  278. xplenty_rb.transform_bag

  279. YearsBetween

Feedback and Knowledge Base