People Innovation Excellence
 

Working With in-Database Data

Database processing enables blending and analysis against large sets of data without moving the data out of a database, which can provide significant performance improvements over traditional analysis methods that require data to be moved to a separate environment for processing. Performing analysis in the database can save processing time.

With TIBCO Spotfire, if a column is added to a database table you need to perform a Refresh Schema operation in Spotfire in order to see the new column in the analysis. Not all users will have the sufficient database privileges to perform a full schema refresh. However, changes to the actual data can be updated using a simple Reload/Refresh Data by most users. But, there are some limitations on using TIBCO Spotfire:

Limitation

Why?

The table visualization and the Details-on-Demand (D-o-D) cannot display more than 10000 rows from an in-database data source. The table and the D-o-D do not support data from cubes. Virtual columns are not supported for in-database data. There is a preset limit of 10000 rows to prevent large databases from overflowing Spotfire.
Marking in table visualizations is only supported if the underlying database table has a primary key defined. A primary key is required to know which rows to mark.
The summary table cannot be used with in-database data. The summary table has not yet been adjusted to be able to handle in- database data.
Not all of the standard Spotfire aggregation methods and expressions are available on all external systems. On the other hand, there may be other methods available that Spotfire does not have by default. The aggregation methods supported by the external data source determines which methods will be available for in- database data.
Automatically created date and time hierarchies are not available for in- database data. The shortcuts for setting up date and time hierarchies have not been adjusted to handle in- database data.
If the connection to the external data source is lost, no further analysis using that data source can be performed. Since no external data is stored within the analysis in runtime and each change induces a new query to be sent to the external data source, the data source must be available as long as changes to the visualizations are to take place.
You cannot delete columns or rows from in-database data tables. In- database data tables contain no data in runtime so nothing can be deleted.

Source:
https://docs.tibco.com/pub/spotfire/7.0.0/doc/html/data/data_working_with_in-database_data.htm


Published at :
Leave Your Footprint

    Periksa Browser Anda

    Check Your Browser

    Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

    Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

    Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

    Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

    We're Moving Forward.

    This Site Is No Longer Supporting Out-of Date Browser.

    If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

    Best viewed with one of these browser instead. It is totally free.

    1. Google Chrome
    2. Mozilla Firefox
    3. Opera
    4. Internet Explorer 9
    Close