Remote Tables

Overview

A remote table in a data table that is located on a remote server and can be accessed and queried just like a local table. The data in the remote table is typically stored in a different format or location than the data warehouse, and may be sourced from external systems such as external databases or web services. Remote tables can be used to integrate data from multiple sources into a single data warehouse for easier analysis and reporting.

Remote table are used to define a schema for the data you want to retrieve from an external source & maintain the data in the defined schema of the table. external sources Include excel files maintained by users, & any other third party source systems.

Remote Tables can source data from multiple excel files Or directly from external system.

Files Connection To capture the Imported data from semi-structured excel files, remote tables are Introduced. Multiple excel files used for offline data collection can be Imported directly without making any changes to users excel format or content with JustPerform's smart user Interface for remote tables. After Import, this structured data can be used for further data analysis, exploration & even further data calculations/processing or data visualizations.

System Connection The data in the remote table can be typically sourced from an external system such as an external database, web service, or other external data source. Remote tables are used to integrate data from multiple sources into a single data warehouse for easier analysis and reporting. To access the external system, a connector or an API is required. This connector or API will allow the data warehouse to extract the data from the external system and make it available for querying within the JustPerform. This way, JustPerform can be a single interface to access data stored in multiple locations, making it easier to manage and analyze that data.