Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Categories sql support
Created by Guest
Created on Mar 6, 2018

Function compatibility help

Information of supported functions is essential in order to write good performing queries. Function support for Data Sources could he part of Studio help. Developers could quickly check the compatibility of functions used in their queries.

  • Attach files
  • Guest
    May 15, 2018

    Sorry about that, Fred.  I corrected the link.

  • Guest
    May 11, 2018

    Jason – I cannot log into that site. It says, no such email address exists.

    Fred

  • Guest
    May 10, 2018

    Hi Kelsey and Fred, 

    Thanks for your feedback.  We're looking at ways to improve the capabilities for supported data sources on an on-going basis.  Additionally, you can see this idea to auto / self tune the capabilities rather than have the user edit the XML capabilities files:

    https://ideas.tibco.com/ideas/TDV-I-6

    Regards, 

    Jason

  • Guest
    Apr 19, 2018

    Kelsey - i agree.  We're facing this right now as more and more, and larger, queries are added to our system and we hit the magic showplan button.  Lo and behold, basic fundamental functions like TO_CHAR and MAX aren't being pushed down to Oracle or SQL Server.   A few hours spend manually editing the clumsy XML capabilities files has improved performance immensely.   The help I received from Anil in support was timely, professional, and clear.   But I'd still like #1) much improved capabilities files for the most commercially used databases worldwide, and #2) maybe an interface thru Studio for maintaining and enhancing capabilities files.

  • Guest
    Apr 18, 2018

    It is super annoying to later find that the function you used wasn't supported in the source and is therefore causing the query to execute in TDV (slower) and not in the source. You realize this only after looking through the plan, which most users don't dig through.