Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Access
Created by Guest
Created on Oct 28, 2016

RELATED IDEAS

Option to Automatically Create Table Relations for Tables from Relational Databases

It would nice if when adding multiple tables from a relational database there was an option to automatically create the table relations in Spotfire based on the database foreign keys. This would save a lot of time and ensure that the relations remain the same as in the database.

  • Attach files
  • Guest
    Feb 28, 2020

    Thomas,

    I like that idea for the star schema in idea "TS-I-5488".

    The idea I had submitted here was when our company was fairly new to Spotfire and we've certainly gotten more efficient with adding tables (the new "Data Canvas" has also been a huge improvement here recently also).

    But ya the idea I submitted (TS-I-5294) was dumber/simpler. I just wanted to be able to select 2 separate related tables to import from a single relational database and keep them as separate tables without import columns from one to the other, while having Spotfire go ahead and automatically create the data table "Relations" between the tables in the Spotfire document based on the foreign keys from the relational database.

    Thanks for following up!

    Reply
  • Guest
    Feb 23, 2020

    This is supported in data connection views. Would you like to be able to load for example a star schema into Spotfire then please vote and comment on this idea https://ideas.tibco.com/ideas/TS-I-5488.

    Reply
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved