ECI Macola + private AI
AI for ECI Macola, from Progression Series to Macola 10
Short answer
Macola shops split between the legacy Progression Series on Progress OpenEdge and the newer SQL Server-based Macola 10 / Macola ES, and both leave day-to-day questions, backorders, on-hand, open POs, answered by whoever knows the Order Entry and Inventory Management screens or can run Visual Integrator. A private AI layer grounded on either database answers those questions directly, triages VI job failures, and helps with the data-quality work that any eventual migration off Progression Series will require.
- ERP
- ECI Macola, Macola Progression Series, Macola 10, Macola ES
- Industries
- Distribution, Manufacturing, Durable Goods
- Written for
- IT Director
Macola has been through more database and branding changes than most ERPs still in production use: Progression Series running on the Progress OpenEdge database, and the newer Macola 10 (built on Macola ES) running on SQL Server. A lot of distributors and manufacturers are still on Progression Series, often on a version no longer actively enhanced, which creates real anxiety about where to invest next without committing to a full re-implementation.
Day to day, the friction is familiar to anyone who has run Macola for a while: a customer service rep needs to know what is on backorder, a controller wants to know what purchase orders are overdue, and the honest way to get that answer is to open the Order Entry or Inventory Management screens, or run a Crystal Report someone built years ago. There is rarely a quick, self-service way to just ask.
Visual Integrator, Macola's native import/export tool, is the backbone of most integrations and data movement, and it is usually maintained by one long-tenured person who understands both the VI job definitions and the underlying schema. When a VI job fails silently, tracking down why can eat an afternoon, and it is a real key-person risk if that person is unavailable.
None of this requires jumping straight to Macola 10 or a different ERP. A private model grounded on your existing database, whether that means an OpenEdge connection for Progression Series or SQL Server for Macola 10, can answer operational questions in plain language today, and the same connector work pays off directly when it is time to plan a Progression Series to Macola 10 migration.
What usually gets in the way
The problems we hear most from it director teams running ECI Macola.
Progress OpenEdge is invisible to most modern BI and AI tooling
Progression Series customers run on a database most reporting and AI tools don't speak natively, so answers depend on canned Crystal Reports or manual Visual Integrator exports.
Basic order and inventory questions require screen knowledge
Backorder status, on-hand quantity, and open PO questions need someone who knows the Order Entry and Inventory Management screen sequence, not a quick natural-language answer.
Legacy Progression Series shops face real migration anxiety
Many installs are on a version no longer actively enhanced, and moving to Macola 10 is a real project, which leaves IT unsure where to invest in the meantime.
Multi-warehouse or multi-entity rollups are manual
Distributors running more than one warehouse or entity get consolidated views by hand, since Visual Integrator jobs are built for data movement, not cross-entity reporting.
Visual Integrator and report knowledge is a key-person risk
VI scripts and Crystal Report layouts are usually maintained by one long-tenured employee. When something breaks and that person is out, everyone waits.
Where AI earns its place in ECI Macola
Each use case names the ERP objects it reads or writes, so your ERP team can judge the integration effort before anyone commits budget.
Natural-language order and inventory queries
Customer service and operations staff ask directly for backorder status, on-hand quantity, or open PO age, against either Progression Series or Macola 10 data.
Touches: Order Entry (OE) and Inventory Management (IM) records, purchase order data
Outcome: Answers in seconds instead of navigating Macola screens or waiting on a report
Visual Integrator job failure triage
Explains why a VI job failed or produced unexpected results by reviewing the job log and comparing source and target record counts.
Touches: Visual Integrator job definitions and logs, source/target table data
Outcome: Faster diagnosis of VI failures without depending on the one person who wrote the original job
Customer credit-hold and order-exception assistant
Flags orders stuck on credit hold or exception status and explains why, pulling the relevant credit and order history together.
Touches: Accounts receivable and credit records, sales order status
Outcome: Faster resolution of held orders that would otherwise sit until someone manually investigates
Job costing and manufacturing variance explainer
For Macola manufacturing module customers, explains variances between actual and standard cost by job or work order.
Touches: Bill of materials, routing, job costing actual vs. standard cost records
Outcome: Controllers get the driver behind a variance instead of just the total dollar difference
Legacy-to-Macola 10 migration data-quality copilot
Reviews Progression Series code tables and master data, flags orphaned records, duplicate customers/items, and inconsistent codes ahead of a Macola 10 migration.
Touches: Progress OpenEdge master data tables, customer/item/vendor code tables
Outcome: Cleaner migration source data and fewer surprises found mid-cutover
Vendor and PO expedite assistant
Identifies purchase orders at risk of late delivery against open sales demand and drafts the vendor follow-up.
Touches: Purchase order records, vendor confirmation data, sales order demand
Outcome: Purchasing catches at-risk POs earlier, reducing rush freight and stockouts
Month-end close checklist and GL summary
Summarizes the month-end close checklist status and flags open reconciling items across GL, AP, and AR.
Touches: General ledger, accounts payable, and accounts receivable records
Outcome: Controllers get a same-day view of what is still open instead of chasing status by email
Reference architecture
The model reads from either the Progress OpenEdge database (Progression Series) or SQL Server (Macola 10/ES), maps Macola's OE/IM/PO vocabulary into plain language, and answers through retrieval and text-to-SQL, with the connector explicitly aware of which database generation it is talking to.
- 1
ERP connectors
OpenEdge ODBC/JDBC access for Progression Series, or SQL Server access for Macola 10/ES, kept to a reporting-only credential.
- 2
Data and semantic layer
Maps OE, IM, PO, and job costing tables and code tables into business vocabulary, accounting for customization common in older installs.
- 3
Model serving
An open-weight model served privately on customer-controlled hardware or a single-tenant private cloud.
- 4
Retrieval and agents
Text-to-SQL over order/inventory/PO data, plus a VI job-log analysis tool for integration troubleshooting.
- 5
Governance and audit
Read-only by default, with query logging suited to an environment where one legacy system may be mid-migration to another.
Integration notes for your ERP team
- Progress OpenEdge requires its own ODBC/JDBC driver and connection approach, distinct from the SQL Server access used by Macola 10/ES; confirm which generation you are on before scoping.
- Visual Integrator is the native ETL tool in most Macola shops; reviewing existing VI job definitions is usually the fastest way to understand what data paths already exist before building new ones.
- Macola 10's newer API and data model differ meaningfully from legacy Progression Series screens and tables, so mapping work is not directly reusable across the two.
- Heavy per-customer customization is common in older Progression Series installs; budget discovery time for code tables and custom fields specific to your instance.
- Write-back should go through Visual Integrator import jobs or a supported API, not direct table writes, particularly on OpenEdge where schema assumptions are easy to get wrong.
- If a Macola 10 migration is on the roadmap, sequence the AI connector work to double as migration data-quality tooling rather than building it twice.
Deployment options
Air-gapped on-prem
Distributors and manufacturers already running Progression Series or Macola 10 on their own servers
Model and connector run alongside the existing database server or on a nearby machine inside the same network, no cloud dependency required.
Private cloud
Companies consolidating infrastructure or planning a Macola 10 cloud-adjacent hosting move
Data replicated into a single-tenant private cloud where the model runs, separate from any shared service.
Hybrid
Groups mid-migration from Progression Series to Macola 10 that need both systems queryable during transition
Connectors to both OpenEdge and SQL Server run in parallel until cutover is complete.
Compliance and data control
How the architecture supports your obligations. Certification and accountability stay with your organisation; the design keeps the evidence straightforward.
ITAR / EAR
Industrial distributors and manufacturers touching controlled parts keep order and inventory data inside a private or on-prem boundary rather than a shared AI service.
Customer data residency clauses
On-prem or private-cloud deployment satisfies data-location requirements some distribution customers include in supply agreements.
SOX-adjacent financial controls
For PE-owned or audited companies, read-only access and logged queries keep the AI inside existing change-control expectations for financial systems.
Data quality controls ahead of migration
The same governance used for day-to-day queries doubles as documentation of the data-cleansing work performed ahead of a Macola 10 migration.
Where Netray fits
ERPray
Macola is not a listed connector today; question-answering over order, inventory, and PO data is built on ERPray's ERP-agnostic connector architecture.
Custom build
The OpenEdge-versus-SQL-Server split and heavy per-shop customization typically call for purpose-built connectors rather than a one-size mapping.
DataRay
Useful where document-heavy AP or vendor correspondence needs to be combined with Macola's structured order and PO data.
How an engagement runs
Phase 1 . 2-3 weeks
Discovery
- -confirm Progression Series vs. Macola 10/ES and database access path
- -review existing Visual Integrator jobs
- -prioritized use-case list
- -migration roadmap alignment if applicable
Phase 2 . 6-8 weeks
Pilot
- -private model stood up
- -connector to OpenEdge or SQL Server
- -2-3 use cases live (order/inventory query, VI triage)
- -IT and operations feedback loop
Phase 3 . 4-6 weeks
Production
- -governance and logging hardened
- -credit-hold and PO expedite assistants rolled out
- -staff training
- -role mapping to Macola permissions
Phase 4 . ongoing
Scale
- -migration data-quality copilot if moving to Macola 10
- -job costing variance use case
- -month-end close summary agent
- -quarterly use-case review
Questions to ask any vendor, including us
A short list that separates real ECI Macola AI work from a chatbot demo.
- Do you have real, hands-on experience with Progress OpenEdge, or only SQL Server-based Macola?
- Does the AI ever write to our live database, or is it strictly read-only?
- Can this run fully on our own network with no outbound cloud dependency?
- How do you handle the difference in schema between Progression Series and Macola 10 if we migrate mid-project?
- Who audits what the AI queried and what answer it produced?
- Can the work double as data-quality preparation for a future Macola 10 migration?
- How do you plan to handle our specific customizations to the standard Macola schema?
Frequently asked questions
Can AI be added to Macola Progression Series, which runs on Progress OpenEdge?
Yes, though it requires an OpenEdge-specific database connection rather than the SQL Server access used by newer Macola 10 installs. Once connected, a private model can answer order, inventory, and PO questions directly from Progression Series data just as it would from Macola 10.
What is the fastest AI win for a Macola shop?
Natural-language order and inventory queries, such as backorder status or open PO age, are usually fastest to stand up because that data is already well structured in the OE and IM modules. Most shops see a working pilot within six to eight weeks.
Can AI help troubleshoot Visual Integrator job failures?
Yes. By reviewing the VI job log and comparing source and target data, a model can explain likely causes of a failed or partial run, reducing dependency on whichever single person originally wrote the job.
Does this help if we're planning to migrate from Progression Series to Macola 10?
It can. The same connector and mapping work used for day-to-day AI queries can be extended into a data-quality copilot that flags orphaned records, duplicates, and inconsistent codes ahead of a migration, reducing surprises during cutover.
Is this safe for a distributor with customer data residency requirements?
Yes, when deployed on-prem or in a private single-tenant cloud with no data sent to a shared external AI service. That satisfies data-location clauses that many distribution and manufacturing customer agreements already include.
Does ECI Macola have a native AI copilot already?
ECI has been modernizing parts of the Macola line, particularly around Macola 10, but a broad natural-language AI layer grounded on order, inventory, and job costing data is not a standard out-of-the-box feature as of this writing, especially for Progression Series customers.
What does it cost to add AI to a Macola environment?
For a single-database pilot (either Progression Series or Macola 10) covering two or three use cases, expect a cost comparable to a focused mid-size integration project. OpenEdge connectivity and heavy customization can add to discovery time and cost.
Related guides
Natural Language Query for ERP Data: Ask SAP, Infor, or Oracle a Question in Plain English
See how natural language query over SAP, Infor, Oracle, and NetSuite data works: grounded text-to-SQL, role-based permissions, and a visible audit trail.
RAG + SQL + permissionsA Private LLM Grounded on Your ERP Data
How a private LLM answers questions on your ERP data: RAG plus text-to-SQL, role-based permissions inherited from the ERP, and where each fits.
Agents + approval gatesAI Agents for ERP, Running On-Prem
A practical guide to on-prem AI agents for ERP: what they can safely automate, where human approval belongs, and how to design the guardrails.
ERP migration + on-prem AIAI-assisted data migration for ERP implementations
AI speeds ERP data migration by profiling legacy data, proposing field mappings, and flagging cleansing issues before cutover, with a human validating every rule.
ERP AI Cost GuideWhat ERP AI Actually Costs: A CFO's Guide
A CFO's guide to what ERP AI actually costs: GPU hardware, model licensing, integration and connector work, and realistic ongoing run-rate ranges.
QAD + on-prem AIAI for QAD Adaptive ERP in automotive and industrial manufacturing
Add AI to QAD Adaptive ERP or Enterprise Edition for automotive and industrial manufacturing, grounded on QXtend and QAD's API layer, on-prem or private cloud.
Plan it with numbers
ERP Data Quality for AI Assessment
Score item master, customer, vendor, and transaction data quality to find out whether your ERP is ready to ground an AI copilot, forecast, or chatbot.
Free ToolLegacy ERP AI Modernization Assessment
Score your legacy SyteLine, LN, or Baan environment to find out whether AI can modernize it in place or whether platform upgrade work needs to come first.
Free ToolERP Migration Risk Assessment
Answer 10 questions about your data, team, testing, and budget to get a migration risk score and a prioritized list of mitigations before your project starts.
GuideERP Data Migration Best Practices with AI
Master ERP data migration with AI. Automated data cleansing, validation, and mapping for Infor SyteLine, LN, M3, and Salesforce migrations.
GuideERP Legacy Modernization Assessment
Assess your legacy ERP for modernization readiness. Covers technical debt scoring, business case analysis, modernization paths, and migration risk evaluation frameworks.
GuideDistribution ERP Comparison: Top Platforms for Wholesalers
Compare distribution ERP platforms for wholesale and distribution. Infor M3, Epicor Prophet 21, SAP Business One, and NetSuite evaluated for distributors.
Talk it through with an engineer who knows ECI Macola
Bring one real question your team cannot answer from the ERP today. We will map the data path, the model, and where it runs, and tell you honestly if AI is the wrong tool for it.