Vantage sits in the middle of your data ecosystem.
Your organization runs on more than one system. Banks send check files. Smart meters push readings. Benefits vendors need payroll exports. Emergency-notification platforms pull customer data. AI agents query for reports. Vantage was designed for that reality, with four integration types covering everything from one-click file uploads to real-time REST API access.
Four ways to connect, from one-click to real-time.
Each type has a place. The right choice depends on what you're connecting, how often the data needs to move, and how much control you want over the process.
Import Interfaces
Pre-built file parsers for bringing third-party data into Vantage. Select the format, upload the file, and the records are created.
Best for vendor file uploads · bank reconciliation · meter readings
Scheduled Jobs & SFTP
Automated programs that run on a schedule (nightly, weekly, on-demand). Export from Vantage or import from a third-party SFTP server, unattended.
Best for recurring data exchange · nightly sync · multi-module exports
Custom functionality
Customer-specific workflows that feel native to ADG instead of bolted on after the fact. Replace or extend any menu item to fit how your organization operates.
Best for state-specific rules · customer-specific logic · unique workflows
REST API
Real-time programmatic access to Vantage data over standard HTTP/JSON. API-key authentication, table-level permissions, async query support for large result sets.
Best for real-time access · BI / AI tools · vendor synchronization
Pre-built parsers for the files you already receive.
If you're getting a file from a bank, a P-card vendor, a meter system, or an HR platform, odds are good Vantage already has a parser for it. Select the format from a dropdown, upload the file, and the records are created automatically.
What we already parse
- AP invoice importsBank of America, SunTrust/Truist, Commerce Bank, UMB, Elan Financial. Purchase-card detail with GL coding and merchant matching.
- Meter reading uploads (20+ formats)Badger, ITRON, Sensus, Mueller, ACLARA, MasterMeter, Evergreen, Vision AMI, Schlumberger, Radix, and more.
- Check reconciliation (30+ banks)Wells Fargo, Chase, Regions, TD Bank, Truist, BB&T, Bank of America, and more. Every bank's flavor of clearing file handled.
- Positive Pay exports (30+ banks)Send issued-check data to your bank for fraud prevention. Header/detail/trailer structures handled per bank.
- Journal entry imports (14+ formats)BMO purchase cards, CourtView, RecTrak, SmartGov, generic CSV/flat formats. Auto-creates offsetting cash entries.
- Employee, A/R, and timecard importsClear Company HR, Telestaff time tracking, third-party billing systems.
- 1Vendor generates a file in their standard format (CSV, flat file, tab-delimited)
- 2You upload it through Vantage and pick the format from a dropdown
- 3Vantage parses and validates against the format spec
- 4Review and post, with a full audit trail of what was imported and when
If your vendor isn't in the list, we build the new format and add it. The catalog grows with every customer onboarding.
Automated data exchange that runs while you sleep.
For integrations that need to happen on a recurring basis (nightly, weekly, on-demand) without anyone pressing a button. Vantage runs the export, packages the data, transfers via SFTP, and notifies on success or failure.
Conduits collections
Three nightly jobs export outstanding receivables across utility billing, building permits, and code enforcement to Conduits, a third-party collections platform. Property-keyed data lets Conduits pursue collections without stale-balance errors.
3 modules · nightly SFTP · parcel-keyed
Everbridge emergency alerts
Export of customer and employee contact data to Everbridge for emergency mass notification: boil-water notices, hurricane alerts, main breaks. Location-typed so the right people get the right alerts via phone, SMS, and email.
Multi-channel · contact + location data · employee + customer
Smart meter networks
Sensus Analytics and Itron Temetra lead the list, with proven integrations for Tantalus daily reads, Siemens smart meter data exchange, Neptune, AquaHawk, and more. Keeps Vantage billing data in sync with AMI infrastructure on a scheduled cadence.
Sensus Analytics · Itron Temetra · Tantalus · Siemens · Neptune · AquaHawk
Citizen-engagement platforms
WaterSmart (five separate feeds: accounts, billings, balances, usages, payments) and MyUsage (accounts, billing, payment imports). Drives the residents' app experience straight from your billing data.
WaterSmart · MyUsage · multiple feeds per platform
HR & benefits vendors
BenExpress employee export (160+ fields), Kronos time & attendance, Cigna/Humana/Chard Snyder insurance exports, HealthAdvocate. Keeps benefits administrators current without staff re-keying.
BenExpress · Kronos · Cigna · Humana
Budget & financial systems
Custom GL exports feeding budget systems like Questica. AP vendor exports, property appraiser feeds, lien-processing and bad-debt syncs. 100+ scheduled programs across modules.
Questica · Custom GL feeds · lien processing
How it works under the hood
A task scheduler triggers an export program. The program queries the Vantage database, builds a CSV, and transfers it via SFTP. Centralized credential management (kept server-side, never in the file), built-in logging with subscriber notifications, and job-control coordination to prevent overlap. Adding a new export follows an established pattern: credentials in config, a scheduled task, and a new export program. Each integration reuses the same proven infrastructure.
Functionality that feels native to ADG, not bolted on after the fact.
A built-in mechanism to replace any Vantage menu item with a customer-specific version. The user clicks the same menu item they always have, and Vantage loads the version configured for your organization. Same look, same training, behavior tailored to you.
Two patterns
Replace the entire program. Different page, different parameters, different processing. Example: the standard utility data import handles pump-station files. One organization uses it for trash billing instead. Another uses the same menu item for storm-water import and export with custom download options. Same menu item, completely different functionality per customer.
Keep the same page and parameter screen, swap just the background processing. Same UI, completely different outcome. Example: the standard meter export looks identical, but one customer's version exports metered service data while another's imports phone numbers.
- The user clicks the same menu item they always have. Training, screenshots, and process documentation stay valid.
- Replacements are activated per organization in configuration. You can target globally, by org, or by user role.
- The core program stays intact. Standard upgrades still reach you when there isn't an override on a given menu item.
- You can replace exactly as much as needed: the whole page, or just the engine that runs behind it.
Real development cost, used judiciously when no other type fits. The smoothest user experience of all integration types.
Real-time programmatic access to your Vantage data.
If scheduled exports are the plumbing, the REST API is the faucet. Turn it on and get exactly the data you need, when you need it. Standards-based HTTP/JSON, API-key authentication, table-level permissions configurable per integration.
What you can do with it
- Synchronize vendor or customer listsA third-party asset-management system like Llumin keeps its purchase-request vendors current by pulling from Vantage in real time. New vendors are visible the moment they're added, with no nightly file in the loop.
- Feed BI & reporting toolsPower BI, Tableau, or any modern dashboard pulls from Vantage directly, so the view always reflects current data.
- Power AI agents and chatbotsNatural-language queries against ADG data (for example, "show me overdue UB accounts in zone 3") backed by the same API any other system uses.
- Drive citizen portals or staff toolsBuild a custom intranet view, a kiosk, or a mobile field app on top of the data you already manage in Vantage.
Security model
API keys are issued and configured in Vantage System Manager. Each key has explicit table-level permissions, so you decide what's exposed to which integration. Sessions expire and re-authenticate. The async query pattern protects against timeouts on large result sets. Same auditing as any other Vantage data access.
Which type fits your situation?
You don't need to know the technical details up front. Tell us what system you want to connect, what data needs to flow, and in which direction. We'll recommend the right approach.
Already receiving files from a vendor?
Ask us whether an import format exists. There are 100+ built and the odds are good your vendor is in the list.
Need automated data exchange with a third party?
A scheduled SFTP job is likely the answer. We have 100+ in production across modules and add new ones from a proven pattern.
Have a state or business requirement we don't handle?
Talk to us about custom functionality. Used judiciously when nothing else fits, and when it fits the user experience is seamless.
Building something new like a portal, BI, or AI?
The REST API is where you'll start. Standards-based HTTP/JSON, configurable security, async support. Same API any modern system would expect.
Tell us what you're connecting.
Bring your list of banks, meter networks, HR vendors, citizen portals, BI tools, and AI agents. We'll map each one to the right Vantage integration type. Usually we can answer "yes, we already do that" in the first call.