In this chapter, you have learned about the main differences between working with in-memory and in-database (external) data and how to combine the two strategies by using data on demand. You understood how to use Spotfire's information links and database connectors and how to get started with streaming (live) data.
We covered in-memory versus in-database data in some detail. There's a need for both methods when working with data in Spotfire. This chapter discussed when and where you might need either strategy and explained the main differences between them. Custom expressions were shown, along with some useful tips for using post aggregation expressions with external systems to enable the use of OVER functions. We also covered data on demand, which is a great way to combine the advantages of in-database and in-memory analytics into a single solution.
We spent...