Modernizing the Oracle ODS Data Warehouse for SaaS flexibility with PostgreSQL on AWS

Imagine trying to keep up with the evolving needs of higher education institutions while ensuring your systems are cost-effective and scalable. This was the challenge faced by our client, a company providing a suite of software solutions for educational institutions. They needed to modernize one of their core components—an Operational Data Storage (ODS) system, which essentially served as a Data Warehouse for preparing data for BI (reporting), originally built on Oracle—by migrating to PostgreSQL in AWS. The primary goal of […]

Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)
Faster, Cheaper Multi-Cloud CI/CD Pipeline

In this blog post, we will introduce our custom multi-cloud CI/CD (continuous integration and continuous delivery) pipeline, built to facilitate the deployment of applications across various cloud environments. Our solution allows seamless deployments with minimal customization, ensuring faster results and reduced costs for our clients. Whether working with AWS, Azure, or Google Cloud, we can deliver a consistent deployment process that simplifies development, operations, and scaling.The driving problem behind this solution is simple: our clients operate in diverse environments and […]

Oleksii Svitlychnyi
AWS Confirms The High Quality of Our GenAI Solutions

At ABCloudz, we are committed to delivering quality and trustworthiness in every solution we create. Recently, two of our AI-powered solutions, Natural Language Interface for Data Platform and AI Text Classification and Matching, successfully passed the rigorous AWS Foundational Technical Review (FTR). This achievement validates our technical expertise and reinforces our commitment to delivering reliable, high-performance solutions that meet AWS’s exacting standards. What is the FTR and what it takes to pass? The AWS Foundational Technical Review is a comprehensive […]

Oleksii Svitlychnyi
Analyzing Migration Project Efforts and Crafting the Project Plan — Part 3

Welcome to the third blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In our first and second blog posts, we explored the critical role of defining workloads in migration projects and laid out the process of capturing the current architecture and designing the future state architecture as part of the first step of the methodology — Future State Architecture Design.This provided a solid foundation for understanding the scope and […]

Adam Robertson
Database migration with AWS SCT: Solutions for typical conversion issues

Migrating Oracle databases to PostgreSQL or MySQL with AWS Schema Conversion Tool (AWS SCT) can present a range of challenges, from unsupported data types to limitations in automated code conversion and potential performance issues. AWS SCT offers powerful capabilities to automate these migrations, but it may not always deliver optimal results or handle complex Oracle constructs efficiently. In these cases, manual adjustments and optimizations are required to ensure a seamless transition to the target database. At ABCloudz, our team has […]

Oleksii Svitlychnyi
Handling null and empty string differences in Oracle and PostgreSQL

When migrating from Oracle to PostgreSQL, one of the most important differences to consider is the treatment of null and empty string values. In Oracle, null and empty string are treated as the same entity, but in PostgreSQL, they are distinct. Failing to account for this distinction during migration can lead to logical errors and unexpected behavior in the database. This post will explore key nuances and demonstrate how to handle these differences effectively. Comparing null and empty string In […]

Oleksii Savchenko
How to Optimize Oracle-to-PostgreSQL Migrations Using AWS SCT Extension Pack

The AWS SCT Extension Pack is designed to emulate Oracle’s system functions, procedures, and other database objects within PostgreSQL. This emulation is achieved by creating a special schema in PostgreSQL, named aws_oracle_ext, where these functions and objects are stored. This pack simplifies migration by replacing Oracle-specific calls with their PostgreSQL equivalents, ensuring that the code functions correctly post-migration. For example, consider the following transformations: Oracle PostgreSQL SELECT sysdate FROM dual; SELECT aws_oracle_ext.sysdate() SELECT to_char(sysdate, ‘dd.mm.yyyy hh24:mi:ss’), to_char(sysdate, ‘dd.mm.rrrr’) FROM dual; […]

Oleksii Savchenko
Calculate the Total Cost of a RAG-Based Solution

