Connection to Dedicated PostgresQL Database-1 - The business case for a dedicated SQL database

1 - The business case for a dedicated SQL database

Video Transcription

Video Summary

This video explains how to gain direct access to your OASIS LMS data for internal reporting or analytics. OASIS is a multi-tenant SaaS where all clients’ data reside in a shared database, preventing direct client access due to data privacy concerns. Previously, sharing the database posed risks of exposing other tenants’ data. The solution is creating dedicated database clusters for each client, isolating their data for secure access. Future tutorials will guide users on accessing these private databases, enabling data retrieval while maintaining the multi-tenant system’s security and privacy.

Keywords

OASIS LMS

multi-tenant SaaS

database clusters

data privacy

internal reporting

KGConcept: Multi-Tenant Architecture (10)

KGConcept: Oasis LMS (10)

KGConcept: Client (8)

KGConcept: Shared Database (9)

KGConcept: Database Cluster (8)

KGConcept: Direct Database Access (10)

KGConcept: Security (7)

KGConcept: Data Isolation (9)

KGConcept: Single-Tenant Setup (9)

KGConcept: Internal Reporting (6)

KGConcept: Data Warehousing (6)

KGConcept: Analytics Platform (6)