SYSTEMS AND METHODS FOR ACCESS TO MULTI-TENANT HETEROGENEOUS DATABASES

Systems and methods described herein provide heterogeneous access to tenant databases. A delegator intermediary to clients and tenant database receives a request from a client to perform a database related action. The request identifies a query type and tenant identifier. The tenant databases include a first tenant database of a first database type and a second tenant database of a second type. The delegator identifies a tenant database using the tenant identifier from the request. The delegator determines a database type corresponding to the identified tenant database. The delegator selects, from a plurality of drivers corresponding to respective database types, a driver based on a database type for the identified tenant database. The delegator establishes a database connection using the selected driver between the delegator and identified tenant database. The delegator uses the database connection for performing the database related action from the request.