abcloudz

Learn more about

PostgreSQL

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 […]
Viacheslav Kim

Building an Intelligent Chatbot with OpenAI LLM using RAG

Chatbots as they come are not something new under the sky. They have populated the web since long ago leaving behind an impressive trail of user annoyance and frustration. Wild repetitions, endless question-answer loops, and downright stupidity were the common laments to splash in jokes among the cubicle drones. The only improvements seemed to be […]
Maksim Kurganetskiy

SaaS Platform Modernization and Database Migration to PostgreSQL on Amazon RDS

Executive Summary Challenge: To modernize its Project and Portfolio Management (PPM) SaaS platform,  OpenText (formerly Micro Focus) made the call to shift its products from on-premises Oracle servers to PostgreSQL on Amazon RDS. They faced various hurdles due to inconsistencies within the database and the legacy architecture of their app. They also requested a reusable […]
Alexander Gora

Custom data migration solution for a complex Oracle to PostgreSQL migration project using AWS DMS

In this post we’d like to share with you our experience in delivering a sophisticated database migration solution on top of AWS DMS for one of our large enterprise customers. The client is a large technology corporation that provides software solutions and services for telecom giants and mid-size companies. They ran numerous Oracle databases where […]
Alexander Gora

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We were using AWS SCT build#660 to convert one of our Oracle test databases. AWS SCT provides functionalities for the most efficient migration from Oracle to PostgreSQL. However, there is a common challenge with implementing the Oracle NumToDSInterval […]
Oleksii Savchenko

Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. AWS SCT promises a very high level of migration efforts, however it is very rare that 100% automation is achieved. In this article we’ll look into conversion of INSERT ALL statements, which are quite popular in Oracle code. […]
Oleksii Savchenko

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported data types

In this post we explore the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We’ll look into conversion of Oracle “aliases”. We were using AWS SCT build #660 to convert one of our Oracle test databases. The challenge Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used […]
Oleksii Savchenko
12

Hi there! How can I help you?