abcloudz

Handling PostgreSQL Routines with More Than 100 Arguments

When working with PostgreSQL, database developers may encounter a limitation when attempting to create routines with more than 100 arguments. PostgreSQL enforces this restriction by setting FUNC_MAX_ARGS to 100 during the server build. Although this limitation is rarely an issue, complex procedures, particularly those migrated from Oracle, may have a significantly higher number of arguments. […]
Oleksii Savchenko

Optimizing Date and Time Conversion in Oracle to SQL Server Migration

Migrating databases from Oracle to SQL Server can be a daunting task, especially when dealing with date and time data. While tools like the SQL Server Migration Assistant (SSMA) offer automated solutions, relying solely on these tools might not always yield the best performance. In this blog, we share examples of how to optimize conversion […]
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 […]
Oleksii Savchenko

Natural Language Interface for Data Platform

Imagine a business analyst whose task is to extract necessary information from a data warehouse to generate various reports. They need to be proficient in crafting SQL queries of any complexity—a challenging and time-consuming feat that requires deep understanding of database structures and SQL language. But what if this business analyst had an AI assistant […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi

AI Text Classification and Matching for Better Decisions

Picture this: You have an AI-powered assistant that helps manage your team’s growth. It works with three types of text data: job descriptions, employee skills, and training programs. You give it a job description and an employee’s skill set, and it pinpoints the perfect training programs to bridge any skill gaps. It’s like having a […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi

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 […]
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 […]
Kostiantyn Odynets, Oleksii Svitlychnyi

Custom AI Chatbot Development Using RAG

You have probably seen and heard about AI-powered chatbots that can converse with the user about website content, or some piece of knowledge related to a company. The world is full of buzz on all things AI, with chatbots driving the headlines. In this article, we’ll share our experience building a full-blown solution from scratch […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi

ABCloudz Achieves Google Cloud Partner Status

ABCloudz has officially become a Google Cloud Partner through the participation in the Google Cloud Partner Advantage program. This achievement marks the beginning of a strategic alliance with Google, emphasizing our commitment to providing cutting-edge cloud solutions. Your Trusted Advisor in the Cloud ABCloudz’ decision to opt for the Service Engagement Model within the Google […]
Adam Robertson

Building a Cloud-Based Lead Management CRM System with Container Architecture

Managing leads in a highly dynamic competitive market is a vital component of salesforce operation. As the consumer landscape expands letting ever growing number of leads come into vision, maintaining consistent and timely lead processing becomes a crucial challenge for the entire business. When a Fintech company operating a vast multi-level partner network of agents […]
Maksym Kurganetsky

Web platform for disinfection stations and advertisement tablets

iCleanse, a prominent out-of-home (OOH) advertising company, is an exclusive manufacturer of disinfection stations suitable for installation in public places such as hotels, hospitals, airports, and malls. Each device comprises the actual disinfection station and an attached tablet that displays advertising messages to users. iCleanse was aiming at significantly increasing the number of these stations […]
Konstantin Mayevsky

Another achievement for ABCloudz: We became an AWS Database Migration Service Delivery Partner

As a leading service provider in the realm of digital transformation and database management, ABCloudz has attained its second AWS Service Delivery Partnership designation and now holds the status of an AWS Database Migration Service (DMS) Delivery Partner. This achievement is a resounding reflection of our company’s exceptional proficiency in providing the highest-quality Amazon cloud […]
Oleksii Svitlychnyi

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

Excellent operational data management to support a complex data infrastructure

According to Business Insider, a single minute of data infrastructure downtime in a data center costs the companies using this data center over $8,000. The more complex your data infrastructure is, the greater the risk of errors that can lead to downtime, compromised data quality, or disruption of vital processes. The challenge lies in the […]
Sergii Zymbytskyi

Developing Low-Code App Builder

Imagine launching healthcare apps in a snap, with minimal coding required. That’s the promise of our latest innovation—a low-code platform specifically designed for the fast-paced world of healthcare. Developed for a leading pharmaceutical enterprise, it’s a game-changer in custom healthcare application development, catering to an array of treatment requirements with unprecedented ease and flexibility. The […]
Konstantin Maevskiy

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?