Classification of data sources queried directly and in-memory

Our Dashboard application supports more than 15 data sources which includes both files type and server type connections. Out of these, server type connections issue query directly to the database for results, on each and every operation done in the dashboard. Whereas for file type connections, querying is not applicable directly, so data are moved to in-memory initially and further processing are carried out there.

List of data sources whose data are moved to in-memory for processing are - Microsoft Excel, CSV, JSON, Text Document, Microsoft Access, Microsoft Azure Table Storage, Salesforce, ODBC ANSI SQL and Web Data Source.

List of data sources which are directly communicated are - Microsoft SQL Server, Microsoft SQL Server Analysis Services, PostgreSQL, SQLite, MySQL, Oracle, ODBC ANSI SQL, Spark SQL and Hive.