This blog post examines the operational expenses of the AI-powered chatbot solution introduced in our previous blog posts, Custom AI chatbot using RAG and Deployment of AI-Powered Chatbot. This solution operates on the AWS cloud while integrating OpenAI’s language model. We will discuss the financial aspects of infrastructure costs and analyze how to estimate expenses for AI resources, such as Language Model as a service. Cost Structure of a Custom AI Chatbot Solution Operating expenses for our AI chatbot solution […]

Oleksii Svitlychnyi
Deployment of AI-Powered Chatbot

This blog post focuses on the architecture and deployment of the AI-powered Chatbot solution that we described in our earlier blog post Custom AI Chatbot Development Using RAG. This solution is built for the AWS cloud but uses OpenAI as an LLM. We’ll dive deep into the CI/CD process and AWS deployment architecture of the backend application. AWS Deployment Architecture Our solution represents a rather typical configuration of a web project deployed to AWS. Click or tap on the picture […]

Kostiantyn Odynets, Oleksii Svitlychnyi
ABCloudz achieves Amazon CloudFront Delivery Partner Status

We are thrilled to announce that ABCloudz has achieved the status of Amazon CloudFront Delivery Partner as of early June. This prestigious recognition by AWS underscores our deep expertise in content delivery network (CDN) services and our commitment to providing top-notch solutions that adhere to the highest industry standards. Achieving the Amazon CloudFront Delivery Partner status involved a comprehensive validation process where AWS assessed our technical capabilities and customer success stories. This certification is a testament to our proficiency in […]

Adam Robertson
Case Study: Fast and secure media content delivery with Amazon CloudFront and Lambda@Edge

This case study shows how ABCloudz engineering team resolved site performance issues using Amazon CloudFront and Lambda@Edge of AWS. Challenge Our partner iCleanse offers its clients the Swift UV devices, designed to disinfect hands and mobile phones. As the device disinfects a phone within 15 seconds, it simultaneously displays sponsored video content, generating advertising revenue. Businesses of any type can benefit from installing these disinfection stations, not only by reducing costs on traditional disinfection methods and aligning with green initiatives […]

Viacheslav Kim
Case Study: Boosting Online Building Materials Marketplace Performance with Amazon CloudFront and Lambda@Edge 

Our client aimed to develop an online marketplace for building materials, designed to manage intricate online transactions and ensure a top-notch global user experience, supported by stringent security and exceptional performance standards. This case study details how ABCloudz utilized Amazon CloudFront, coupled with Lambda@Edge for dynamic content delivery. By deploying CloudFront, we significantly reduced web application load times, which is directly linked to improved user satisfaction and higher conversion rates. This deployment addressed key technical challenges, such as high traffic […]

Viacheslav Kim
AWS Migration Competency Attained

Workload migration represents a pivotal milestone in the AWS customer journey, and our paramount focus is on facilitating a clear and seamless migration for our customers. Consequently, ABCloudz is thrilled to announce our recent achievement of the AWS Migration Competency, reaffirming our commitment to providing comprehensive and exceptional cloud migration solutions. What does this achievement mean for you? Attaining the Migration Competency sets ABCloudz apart as an AWS Partner with a proven ability to smoothly migrate clients of all sizes […]

Adam Robertson
Development of a Healthcare App for Allergy

Explore how our allergy management application enhances patient care through advanced medication tracking, symptom and environmental trigger monitoring. Our customer, a renowned pharmaceutical company, expanded their business model to include a “business-to-business” approach alongside their core drug and medical device production under their own brand. They started manufacturing medications for other medical providers and also offer them custom mobile application development to support specific patient treatment scenarios. To enable rapid and flexible app development, we created a low-code platform for […]

Alexey Koryagin, Oleksii Svitlychnyi
Smart Allergy Medication with BLE Dispenser

Explore the challenges and triumphs of developing specialized firmware, designing an energy-efficient medical device, and integrating custom mobile and web applications for a leading pharmaceutical company.  Their innovative strategy goes beyond traditional drug production, incorporating smart devices into product packaging. This transforms the package into a comprehensive digital ecosystem, complete with mobile and web applications. These applications not only track medication usage but also forge a connection between patients and healthcare providers, enhancing the overall healthcare experience.Their technological advances and […]

Kirill Zakharenkov

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?

ABCAssist