Data Warehouse

Data Warehouse

A low-cost data warehouse solution built on open-source technologies: PostgreSQL, Centos, Java, and NGINX.

Key Features

• Can load data from common databases and files. (Oracle, MS SQL, PostgreSQL, Hana, text/Excel files)

• Fully configurable loading logic via a user-friendly website without coding

• Enforces data integrity by applying validations and constraints.

• Supports multiple approaches to collect data: direct access (for databases), email, FTP or direct upload using provided website.

• User-defined, template-based reminders will be sent if a load misses its schedule.

• Generates Excel/Html reports for any set of data.

• Sensitive data will be protected – security at row/column level for defined groups of users.

• Configurable scheduling of loading and/or retrieval of data, reporting, and validation and summarization of data.

• Supports staging of data for transformation, validation, and loading

• Integrates with PowerBI for dashboards and general reporting