Prabandha Nakarmi Posted May 23, 2023 Share Posted May 23, 2023 I have linked ODBC database to the spotfire analysis. However, the spotfire fails to extract all new data from the database. Could you please help? Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted May 24, 2023 Share Posted May 24, 2023 Hello!To start with, could you please describe the issue in a bit more detail, including the following (but any additional details help):* "spotfire fails to extract all new data from the database" - do you get any kind of error then (if so, please share it), or do you mean that you just get the original data from when you first created the analysis, but no additional data that has been added in your database after that, or something else?* For testing, what happens if you create a new analysis connecting to the same data source/the same exact data - do you get that new data then?* Are you using the installed client (Spotfire Analyst/Desktop) or a web client to open the Spotfire analysis now? * What Spotfire version are you using? Link to comment Share on other sites More sharing options...
Prabandha Nakarmi Posted May 24, 2023 Author Share Posted May 24, 2023 Hi Fredrik,Yes, spotfire failed to extract all of the additional data. It extracted some of the new data but not all. (The picture in black is what I see in the extracted table in spotfire. Other pictures are from database which shows all the values that I want.) One solution is if I reset all the filters and reload data linked, I get all my data extracted. This solved the problem. However, not practical because I have to use multiple filters every time.Yes, with the new analysis, I am getting a new data and it includes all the data.I am using both Spotfire Analyst and web client.I am using spotfire version 12.0.3.Could you please help?Thanks! Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted May 26, 2023 Share Posted May 26, 2023 Hello again,Based on this, the first thing I would check is if that data source has been set to use stored data, which means that it's linked to the underlying data source but only updated when you trigger a reload manually (alternatively, it could have been set as embedded). You can read more about this in the manual:https://docs.tibco.com/pub/sfire-analyst/12.4.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=save%2Fsave_embedded_or_linked_data.htm&rhsearch=embedded%20stored&rhhlterm=embedded%20stored&rhsyns=%20As stated and illustrated there, "The data loading settings are, in general, available when clicking on a data source node in the Data canvas, but you can also change settings directly when saving an analysis." so check in one of those places (I like using the Save As dialog to get a quick overview of the setting for all data sources) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now