Data Access Capabilities for Live Reporting Software
Almost any operational database can be accessed provided there is JDBC connector available. In addition to such open data sources, connectors exist for many others such as XML, SOAP, Java beans (POJO), Microsoft Excel, flat files, OLAP cubes, SAP, PeopleSoft, JD Edwards, salesforce.com, Siebel CRM, Microsoft SQL Server Analysis Services, Hyperion ESSbase, Oracle OLAP, and SAP NetWeaver.
Style Intelligence's data access is live, or real-time, by default. Very large data sets are manageable due to a myriad of optimization techniques InetSoft has developed including caching, materialized views, pre-aggregation and fine tuning options.
When near live reporting is sufficient, Style Intelligence offers a proprietary technology called 'Data Grid Cahce.' It is based on Hadoop and
Map/Reduce concepts, and it stores the data needed for a particular live report in a columnar disk-based cache along with the necessary indexes to support speedy data access. The software can automatically build these data grid caches on preferred schedules basis when the source datasets are particularly large, in the terabyte and up ranges, and when there is a requirement to minimize queries to live operational databases.