Skip to Main Content
Spotfire Ideas Portal

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
      Drop here to upload
    • 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 ?