Learn more about

PostgreSQL
Over-the-Air Device Firmware Upgrade via Bluetooth

We’ve developed a mobile app and web admin panel that allow a specialized headphone manufacturer for Heavy Metal enthusiasts to swiftly and conveniently deliver firmware updates for their headphones over the air. These headphones do more than just play music; they’re designed to precisely render sound, enhanced by continually evolving custom firmware for each model. How can users stay informed about the latest updates and improvements? This is where our expertise in wireless connected devices truly shines. We have crafted […]

Oleksii Svitlychnyi
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 expected from the further growth of output speed and size of Q&A database. The recent breakthroughs in Artificial Intelligence (AI) brought the benefits of this […]

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 custom algorithm for forthcoming migrations. Solution: The ABCloudz team successfully migrated the OpenText database from Oracle to Amazon RDS cloud. The ABCloudz team leveraged DMS […]

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 they stored billing and other financial data. In an effort to cut costs for operational infrastructure, the company started the migration of their Oracle systems […]

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 function in PostgreSQL. The Oracle NumToDSInterval function is responsible for the conversion of the provided number value of specified time units or expressions to an […]

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. We were using AWS SCT build #660 to convert one of our Oracle test databases. Oracle gives you an option to use the conditional insert […]

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 later as many times as needed. PostgreSQL domains entirely differ from Oracle’s subtypes. Thus, whenever you try to convert PL/SQL code containing variables that are […]

Oleksii Savchenko

Hi there! How can I help you?

ABCAssist