More from our Blog
Latest
posts
Building a complex IoT solution for healthcare: a process perspective, Part2
We continue our series of posts on the development of complex IoT solutions. According to MarketsAndMarkets, healthcare IoT market is on the rise and it is expected to reach USD 94.2 billion by 2026. Medical software development market presents plenty of opportunities. In the blog below, we will look at some challenges we’ve faced while […]
Use the power of PowerApps for fast data updates
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 […]
Building a complex IoT solution for healthcare: a process perspective, Part1
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 […]
License inventory for a large SQL Server database infrastructure
Here’s a new entry to our series of posts on how the ABCloudz team has helped a large pharmaceutical company manage its sophisticated data infrastructure. The customer’s business is rapidly growing, which leads to a significant expansion of their data infrastructure. This infrastructure has exceeded 140 SQL Servers united by complex connections and ETL scripts. […]
The flow and value of business analysis at ABCloudz
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 […]
Microsoft silver competency in two areas
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 […]
How to cover monitoring gaps for a large SQL Server data infrastructure
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 […]
Why Use Microservices Architecture?
A Practical Guide
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 […]
Why Use Monolithic Architecture?
A Practical Guide
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 […]
Showcase: Blockchain solution for Ethereum and smart contracts
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 […]
Best practices: Making 3D modeling and 3D printing available for anyone
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 […]
Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function
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 […]
Oracle to MySQL migration with AWS SCT: How to convert BULK COLLECT clause
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 […]
Oracle to MySQL migration with AWS SCT: How to handle unsupported NumToYmInterval function
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, […]
Oracle to MySQL migration with AWS SCT: How to convert variables of SYS_REFCURSOR datatype
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 […]
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!