Category: Database

As you design, develop, and build SaaS solutions on AWS, you must think about how you want to partition the data that belongs to each of your customers (tenants). In this post, experts from AWS SaaS Factory focus on what it means to implement the pooled model with Amazon DynamoDB. We’ll outline basic strategies to partition and isolate data by tenant, and illustrate common techniques you can use to avoid the “hot” partition problem that’s often associated with partitioning tenant data in a pooled model.

Oracle customers have common questions about their licensing options when considering deployment to AWS. Oracle customers who do not proactively confirm their options risk spending too much on licensing. Customers may also face an Oracle audit that could expose avoidable license compliance issues. AWS has a variety of options for customers considering deployment of Oracle to AWS. When done properly, customers can significantly optimize their Oracle license costs when deploying to the proper AWS service.

The APN Navigate specialization track for Database Services enables APN Partners to build a practice around AWS Database Services such as Amazon DynamoDB and Amazon 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 (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.

To proactively identify and remediate potential errors, you need deep visibility into your entire Amazon RDS environment. This post shows you how Datadog can fetch data from Amazon CloudWatch and your Amazon 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.

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.

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 Amazon 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 Amazon Redshift cluster to helping tune, optimize, and deploy new clusters.

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.

Mactores used a five-step approach to migrate, with zero downtime, a large manufacturing company from an Oracle on-premises data warehouse to Amazon 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 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.