Learn more about
ETL
automation, Banner, Banner SaaS, Data Connect, data-integration, Ellucian, Ellucian SaaS, Ellucian Student, ETL, higher-education, modernization roadmap, SaaS
Ellucian Banner and ProVerify integration
Many colleges leveraging Ellucian Banner SaaS manage financial aid verification through a combination of institutional processes and integrations with external platforms. Our client is a large public community college in the United States. Their staff relied on manual uploads, custom scripts, and fragmented workflows to connect Banner SaaS with ProVerify, a financial aid verification solution […]
Oleksii Svitlychnyi
Ellucian SaaS, Data Connect, Banner SaaS, Ellucian Student, Ellucian, Amazon S3 Storage, Amazon S3, automation, Banner, data-integration, ETL, higher-education, modernization roadmap, SaaS
Ellucian Banner and Remind integration
Many colleges using Ellucian Banner SaaS still rely on manual processes to communicate critical notifications to students. For a large public community college in the United States, manual uploads and semi-automated processes posed risks, including delays and human errors in crucial student notifications. In this blog post, we’ll share how the ABCloudz technical team implemented […]
Oleksii Svitlychnyi
Data Connect, Ellucian SaaS, Banner SaaS, Data-warehouse, higher-education, ETL, Amazon RDS, AWS Schema Conversion Tool, azure, Database conversion errors, database-conversion, database-migration, Ellucian, Improving the performance, Microsoft SQL Server, modernization roadmap, PostgreSQL, PowerShell, SaaS, SAS, test automation
Modernizing analytics pipelines with Data Connect
This post shares how ABCloudz and Ellucian helped one of the largest U.S. community college systems move from legacy SQL Server infrastructure to a cloud-native analytics platform on AWS, using Ellucian Data Connect to modernize data pipelines and integrations. We dealt with business-critical legacy procedures, manual PowerShell scripts, SQL Agent jobs, and a complete lack […]
Oleksandr Polyvanyi (Solution Architect), Oleksii Svitlychnyi (Technical Writer)
solution-design, database-migration, modernization roadmap, Ora2Pg, Oracle to PostgreSQL migration, oracle-workload-migration, PostgreSQL, aws-sct, PowerBI, ETL
Solution design for banking system migration
When it comes to complex database migrations, especially for mission-critical systems in the financial sector, cutting corners in the early stages can turn into an expensive gamble. Yet, we often encounter organizations that view the discovery and solution design phase as an optional step — one they can skip or downsize to save time or […]
Oleksii Svitlychnyi
database-migration, SaaS, Data-warehouse, data-lake, ETL, application-modernization, aws, Oracle to PostgreSQL migration, cloud-migration, PostgreSQL, Oracle, Improving the performance, AWS Batch, Amazon S3
Modernizing the Oracle ODS Data Warehouse for SaaS flexibility with PostgreSQL on AWS
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 […]
Oleksii Savchenko, Oleksii Svitlychnyi
operational-data-management, database monitoring, security, SQL Server, cost-optimization, SharePoint, ETL, health check, Azure SQL Database, azure
Operational Data Management for a Global Biotech Leader
Our client, a global biotech company with a presence in over 80 countries and a workforce of 4,000 employees, depends on a complex IT environment that includes both on-premises and cloud-based components. This infrastructure supports everything from research and development to manufacturing and corporate operations, with SQL Server playing a pivotal role across various environments. […]
Sergii Zymbytskyi, Oleksii Svitlychnyi
Databricks, azure, big-data, Data-warehouse, Data-platform, cloud-migration, Business-intelligence, SQL Server, Microsoft Azure, Azure-DevOps, Azure-Data-Factory, ETL, Oracle
EDW to Azure Databricks Migration
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 […]
Sergey Shtypuliak (DB Engineer), Oleksii Svitlychnyi (Technical writer)
Unleashing the power of data integration: a head-to-head comparison of AWS Glue vs. Azure Data Factory
Nowadays, it’s hard to imagine effective Business Intelligence without ETL (extract, transfer, and load) tools. These tools help you integrate data from multiple sources into a single database environment. Instead of keeping data in silos, you get an efficient and consistent data warehousing method where all data brings you value, regardless of its format and […]
Oleksandr Smolovyk, Mykhailo Ievsieiev
Expand capacity with an IBM DB2 SQL Azure SQL Database migration
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 […]
Andrii Koval