More from our Blog

As a higher-education institution prepared to move Banner to Ellucian SaaS, it had to determine how to preserve a custom eligibility process that depended heavily on the on-premises Banner database. The process identified which students qualified for a term-based benefit and recorded that eligibility as a student attribute, a Banner record value used here as […]

A higher-education institution relied on a custom Banner process to import student immunization compliance data from Point and Click Solutions and manage registration holds. As Banner moved to SaaS, that workflow could no longer depend on its existing Banner Job Submission (JobSub) process, PL/SQL, Oracle’s procedural extension to SQL, direct database access and the Banner […]

A higher-education institution relied on a custom billing process in Ellucian Banner, its higher-education enterprise and student information platform, to calculate student balances, generate statements and distribute them through TouchNet for electronic billing and DATAMATX for paper billing. The customization existed because the delivered Banner integration with TouchNet did not provide the required prior and […]

A higher-education institution was modernizing a custom third-party sponsor billing process for Banner SaaS and Ellucian Data Connect, Ellucian’s integration platform for building and managing data process flows. One requirement extended beyond the billing calculations themselves: the new pipeline still had to produce the sponsor invoice PDFs required by the business process. Those invoices had […]

A higher-education institution relied on a custom third-party sponsor billing process in Ellucian Banner to calculate charges covered by external sponsors and prepare billing output for its TouchNet third-party billing workflow. Moving this capability to Ellucian SaaS required rebuilding the Banner-side billing engine around Ellucian Data Connect, Ellucian’s integration platform for creating and managing data […]

When an Ellucian Spec API written for Oracle calls scalar functions directly from its SELECT list, migrating the query to PostgreSQL can break because those Oracle functions are not available in the PostgreSQL implementation. The SQL still needs to calculate the same value for each Banner record, so the function logic has to be reproduced […]

When an Ellucian Spec API SQL query needs parameter values or criteria based filtering, choosing between ::param:: and %%AND_FILTER%% determines what kind of SQL substitution is required. ::param:: supplies a value at a predefined position in the SQL, while %%AND_FILTER%% represents an optional SQL condition generated from the request criteria. Using the wrong mechanism can […]

When an Ellucian Data Connect forEach is followed by a reducer, a JavaScript step that reads message.payload as if it still had the per iteration shape can get undefined or the wrong object instead of the expected array of results. The reducer stores iteration payloads under the configured accumulator path, so the next step must […]

When an Ellucian Data Connect implementation moves Banner PL/SQL processing into JavaScript, Oracle cursor logic that selects the latest non-terminated effective-dated job record before a cutoff date has to preserve the same record-selection rules. In the workflow covered here, JavaScript filter() reproduces the Oracle eligibility conditions, while reduce() selects the qualifying record with the greatest […]

When an Ellucian Data Connect pipeline processes a candidate through multiple steps and sub-pipelines, each stage may need to add an audit message without overwriting messages created earlier. In the workflow covered here, storing the audit trail as a plain auditMessage string separated with ” | “ lets the pipeline preserve the message sequence, carry […]

An Ellucian Data Connect pipeline can work normally with a small test dataset and then fail in production when JSON.stringify() processes a much larger accumulated payload. In this production case, processing about 20 records worked as expected, while a production run with 500+ employees could stop with a cryptic V8 engine error and no useful […]

When an Ellucian Data Connect integration needs to create a new Banner employee job-detail record through the Ethos employee-job-details/batches endpoint, the request still requires an id even though the new record does not yet have a real GUID. This creates a practical implementation question: what value should the batch payload send when the operation is […]

A U.S.-based enterprise technology organization needed a faster and more consistent way to understand heavily customized legacy ERP environments and plan complex modernization work. ABCloudz developed an AI-assisted engineering solution on AWS that combines deterministic system discovery, dependency analysis, retrieval-augmented generation, and custom multi-step agent workflows. Amazon Bedrock provides managed foundation-model inference, while Amazon ECS […]

I was given a C++ application that ran on an older generation of payment terminals, documentation for the old platform, documentation for the new one, and a simple objective: Build the application for the new terminals, and use AI to help. That was essentially the entire handoff. There was no business analyst to walk me […]

By Illia Sokolov, Senior Technology Fellow at ABCloudz Most days, our AI spend for development stayed below $100. Then one day hit $490. No big production launch. No planned load test. No obvious reason in the data. It was clear, visible, and hard to ignore. The problem was that the chart could only tell us […]