Real Time Data Access with Intelligent Caching
With InetSoft’s technology, data access happens in real time by default, which means constant accessibility to the most recent data possible. InetSoft’s data mashup engine has the ability to access almost any data source, seamlessly extracting and combining data from multiple sources simultaneously. The range of sources includes relational databases such as Oracle, SQL Server, PostgreSQL, and MySQL via a JDBC driver, multidimensional databases, salesforce.com, Microsoft Excel spreadsheets, Hadoop/HIVE, Google Adwords and Analytics, SAP, and many more.
While having a real time dashboard constantly updating with fresh data is desirable in some cases, sometimes the sheer volume of data being loaded makes this impractical. These large sets of data are made manageable with InetSoft’s combination of caching, materialized views, and pre-aggregation techniques. For when massive data volumes create slow load times, InetSoft’s data grid cache technology can be set at desired time intervals so the data can be relatively up to date, in accordance with the user's needs. A dashboard can be set to pull in and cache necessary data every day, every hour, or at whatever interval fits your organization’s needs. With InetSoft’s robust data caching, dashboards which process millions of records can loaded and interacted with in real time.
With the data compression of InetSoft’s intelligent caching technology, the processing of Big Data can now occur on a normal sized server. InetSoft’s BI platform has a 90% compression rate and can scale up as performance, usage, and database sizes grow. The flexibility of InetSoft’s real time vs cache technology will enable you to strike a happy medium between fast load times and up-to-date information.