Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3073

Tableau Connection Issues

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.10
    • None
    • ODBC, Server
    • None

    Description

      It has been reported that using Tableu with Teiid ODBC port show the following errors. These need to be investigated and fixed

      This ODBC driver does not support important capabilities used by Tableau.
      This unsupported function is required for relative date filters: The date part named 'week' for the date function: DATETRUNC(date_part, date, [start_of_week])
      -----
      Tableau identified the following warnings for the ODBC data source named 'streamyx_sales (streamyx_sales.streamyx_sales) (TMJDV)':
      This aggregation is unsupported: Attribute
      This aggregation is unsupported: Std. Dev
      This aggregation is unsupported: Std. Dev (Pop.)
      This aggregation is unsupported: Trunc Week Number
      This aggregation is unsupported: Variance
      This aggregation is unsupported: Variance (Pop.)
      This function is unsupported: % with parameter types 'integer, integer'
      This function is unsupported: ABS(number) with parameter types 'float'
      This function is unsupported: ABS(number) with parameter types 'integer'
      This function is unsupported: ACOS(number) with parameter types 'float'
      This function is unsupported: ASCII(string) with parameter types 'string'
      This function is unsupported: ASIN(number) with parameter types 'float'
      This function is unsupported: ATAN(number) with parameter types 'float'
      This function is unsupported: ATAN2(y number, x number) with parameter types 'float, float'
      This function is unsupported: CHAR(integer) with parameter types 'float'
      This function is unsupported: CHAR(integer) with parameter types 'integer'
      This function is unsupported: COS(angle) with parameter types 'float'
      This function is unsupported: COT(angle) with parameter types 'float'
      This function is unsupported: DATEPART_DAYOFWEEK_INTERNAL with parameter types 'date'
      This function is unsupported: DATEPART_WEEK_INTERNAL with parameter types 'date'
      This function is unsupported: DATETIME with parameter types 'integer'
      This function is unsupported: DEGREES(number) with parameter types 'float'
      This function is unsupported: EXP(number) with parameter types 'float'
      This function is unsupported: LN with parameter types 'float'
      This function is unsupported: LN(number) with parameter types 'float'
      This function is unsupported: LOG with parameter types 'float'
      This function is unsupported: LOG(number, [base]) with parameter types 'float'
      This function is unsupported: PI()
      This function is unsupported: POWER with parameter types 'float, integer'
      This function is unsupported: POWER with parameter types 'integer, integer'
      This function is unsupported: POWER(number,power) with parameter types 'float, integer'
      This function is unsupported: POWER(number,power) with parameter types 'integer, integer'
      This function is unsupported: RADIANS(number) with parameter types 'float'
      This function is unsupported: ROUND(number, [decimals]) with parameter types 'float'
      This function is unsupported: ROUND(number, [decimals]) with parameter types 'float, integer'
      This function is unsupported: SIGN(number) with parameter types 'float'
      This function is unsupported: SIN(angle) with parameter types 'float'
      This function is unsupported: SPACE with parameter types 'float'
      This function is unsupported: SPACE(number) with parameter types 'integer'
      This function is unsupported: SQRT(number) with parameter types 'float'
      This function is unsupported: SQUARE with parameter types 'float'
      This function is unsupported: TAN(angle) with parameter types 'float'
      This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
      This function is unsupported: The date part named 'week' for the date function: DATEDIFF(date_part, start_date, end_date, [start_of_week])
      This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'week' for the date function: DATENAME(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'week' for the date function: DATEPART(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'weekday' for the date function: DATENAME(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
      This function is unsupported: The date part named 'weekday' for the date function: DATEPART(date_part, date, [start_of_week])
      This is unsupported: SELECT ... INTO
      This is unsupported: Temporary tables
      

      Attachments

        1. server.log
          765 kB
          Ramesh Reddy
        2. server.log
          691 kB
          Ramesh Reddy
        3. tablue-wireshark.pcapng
          117 kB
          Ramesh Reddy

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-rareddy Ramesh Reddy
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: