Spotfire Ideas Portal
Add a new idea Subscribe
Status Implemented
Product Spotfire Data Virtualization
Categories caching
Created by Guest
Created on Apr 12, 2019

RELATED IDEAS

SQL MERGE support for Oracle datasource

We are using Oracle for caching data in Composite 7.0.6. For implementing the incremental cache we were trying to use "MERGE" statement to selectively update data during sync process.

Currently Tibco Support confirmed that there is no support for MERGE statements using Oracle as Datasource.

  • Attach files
  • Guest
    Apr 30, 2019

    Thanks Jason for the confirmation, will check with TIBCO support team.

    Reply
  • Guest
    Apr 30, 2019

    It was implemented in TDV 7.0.0 that released in Jan 2015.

    Reply
  • Guest
    Apr 30, 2019

    Posted this idea as requested by TIBCO Support team since they had mentioned that SQL MERGE is NOT supported in Oracle on composite 7.0.6.

     

    Could you please confirm if the MERGE SQL command will work on Composite 7.0.6 as the page number you have referred in the comment is seen in the ref guide of Composite V8 and not on 7.0.6.

    Reply
  • Guest
    Apr 30, 2019

    MERGE is supported for Oracle.  The syntax and examples in the reference guide on p. 524 should work.  We will look into updating the content so it is clearer that Oracle is supported.

    Reply
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us