Category: Amazon RDS
Learn how the Heimdall Database Proxy can be configured to provide customer query routing for Amazon RDS for Postgres, although any SQL database type including Amazon Redshift can be supported. This provides a single Heimdall Proxy endpoint to access data for multiple customers from multiple databases, transparently. Heimdall Data provides functionality needed to support many complex database environments, and solves many of the challenges in scaling database access.
Learn how to set up Active Directory authentication with authorization for Postgres. Heimdall Data provides synchronization scripts for other databases as well, allowing all Amazon RDS instance types to be supported in a similar way. Using Active Directory authentication allows organizations to standardize their password and authorization management via a globally available authentication store, reducing management overhead and improving security and auditing capabilities.
As organizations run mission-critical databases on Oracle Exadata, businesses are increasingly looking for proof points of like-to-like performance of these databases on Amazon Web Services (AWS). This post explores how Tata Consultancy Services (TCS) supported a UK-based utility provider’s digitalization journey by comparing performance of their on-premises Oracle Exadata database with Amazon RDS for Oracle.
Organizations the world over rely on the Exadata database platform to operate and manage Oracle databases, simplify data management, and ensure performance-intensive systems are running as expected. While Exadata workloads perform well on premises, customers are looking to achieve the scalability, flexibility, and cost benefits of AWS. Learn how Navisite tests the performance of Exadata workloads once they have been migrated to AWS using Oracle Real Application Testing (RAT).
As software release cycles get progressively faster, coordinating database schema changes with application releases becomes more difficult. For some teams, it may require a complete overhaul of processes and perhaps even a change in mindset but it is possible. Tools such as GitLab and Liquibase can be used to automate the deployment of database schema changes. Learn how Blue Sentry has extensive experience using infrastructure as code (IaC) to improve CI/CD processes and to support better outcomes for customers.
With the new Amazon RDS Ready for Business Applications category, part of the AWS Service Ready Program, customers can now find business application products that follow AWS security, availability, reliability, performance, and other architecture best practices while integrating with Amazon RDS. Amazon RDS Ready business applications are deployed within a customer’s account or provided as SaaS deployed in AWS Partners’ accounts. Learn more about Amazon RDS Ready Ready Partners!
Learn how Q2, a financial experience company that provides digital banking and lending solutions, worked with AWS ISV Partner ALTR, a provider of data security as a service that runs exclusively on AWS, to launch a PCI DSS-compliant application in a fraction of the time it normally takes to achieve certification. Q2’s Biller Direct application provides a centralized payment environment where users can enroll, manage their bills, and view projected spend.
As organizations move to AWS, ensuring you have an effective disaster recovery (DR) strategy in place to manage outages is paramount. Through defining a common understanding of RTO and RPO requirements, organizations can adequately design for DR solutions. Learn how Onica’s Elastic Engineering team co-created a solution with a client that leverages serverless architecture and enables an automated backup and restore for Amazon RDS instances.
Using Amazon AppFlow to Achieve Bi-Directional Sync Between Salesforce and Amazon RDS for PostgreSQL
Many SaaS applications boast of microservices as a means to divide a monolithic architecture into easily manageable solutions. Sometimes these microservices have their own databases. To maintain data consistency across the system, you need to implement a data synchronization system between source and target data persistence layers. Learn how Trantor has developed a solution using Amazon AppFlow to easily synchronize the data between Salesforce and Amazon RDS for PostgreSQL in near real-time.
Baffle Data Protection Services (DPS) provides a data-centric protection layer allowing customers to tokenize, encrypt, and mask data in Amazon RDS at the column or row level, without any application code modifications while supporting a BYOK or HYOK model. Review the architecture for Baffle DPS, and walk through how to launch and test Baffle DPS from an AWS CloudFormation template with Amazon RDS databases to encrypt data at the column level.