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.
Thank you for the detailed description. We will consider this enhancement.
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
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
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
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
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.
Hello
What about tables or colomn ?
Could you please describe how this is implemented?
can u give an example how to do this ?