More with tags:

AWS cost optimization is both an exciting opportunity and a challenging necessity for growing businesses. One of our clients, a provider of a niche SaaS solution for 35 partners, approached us with a critical problem: their AWS costs were rising steadily, but this increase was not directly proportional to the addition of new clients. Instead, […]

Imagine a scenario where a data analyst needs to generate SQL queries to extract specific information from a complex data warehouse, but without deep knowledge of SQL. Our goal was to create an AI assistant that translates natural language to SQL, and we wanted to find the optimal large language model (LLM) for this task. […]

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

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

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, […]

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

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

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. […]

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

ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 2014 to Azure Databricks for a leading global retailer operating 3,000 offline stores across 40 countries. This migration was essential for addressing physical server limitations and outdated technology that hindered data processing and storage capabilities. Embracing Big Data […]

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

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

Data is the lifeblood of any business. The ability to extract insight and value from data plays a critical role in determining long-term success. Efficient data utilization can drive streamlined business processes, reduce waste, and enable well-informed strategic decisions. With the advent of cloud-powered AI and analytics tools, organizations now have unprecedented access to transformative […]

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. How to estimate the cost of a RAG chatbot correctly? Start by separating infrastructure, model usage, embedding usage, and expected traffic, then calculate each layer on its […]

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