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

ABCloudz is a global company. Our employees and contractors are distributed across several countries on both sides of Atlantic including Ukraine.  Due to a recent Russian military aggression, many of our colleagues in the middle and central Ukraine decided to relocate and did so. Some are still in transit, on their way to new locations where they will be safe and continue working. While safety of our employees is a number one priority for us, ABCloudz continues fulfilling all duties […]

One of our customers runs a large Azure data center that works with Personal Health Information ( PHI). Before the client contacted us, many of their servers have been running on legacy OS and the overall infrastructure was rather disorganized. The Company’s management was concerned about potential security holes and requested to conduct a thorough security audit. Before contacting ABCloudz, the Company’s IT staff had been aware of potential security gaps in their infrastructure. For example, their data infrastructure included […]

The Instructrr is a startup in the online fitness space. They had an idea of a web-based fitness platform where fitness instructors would directly sell their learning materials and services to the customers. A user can watch fitness streams, study materials about exercises, communicate with fitness instructors, and buy services. The company already operated in the market of fitness services before they contacted ABCloudz. However, they provided most of their services offline, while communication with customers primarily ran via email or […]

Our client is a healthcare testing and biotechnology company that quickly grew from a small antigen development lab into a large producer of various healthcare tests distributed across the U.S. The client developed a new custom device for some of the most rapid COVID-19 tests. It includes a pipette for collecting blood and a small test cassette in which the tested blood should be placed. 15 minutes after placing the patient’s blood into the cassette, rose or red stripes become […]

Recently, the ABCloudz team migrated a customer’s database from Apache Cassandra to Amazon DynamoDB. As part of this project, we needed to run multiple tests to ensure perfect quality for our delivery. However, we faced a problem in setting up the test environment. Even though we were using AWS CloudFormation templates for the EC2 instances, it was taking over 30 mins to get the dev/test environment setup. In addition, our developers couldn’t run parallel regression testing. So, we decided to leverage Docker to automate the environment set up.
In this blog post, we will share our experience with using Docker for automating a NoSQL database migration dev/test environment.

One of the world’s largest distributors of non-food consumable products wanted to rationalize their data platform and business intelligence strategy. Their current IBM DB2 database system lacked a repository to host historical audit-related data, so they could hardly retrieve data from past years. Then we came up with an Azure cloud database solution that could store all the historical data and created Power BI reports on top of it. We performed the IBM DB2 Azure SQL Database migration as a […]

Our customer is the nation’s largest home outdoor care company, serving more than 2.3 million residential and commercial customers across the United States and having revenues reaching up to $2 billion. Before contacting ABCloudz they had severe business reporting issues. The client’s KPI (key performance indicator) reports were extremely inconsistent and took too much time to be completed. These issues dropped the overall efficiency of the client’s reporting. Besides, the client did not have much time and resources for building […]

PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go. Our client wanted to develop a locator and tracking solution t that will substitute the lost and found offices all over the world and save the users from worrying about losing their property. Read more to learn how our team turned this idea into reality.

HIPAA (Health Insurance Portability and Accountability Act) is one of the most important United States federal statutes which has a great impact on the development of medical software. This act stands for the safety of the protected health information (PHI) and defines security standards that each digitized medical business should follow. HIPAA sets numerous requirements for data security management. Enabling these rules is not easy and sometimes creates much complexity during the development process. Our client, a medical business developing […]

Speed is everything in the highly competitive domain of e-commerce. Digital marketplaces of varied sizes appear at an ever-increasing rate and it becomes more challenging to stand out among the competition. According to estimates, a 6-months delay in a software product release can cut its profitability by at least 30%. These numbers had been relevant 30 years ago, and they have become even more relevant in the modern time or rapid digitization. That’s why entrepreneurs with a promising digital marketplace […]

It’s no secret that a modern world runs on data. This essential asset is stored in databases or data stores. And keeping such databases or data stores healthy is vital in the digital era we live in. It is also no secret that database issues can take down entire systems and cost businesses many thousands of dollars per hour. The ABCloudz team has years of experience supporting customer databases and delivering database services. A couple of our customers recently requested […]

One of the largest educational organizations in the United States had been running their data handling system in the Oracle environment. They wanted to reduce maintenance costs due to the expensive Oracle licensing model, which includes an additional fee for the partitioning feature. The ABCloudz team provided a solution for migrating the customer’s database to SQL Server. Reconstruction of the original partitioning system in SQL Server allowed us to significantly lower SQL Server maintenance costs compared to Oracle. Check out […]

One of our clients, a large financial software company, wanted to migrate their billing solution from Oracle to SQL Server. They needed to initiate this project because the migration was required by one of their strategic partners. The customer decided to implement SQL Server Integration Services (SSIS) for this migration. Additionally, they needed to do the data transfer from Oracle to SQL Server. Because of the complexity of the project, the client sought software developers that would build an automated […]