Date and Time functions
Year, Quarter, Month, Week, WeekOfMonth, Day, DayOfMonth, DayOfWeek, DayOfYear, Hour, Minute, Second
Conversion functions
SN
Math functions
Abs, ACos, ASin, ATan, ATan2, Ceil, Cos, Cosh, Exp, Floor, Ln, Log, Power, Sin, Sinh, Sqrt, Tan, Tanh
Operators
+, -, *, /, %, Mod
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, Median, Variance, Var_Pop, Var_Samp, StdDev, StdDev_Pop, StdDev_Samp, Corr, CoVar_Pop, CoVar_Samp, Regr_AvgX, Regr_AvgY, Regr_Count, Regr_Intercept, Regr_R2, Regr_Slope, Regr_SXX, Regr_SXY, Regr_SYY
Text functions
Instr, Length, Lower, LTrim, RTrim, Soundex, Trim, Upper
Other supported functionality
Binning
Stored procedures
Note: Generally, stored procedures that do not result in a data table output will not be visible in the Views in Connection dialog for some connectors.
Additionally, for Oracle, the following requirements must be met:
Input (IN or IN/OUT) parameters must not be cursors.
Input (IN or IN/OUT) parameters must be placed before all OUT parameters.
The first OUT parameter will be used to read data and it must be a REF CURSOR.
All subsequent OUT parameters will be ignored.
The schema of the stored procedure must not change from time to time (for example, the use of parameters must not change the schema).