Supported Functions

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:

1. Input (IN or IN/OUT) parameters must not be cursors.

2. Input (IN or IN/OUT) parameters must be placed before all OUT parameters.

3. The first OUT parameter will be used to read data and it must be a REF CURSOR.

4. 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).