AWS Partner Network (APN) Blog
Category: Database
Database Modernization Workshops Focus on Deep Dive Understanding of AWS Database Services
The APN Navigate specialization track for Database Services enables APN Partners to build a practice around AWS Database Services such as HAQM DynamoDB and HAQM Aurora. AWS offers the broadest selection of purpose-built databases for all your application needs. Upon completing the APN Navigate for Database Services specialization track, APN Partners are eligible for a free Data Modernization Workshop.
Change Data Capture from On-Premises SQL Server to HAQM Redshift Target
Change Data Capture (CDC) is the technique of systematically tracking incremental change in data at the source, and subsequently applying these changes at the target to maintain synchronization. You can implement CDC in diverse scenarios using a variety of tools and technologies. Here, Cognizant uses a hypothetical retailer with a customer loyalty program to demonstrate how CDC can synchronize incremental changes in customer activity with the main body of data already stored about a customer.
How to Proactively Monitor HAQM RDS Performance with Datadog
To proactively identify and remediate potential errors, you need deep visibility into your entire HAQM RDS environment. This post shows you how Datadog can fetch data from HAQM CloudWatch and your HAQM RDS database instances to give you a comprehensive view of your cloud environment. We also dive into how you can automatically detect performance anomalies, abnormal throughput behavior, and forecasting storage capacities.
How Swisscom Saved DroneAnalytics 60% on AWS Services by Using the AWS Well-Architected Framework
DroneAnalytics offers hardware and software solutions for drones and connected objects. The consulting services from Swisscom, based on the AWS Well-Architected Framework, enabled them to more properly monitor their consumption of AWS services. By leveraging Well-Architected best practices and working with Swisscom, DroneAnalytics saved 60 percent on their AWS spend, whilst maintaining the same or better levels of operational efficiency, reliability, and performance.
Best Practices from Onica for Optimizing Query Performance on HAQM Redshift
Effective and economical use of data is critical to your success. As data volumes increase exponentially, managing and extracting value from data becomes increasingly difficult. By adopting best practices that Onica has developed over years of using HAQM Redshift, you can improve the performance of your AWS data warehouse implementation. Onica has completed multiple projects ranging from assessing the current state of an HAQM Redshift cluster to helping tune, optimize, and deploy new clusters.
Developing Migration and Rapid Application Development Strategies for SAP S/4HANA on AWS
Migrating from an on-premises SAP environment to SAP S/4HANA on AWS can appear intimidating, particularly for organizations that have little experience with cloud infrastructure. There’s good reason for caution: shifting mission-critical workloads without proper planning can disrupt your business. Fortunately, a suite of powerful tools from AWS and Deloitte can help you complete a migration or greenfield deployment efficiently and with minimal disruption.
How Mactores Tripled Performance by Migrating from Oracle to HAQM Redshift with Zero Downtime
Mactores used a five-step approach to migrate, with zero downtime, a large manufacturing company from an Oracle on-premises data warehouse to HAQM Redshift. The result was lower total cost of ownership and triple the performance for dependent business processes and reports. The migration tripled the customer’s performance of reports, dashboards, and business processes, and lowered TCO by 30 percent. Data refresh rates dropped from 48 hours to three hours.
Velocity Technology Solutions Helps Change Healthcare Migrate SAP and Oracle Workloads to AWS
Velocity Technology Solutions is an APN Premier Consulting Partner with AWS Competencies in SAP and Oracle. They provide enterprise application management, including cloud management for all of the Tier 1 applications, including SAP, Infor Lawson, JD Edwards, Oracle E-Business Suite, PeopleSoft, Kronos, and Hyperion. Velocity recently helped Change Healthcare with their IT needs and migrated their SAP and Oracle workloads to AWS.
AWS Service Ready Helps Customers Find Tools and Products Integrated with HAQM RDS
The HAQM RDS Ready Program makes it easy for AWS customers to find products and solutions that integrate with HAQM RDS database engines including HAQM Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server. HAQM RDS Ready Partners provide tooling for HAQM RDS adoption in areas like migration, performance, governance, and monitoring. They also support the use of the HAQM RDS platform as a back-end for applications deployed within a customer’s AWS account.
Optimizing Presto SQL on HAQM EMR to Deliver Faster Query Processing
Seagate asked Mactores Cognition to evaluate and deliver an alternative data platform to process petabytes of data with consistent performance. It needed to lower query processing time and total cost of ownership, and provide the scalability required to support about 2,000 daily users. Learn about the the three migration options Mactores tested and the architecture of the solution Seagate selected. This effort improved the overall efficiency of Seagate’s HAQM EMR cluster and business operations.