Platform overview

Automat BI operates on a three-tier architecture designed to decouple the user experience from physical data storage. By separating these concerns, the platform ensures that changes to the underlying database technology do not disrupt the end-user interface or business logic.

• User Interface (UI) Layer: Provides the entry point for all interactions. It routes requests through specific modules: Dashboards and Reports for data consumption, Pipelines for movement, and the Admin Console for system configuration.

• Data Abstraction Layer: Acts as the system’s logic engine.

  • The Catalog converts technical data into logical views and applies security protocols.

  • The Inventory identifies the physical location of the data and translates queries into the specific language (dialect) required by the target database.

• Data Storage Layer: The physical persistence tier. The system directs processed queries to the appropriate environment—whether a high-speed analytical database like ClickHouse, a cloud warehouse like BigQuery, or file-based storage like S3.