The application development process is a multi-layered activity with the core idea as the starting point and a well-functioning final product as the top layer. In this post, we will focus on the twists and turns involved in bringing the idea through to the final product. The role of business analysis is to identify and bring together business requirements and software solutions. So, one of the main roles of a business analyst is to outline and present a customer’s idea as a […]

ABCloudz announces that we have achieved a silver competency in Application Integration as a Microsoft partner. This proves the company’s capability to effectively integrate and configure systems that run on Windows servers, Microsoft SQL, and Microsoft .NET. Being a Microsoft partner, our company has access to exclusive training coupled with the latest software solutions. This allows our team to effectively deliver and deploy solutions that can significantly improve clients’ business results. The process of earning Microsoft competency is a complicated […]

Our client is a large pharmaceutical company with a sophisticated data infrastructure. Along with the company’s rapid growth, its data infrastructure started growing as well. At one point, their data infrastructure exceeded 140 SQL Servers united by multiple scripts and connections. This growth made its maintenance more challenging and time-consuming. The customer created a professional support and monitoring team to handle any data infrastructure issues, but this did not solve the entire problem. The customer still had issues with organizing […]

What is a Microservices Architecture? Microservices architecture is a style that structures an app as a set of predetermined services. At its core, such app is split into smaller independent segments that perform their own functions. This approach permits to view microservices as a group of undivided apps that handle their own features. As a result, we get an app that can perform a variety of functions by employing appropriate services. Pros & Cons of Microservices Approach Just like any […]

What is monolithic architecture? Monolithic architecture is known as a traditional approach to software development that is based on a single-unit design. This means that a program is basically a self-contained and independent unit. It consists of a database, client-side user interface, and server-side application. As it is possible to clearly see, a monolithic app is a single logical executable that usually does not interact with other services.   Pros & cons of monolithic approach Let us take a closer […]

Cryptocurrency is one of the biggest trends of the decade that rapidly embraces the domain of online payments. With cryptocurrency and blockchain technology, you increase your technical capacity dramatically. Our development team could not stay aside from such trends, so they jumped into the research and experimented with the latest and greatest. As part of this research, the team had built a cryptocurrency trade app tied to Ethereum, one of the most promising blockchain networks. This is a fully workable […]

The 2022 forecast predicts that the board games market on the global level will reach $21.56 billion by 2025. At the same time, more and more creative individuals have gotten on board with independent game designing and self-publishing. It was just a matter of time until someone would come up with the idea of creating a 3D printed version of oneself for the board game. Well, the Hoplite Game Studios did just that. They turned to ABCloudz to develop a […]

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

In this blog post we continue covering AWS SCT conversion issues, adding to the series where we help developers to deal with complex migration issues that can’t be automated with SCT. Today we are going to look into how SCT Build #660 addresses the conversion of statements with BULK COLLECT clause. In Oracle, you can retrieve an entire result set and store it in a PL/SQL collection type variable in a single operation. This can be completed with a SELECT […]

Here’s one more insight into common code conversion issues while using AWS SCT build number 660. This time, we will tell you how to convert NumToYmInterval from Oracle to MySQL. Oracle has a NumToYmInterval function that converts the provided number value of specified expressions or time units to an interval year to month literal. Usually, interval values appear when it comes to dealing with dates. The challenge MySQL partially supports intervals. However, it doesn’t support storing values of this type […]

We continue our series of common issues pertaining to code conversions with AWS SCT. This time, we analyze the peculiarities of converting REF CURSOR types from Oracle to MySQL with the help of AWS SCT build number 660. In Oracle 9i, there is the predefined SYS_REFCURSOR type, which means that defining our own REF CURSOR types is no longer needed. Normally, we define the CURSOR variable of a weak type with Oracle SYS_REFCURSOR datatype. This applies to the cases when […]

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

We’re proud to announce that ABCloudz has become an AWS Select Consulting Partner, which highlights our commitment to the AWS cloud platform, and bringing the best of this cloud platform to our clients. This great event comes with some worthy achievements – The ABCloudz engineers achieved several certifications as AWS Solution Architect Associates, others received Cloud Practitioner certifications, AWS Accreditation Technical certifications, and AWS Accreditations in Business. – The ABCloudz team could demonstrate an impressive portfolio of projects built on the […]

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

We’d like to invite you to be a part of our fundraiser for ABCloudz UA Team. As you know, Ukraine is under the inhumane attack of Russia right now, many people left their homes, some of them do not have homes anymore…. ABCloudz Inc (former DB Best Technologies) started a GoFundMe Fundraiser to support our UA Team. Currently, our colleagues and their families are looking for new places to live in the Western part of Ukraine, while some appeared in […]