Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Created by Guest
Created on May 11, 2016

Allow relinking of an existing information link to a different data source / database / table

I would like the ability to relink an existing information link to a new data source table when the table is exactly the same as the original. Currently, one would need to create a new information link or add the columns from the new table in the existing information link.
  • ADMIN RESPONSE
    Dec 5, 2017

    As of Spotfire 6.5.1 it is possible to redirect elements in an existing data source. Depending on what type of database you use, you can redirect elements to another database catalog and/or schema. For more info on that see Redirecting the Information Model

  • Attach files
  • Guest
    Reply
    |
    Jan 18, 2020

    Thank you for the detailed description. We will consider this enhancement.

  • Guest
    Reply
    |
    Jan 15, 2020

    I think what I meant in my explanation is quite different from what I read so far. My example is suggesting that of a join and not a re-direct to another database and it is as follow:

    You have two tables in a project all having the same datasource>>database>>schema>>TableA>>ColumnsA

    and

    datasource>>database>>schema>>TableB>>ColumnsB

    then you join the TableA to TableB  e.g. with left join  :

    TableA>>ColumnA on TableB>>ColumnB to achieve the desired visualization is satisfied.

     

    Thereafter you want to create a different visualization in the same project so you add another table as an in memory table/information link from

    datasource>>database>>schema>>Tablec>>ColumnsC

    and desired to do a join using left join  :

    TableA>>ColumnA on TableC>>ColumnC

     

    This is currently not possible unless you use relations instead of simply re-using

    TableA>>ColumnA (which is already use but this time) on TableC>>ColumnC

  • Guest
    Reply
    |
    Jan 15, 2020

    Hello Tobias

    This cas is still not possible ? To redirect 1 table (not all) to one catalog?

    Today, it is all in one, and very complexe if something have to change

  • Guest
    Reply
    |
    Dec 27, 2018

    Hello
    The case should not be clause. It is still impossible to redirect a table, or a colomn.

    Plus, the redirection apply on all the Data Source. It means it we want to redirect only a few table on a special catalog or schema, it is impossible.

    It is hard to work with !

     

    Thanks

  • Guest
    Reply
    |
    Apr 2, 2018

    I found this page that seems to explain how redirection works:

    https://docs.tibco.com/pub/sfire-analyst/7.5.1/doc/html/WebHelp/id/id_redirecting_the_information_model.htm

  • Guest
    Reply
    |
    Mar 23, 2018

    The redirecting with the IMSD looks at all data in it. If we need to redirect only 2 tables on 10..... all 10 are redirect.

  • Guest
    Reply
    |
    Mar 23, 2018

    Hello

    What about tables or colomn ?

  • Guest
    Reply
    |
    Nov 9, 2017

    Could you please describe how this is implemented?

  • Guest
    Reply
    |
    Jan 17, 2017

    can u give an example how to do this ?