What happens to the information model if we change the table names in the target database?
Article ID: KB0083837
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
What happens to the information model if we change the table names in the target database?
Looking at the Data Sources tab within Information Designer, you may want to change the table name listed. For example, the table “FILM”
Looking at the Data Sources tab within Information Designer, you may want to change the table name listed. For example, the table “FILM”
Issue/Introduction
What happens to the information model if we change the table names in the target database?
Environment
All supported environments
Resolution
You will need to contact your DBA (database administrator) and change the table name within the target database, but by doing so you will break all information links within Spotfire that are connected to this table.
If you look at a Column object in Spotfire Information Designer, you will see the name of the table and the full location of the object. When you change the name of the table outside of Spotfire, it will not change within Spotfire, because Spotfire is not controlling the change. You would have to recreate all of the column objects and have them point to the new table name.
If you look at a Column object in Spotfire Information Designer, you will see the name of the table and the full location of the object. When you change the name of the table outside of Spotfire, it will not change within Spotfire, because Spotfire is not controlling the change. You would have to recreate all of the column objects and have them point to the new table name.
Feedback
Yes
No
Powered by
