Learn more about
ETL
Ellucian SaaS, automation, Banner, Ellucian Student, Banner SaaS, Data Connect, data-integration, Ellucian, ETL, higher-education, modernization roadmap, SaaS
Automating student refunds with Ellucian integration
At ABCloudz, we partner with Ellucian to deliver streamlined, reliable integrations for universities across Europe and beyond. In a recent project, Ellucian engaged us to help an established European university with a long tradition in law education automate their complex, manual refund process. In this post, we’ll show how we replaced labor-intensive, error-prone workflows with […]
Oleksii Svitlychnyi
Banner SaaS, Data Connect, Ellucian SaaS, Ellucian Student, automation, Banner, data-integration, Ellucian, ETL, higher-education, modernization roadmap, SaaS, Amazon S3 Storage
Ellucian Colleague and T2 Systems integration
At ABCloudz, we partner with Ellucian to provide robust technical solutions to colleges and universities across the United States. Our recent collaboration involved a U.S. college utilizing Ellucian Colleague for student information management and T2 Systems for parking management. This client struggled with manual, cumbersome processes for exchanging critical student and employee data between these […]
Oleksii Svitlychnyi
Banner SaaS, Data Connect, Ellucian SaaS, Ellucian Student, automation, data-integration, Banner, Ellucian, ETL, higher-education, modernization roadmap, SaaS, Amazon S3 Storage
Ellucian Colleague and Maxient integration
This blog post shares how ABCloudz partnered with Ellucian to deliver an automated student data integration between Ellucian Colleague and Maxient, a leading student conduct and case management platform. We designed a robust, reusable integration pipeline using Ellucian Data Connect, helping a major U.S. college eliminate manual data processes, reduce administrative overhead, and significantly improve […]
Oleksii Svitlychnyi
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