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 Hadoop Distributed File System (HDFS)

  16. Allowing Xplenty access to my data on Intercom

  17. Allowing Xplenty access to my data on Linkedin

  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 server

  22. Allowing Xplenty access to my Snowflake account

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

  34. BinaryCurl

  35. BrowserFamily

  36. BrowserFullName

  37. BrowserMajor

  38. BrowserMinor

  39. BrowserPatch

  40. BrowserVersion

  41. ByteArrayToString

  42. CBRT

  43. CCurl

  44. CCurlWithPagination

  45. CEIL

  46. Changing your password

  47. CityNameFromIP

  48. ClockTime

  49. COALESCE

  50. CONCAT

  51. COS

  52. COSH

  53. CountryCodeFromIP

  54. CountryNameFromIP

  55. Create a package from a template

  56. Creating a cluster

  57. Creating a new package

  58. CSVSPLIT

  59. Curl

  60. CurlWithPagination

  61. CurrentTime

  62. DateDiffDays

  63. DateDiffHours

  64. DateDiffMinutes

  65. DateDiffMonths

  66. DateDiffSeconds

  67. DateDiffYears

  68. DaysBetween

  69. Defining connections

  70. DeviceFamily

  71. DistInMilesHaversine

  72. Editing and scaling clusters

  73. Email Hooks

  74. ExecuteBQInsert

  75. ExecuteSqlBoolean

  76. ExecuteSqlDateTime

  77. ExecuteSqlDouble

  78. ExecuteSqlFloat

  79. ExecuteSqlInt

  80. ExecuteSqlLong

  81. ExecuteSqlNonQuery

  82. ExecuteSqlString

  83. EXP

  84. ExtractQueryStringParam

  85. ExtractSearchQuery

  86. ExtractUABrowserID

  87. ExtractUABrowserName

  88. ExtractUrlPart

  89. Flatten

  90. FLOOR

  91. GetBytes

  92. GetDay

  93. GetHour

  94. GetMilliSecond

  95. GetMinute

  96. GetMonth

  97. GetSecond

  98. GetWeek

  99. GetWeekYear

  100. GetYear

  101. HipChat Hooks

  102. HoursBetween

  103. How Do I Move data incrementally between databases

  104. How Do I Process JSON data

  105. How Do I Read data from S3 incrementally

  106. How Do I Work with Datetime Data

  107. How to create a delivery

  108. Importing Heroku Connections

  109. INDEXOF

  110. IntervalIntersection

  111. IsBase64

  112. IsEmpty

  113. IsISODatetime

  114. ISOAddDuration

  115. ISODatetimeToString

  116. ISODatetimeToTimestampFormat

  117. ISOSubtractDuration

  118. ISOToDay

  119. ISOToHour

  120. ISOToMinute

  121. ISOToMonth

  122. ISOToSecond

  123. ISOToWeek

  124. ISOToYear

  125. JsonExtract

  126. JsonExtractScalar

  127. JsonStringToBag

  128. JsonStringToMap

  129. LAST_INDEX_OF

  130. LatitudeFromIP

  131. LCFIRST

  132. Length

  133. List of Salesforce objects

  134. LOG

  135. LOG10

  136. LongitudeFromIP

  137. LOWER

  138. Managing your account settings

  139. Managing your SSH keys

  140. Managing your Xplenty account members

  141. MapToBag

  142. MapToQueryString

  143. MD2

  144. MD5

  145. MilliSecondsBetween

  146. MinutesBetween

  147. Modifying your personal settings

  148. Monitoring clusters

  149. Monitoring jobs

  150. MonthsBetween

  151. OsFamily

  152. OsFullName

  153. OsMajor

  154. OsMinor

  155. OsPatch

  156. OsPatchMinor

  157. OsVersion

  158. PagerDuty Hooks

  159. ParseDate

  160. ParseDoubleOrDefault

  161. ParseFloatOrDefault

  162. ParseIntOrDefault

  163. ParseLongOrDefault

  164. PlatformFamily

  165. POW

  166. QueryStringToMap

  167. RANDOM

  168. REGEX_EXTRACT

  169. REGEX_EXTRACT_ALL

  170. REGEX_FIND_ALL

  171. RegionCodeFromIP

  172. RegionNameFromIP

  173. REPLACE

  174. Reverse

  175. ROUND

  176. ROUND_TO

  177. Running jobs

  178. Scheduling Package Execution

  179. SecondsBetween

  180. Selecting a plan

  181. Selecting the account to work in

  182. Service Hooks

  183. Set up a reverse SSH tunnel from Windows

  184. Setting account member roles

  185. SHA1

  186. SHA256

  187. SHA256WithRSA

  188. SHA384

  189. SHA512

  190. Signing out from Xplenty

  191. SIN

  192. SINH

  193. SIZE

  194. Slack Hooks

  195. Sleep

  196. SPRINTF

  197. SQRT

  198. StringToISODatetime

  199. STRSPLIT

  200. STRSPLITTOBAG

  201. SUBSTRING

  202. SubtractDuration

  203. SwitchTimeZone

  204. TAN

  205. TANH

  206. Terminating a cluster

  207. TimestampFormatToISODatetime

  208. To view job progress details

  209. TOBAG

  210. ToDate

  211. ToDateCustomFormats

  212. ToHexString

  213. TOKENIZE

  214. TOMAP

  215. ToMilliSeconds

  216. ToString

  217. TOTUPLE

  218. ToUnixTime

  219. TRIM

  220. UCFIRST

  221. UPPER

  222. URLDecode

  223. URLEncode

  224. Using and setting variables in your packages

  225. Using components: Aggregate

  226. Using components: Amazon Redshift Destination

  227. Using components: Amazon Redshift Source

  228. Using components: Assert

  229. Using Components: Bing Ads Source

  230. Using components: Clone

  231. Using components: Cross Join

  232. Using components: Cube and Rollup

  233. Using components: Database Destination

  234. Using components: Database Source

  235. Using components: Distinct

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

  237. Using components: File Storage Destination

  238. Using components: File Storage Source

  239. Using components: Filter

  240. Using components: Google AdWords Source

  241. Using Components: Google Analytics Source

  242. Using components: Google BigQuery Destination

  243. Using Components: Google BigQuery Source

  244. Using components: Google Cloud Spanner Destination

  245. Using components: Google Cloud Spanner Source

  246. Using components: Join

  247. Using components: Limit

  248. Using components: MongoDB Destination

  249. Using components: MongoDB Source

  250. Using components: NetSuite Source

  251. Using components: Rank

  252. Using Components: Rest API Source

  253. Using Components: Salesforce Destination

  254. Using Components: Salesforce Source

  255. Using components: Sample

  256. Using components: Select

  257. Using components: Snowflake Destination (beta)

  258. Using components: Sort

  259. Using components: Union

  260. Using Components: Window

  261. Using Expressions in Xplenty

  262. Using ISO 8601 string functions

  263. Using pattern-matching in source component paths

  264. UUID

  265. Validating a package

  266. Viewing all jobs in the account

  267. Viewing and modifying your billing information and account usage

  268. Viewing and setting web and email notifications

  269. Viewing completed tasks outputs

  270. Viewing job error details for failed jobs

  271. Viewing jobs in a specific cluster

  272. WeeksBetween

  273. Working in the package designer

  274. XPath

  275. XPathToBag

  276. Xplenty Functions

  277. Xplenty terminology

  278. Xplenty's API

  279. Xplenty's clusters

  280. Xplenty's IP list

  281. Xplenty's packages

  282. xplenty_rb.bags_difference

  283. xplenty_rb.bags_intersect

  284. xplenty_rb.bags_union

  285. xplenty_rb.concat_bag

  286. xplenty_rb.transform

  287. xplenty_rb.transform_bag

  288. YearsBetween

Feedback and Knowledge Base