Active Directory Enforcement: Optimizing Database Access and Compliance
In today’s data-driven environment, ensuring database security and regulatory compliance is a critical challenge for organizations across various sectors. The Heimdall Database Access Gateway meets these challenges by providing a robust framework for secure 1) access, 2) control, and 3) compliance, aligning with the strategic goals and mandates of Enterprises. Segregation of Duties (SoD) in […]
Improve Scale and Security for Tanzu Data with No Code Changes
Introduction Getting the most out of your database requires developing a data access layer. The alternative solution is to use a database proxy. The Heimdall Database Proxy for Tanzu Data provides a seamless solution to manage front end connections without any application changes. We are database vendor neutral (e.g. Greenplum, Postgres, MySQL) and grid-cache vendor-neutral […]
Improving Performance and Reliability with Database Workload Management
In today’s world of serverless architectures, high-performance analytics, and stringent SLAs, managing workloads on databases like Amazon Aurora and Redshift has become more complex. The Heimdall Database Proxy offers a robust solution to these challenges, allowing organizations to scale seamlessly and maintain performance under pressure. Let’s dive into how Heimdall’s features—such as per-user connection limits, […]
Active Directory Authentication AND Authorization in Azure
For database deployments in Azure, there are many options to manage authentication. The first is to use pure SQL based authentication, where the user, password and roles are pre-configured on the database. The second is to use Microsoft Entra ID (Formerly Azure Active Directory). In this second case however, user management still ends up being […]
Automated Multi-Tenant Routing for Amazon RDS and Redshift
Software-as-a-service (SaaS) platforms can have challenges scaling a multi-tenant environment when managing data. To isolate a customer’s data, a distinct database per customer is created, and the application simply accesses the proper database as needed for a given customer. There are limits a single database can handle, however. For light workloads, this may be in […]
Active Directory Authentication AND Authorization in AWS
With Amazon RDS, there are many options to manage authentication. The first is to use IAM authentication, which is the preferred method. A second way is to integrate with AWS secrets, allowing for password management in a centralized manner. Another approach is Active Directory integration, as this supports resources that are both in AWS and […]
“Scaling Beyond PostgreSQL PgBouncer and Postgres Pgpool-II
Erik Brandsberg, Chief Technology Officer (CTO), delivered a highly informative and in-depth technical presentation focused on the capabilities and limitations of two widely used PostgreSQL proxies, namely Pg-Bouncer and PgPool-II. This educational session is particularly valuable for Postgres operators who seek to enhance their understanding of advanced traffic management. In addition to discussing the open-source […]
Advanced Connection Pooling for Amazon RDS and Redshift
Background In using databases as a key component of internet infrastructure, IT departments are finding unexpected problems when using DBaaS (Database-as-a-Service). One of these challenges is in connection. There are three areas where connection management can be a problem: CPU overhead when an application “thrashes” connections rapidly by opening, closing and authenticating connections. Memory overhead […]
Advanced Connection Pooling for Azure
Background In using databases as a key component of internet infrastructure, IT departments are finding unexpected problems in particular when using DBaaS (Database-as-a-Service). One of these challenges is in connection management. There are three areas where connection management can be a problem: CPU overhead when an application “thrashes” connections rapidly by opening, closing and authenticating […]
How Heimdall’s Database Proxy Improves Website Response Times with No Code Changes in AWS
Application developers must balance time between coding features and improving performance and scalability. Most believe that focusing on functionality and features is the priority, but features and application response times go hand-in-hand. Slow performance can adversely affect revenue. As the director of IT operations at Questis, a configurable technology platform for financial intermediaries, we realized our […]