AWS Partner Network (APN) Blog
Category: Database
How Mactores Tripled Performance by Migrating from Oracle to Amazon 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 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 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 Amazon RDS
The Amazon RDS Ready Program makes it easy for AWS customers to find products and solutions that integrate with Amazon RDS database engines including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server. Amazon RDS Ready Partners provide tooling for Amazon RDS adoption in areas like migration, performance, governance, and monitoring. They also support the use of the Amazon RDS platform as a back-end for applications deployed within a customer’s AWS account.
Optimizing Presto SQL on Amazon 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 Amazon EMR cluster and business operations.
Enabling Customer Attribution Models on AWS with Automated Data Integration
Attribution models allow companies to guide marketing, sales, and support efforts using data, and then custom tailor every customer’s experience for maximum effect. Combined together, cloud-based data pipeline tools like Fivetran and data warehouses like Amazon Redshift form the infrastructure for integrating and centralizing data from across a company’s operations and activities, enabling business intelligence and analytics activities.
Identifying and Resolving Application Performance in Hybrid Environments with NETSCOUT
By using NETSCOUT’s Application Management Solution available in AWS Marketplace, Forte Data Solutions was able to quickly resolve latency issues of web-based statistical applications. NETSCOUT helped the customer gain visibility into load, latency, errors, and dependencies of their application, quickly identify the root cause of latency issues, fix them, and thus eliminate hundreds of redundant daily CloudWatch Alarms.
Microsoft SQL Standard Clustering Across AWS Availability Zones with Zadara Storage as a Service
With Zadara offering Storage-as-a-Service across Availability Zones, the platform’s centralized storage services release the ability to connect multiple Microsoft (MSSQL) servers in a standard Windows Server Failover Cluster model to a single set of shared storage volumes. This removes the need for MSSQL Enterprise Edition licensing and the doubling up of Amazon EBS disk for Amazon EC2 instances. In this post, explore the use of high availability MSSQL Standard Clustering on AWS with Zadara.
AWS Service Ready Helps Customers Find Validated Products That Integrate with AWS Services
Before making a purchasing decision, AWS customers tell us they want to know if a tool or application will integrate with AWS services running in their cloud environment. To meet this need for customers, we are excited to introduce AWS Service Ready. This program identifies and validates products from APN Technology Partners that integrate with specific AWS services, and recommends these products to customers.
How to Enable Mainframe Data Analytics on AWS Using BMC AMI Cloud Analytics
Mainframe proprietary storage solutions such as VTLs hold valuable data locked in a platform with complex tools. This can lead to higher compute and storage costs, and make it harder to retain existing employees or train new ones. When mainframe data is stored in a cloud storage service, however, it can be accessed by a rich ecosystem of applications and analytics tools. BMC AMI Cloud Analytics enables mainframe customers to backup and archive directly to AWS.
How to Migrate Oracle Workloads to VMware Cloud on AWS
Some Oracle workloads, such as Oracle Real Application Cluster (RAC) or WebLogic application clusters, have specific networking and storage requirements, which can be met with VMware Cloud on AWS. This post details the various considerations and migration options users have for Oracle workloads. Specifically, we examine in-depth how to migrate an Oracle database from an on-premises environment to AWS using AWS Database Migration Service (AWS DMS).