More from our Blog

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

Data infrastructure is what powers the proper performance of your software. However, unexpected issues can occur making your system unavailable. That’s where the notion of a downtime, a time period when the system is not available, comes in. Downtime may have different causes and outcomes. But one thing is certain, downtime can be extremely expensive. […]

A modern medical company was running a large healthcare platform connecting patients with medical imaging providers. They had databases for the admin app, patient app, physician app, and the original service portal. All these databases were running on AWS cloud servers deployed and managed by Datica. The latter helped the customer scale and manage their […]

Feng Shui is the practice of arranging pieces in living spaces to create balance with the natural world. VMWare vSphere virtualization has grown since its introduction in 1998, to being the top virtualization technology in use by companies today, holding 23% of the market. Microsoft’s SQL Server product, first released in 1988, has increased its […]

We continue our series of blog posts dedicated to a large pharmaceutical company that required a broad range of infrastructure monitoring services. In this chapter, we will focus on the application that helps their sales team comply with the company rules. The customer created an iOS and Android app that stored compliance policies for regular […]

In recent years, healthcare technology development has gained momentum. Would you like to know one of its most promising directions? Then, let’s consider IoT healthcare solutions. Between 2019 and 2027, global IoT technology market is expected to grow at a compound annual growth rate of 24.9%. This technology can be used for building a great […]

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

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

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

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

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

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

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

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

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