Spotfire Ideas Portal
Imagine the following scenario. We have an existing data connection (e.g. PostgreSQL) that is "shared in the library" and used by our DXP. Currently, in the database, we have only 2 DB views. which we consume in some visualization in the DXP via data tables.
Next, the database team adds 30 more DB views in the database. We have to update the data connection so that those new DB views are added there. Next, we go to (+) button and choose the data connection in the "data connections in the current analysis" and choose the 30 data tables to be added (of course making sure to "Exclude" the once that have been added already).
Having said that, the above process is slow, tedious and error-prone. It would be much more convenient if the 30 new data tables were created automatically when I updated the data connection
Hello, Thomas. Thank you for your message. I didn't realise there is such an option. Thanks
Hi Georgi, have you tested:
Update the data connection in the library by adding the new tables.
Go to your analysis file which is already using the shared data connection and select Data connection properties >Sync
The sync dialog opened should enable you to add all new tables with pre-checked check boxes.
That's the end result that I would like yes, having a data table added after I add a new view to the data connection
Do you mean after you update a connection in the library, any dxp using that connection would automatically add the new tables?