Integration
No single piece of software can do everything — and we wouldn't expect it to. While ABW is a complete and integrated system in its own right, we understand that customers often have preferences or existing requirements in specific functional areas, whether that's accounting, inventory management, or beyond. What matters is the ability and willingness to work seamlessly with the systems your business already relies on. That's why ABW has built dedicated interfaces to export transactions to — and import from — other systems, ensuring your operations stay connected and your data stays consistent. At ABW, integration isn't an afterthought; it's a core part of how we serve our customers.
At the heart of every business is data, and the most universally used tool for working with it is Microsoft Excel. That's why our Data Export function creates native Excel spreadsheets quickly and effortlessly, putting your data where you need it most.
_Sm.jpg "shutterstock_2242292891 (1)_Sm")
Our integration experience runs deep. Over the years we have built interfaces with Electronic Data Interchange (EDI), ISO 9001 repositories, paging terminals, robotic devices, and a wide variety of other systems. Whether the solution calls for industry-standard REST APIs, SQL tables, or proprietary interfaces, we have the expertise to make it work.
Have an integration need your current software can't address? We'd love to talk to you!
"It was my pleasure to work with the team at Info-Power/ABW. We have worked on a few projects, all related to MSSQL migration and data integrations, along with some custom MSSRS reports. Working with their team was an easy process; they were knowledgeable and great to work with, and allowed me to provide the solutions my customers needed. I wouldn’t hesitate to utilize their services again in the future."
Data Export to Excel
Take control of your data without waiting on a programmer. The moment your SQL query is finalized, you can pull your data directly into Excel — instantly and effortlessly. From there, the full power of Excel is at your fingertips: build dynamic Pivot Tables for flexible subtotaling, or create compelling bar graphs and pie charts that turn raw data into clear, actionable insights.
Our Data Export feature includes:
- Simple query generates a native Excel spreadsheet
- User-defined and fully modifiable queries
- Guided Query Builder to walk you through the definition process
- User-level security to control data access
- Simple input parameter screens for ease of use
- Powerful SQL-based data retrieval
- Quick turnaround for ad hoc reporting
- SQL functions including Sum, Count, Average, Min, and Max
- Output from complex stored procedures supported
- Usage records retained by user and query, including parameter inputs
- Data exported in native Excel format, compatible with all Excel functions
EDI-SPS Commerce
ABW has extensive experience with SPS Commerce for high-volume EDI transactions, providing specialized support tailored to both your requirements and those of your trading partners. Our platform consumes and generates the most commonly used X12 transactions, and if your business has additional or unique requirements, we are ready and happy to work with you to address them.
Our supported X12 transactions include:
- 810 — Invoices
- 850 — Orders
- 855 — Acknowledgments
- 856 — Ship Notifications
IMSXpress - ISO 9001
IMSXpress is a Microsoft SQL Server-based ISO 9001 repository with which ABW closely integrates. Its use of MSSQL allows us to link its tables directly to ABW screens and views, joining them with your data to deliver a seamless, combined experience for your users. Think of it as a natural extension of your Document Management system — bringing your quality documentation and operational data together in one connected environment.
Our IMSXpress integration supports:
- Master Drawings
- Change Control Notices
- Procedural Instructions
- Automated Revision Level Tracking
- Purchase Order Version History
- Work Order Release Version
- Lot Tracking History
ABW comes with the capability to attach to the following business records and can easily be expanded.
- Inventory Items
- Bill of Materials
- Shop Floor Routings
- Quotes
- Sales Orders
- Shippers
- Shippers
- Invoices
- Work Orders
- Inventory Lots
- Purchase Orders
- Vendor Invoices
Document Management
ABW enables the attachment of all types of documents to specific business records. Virtually any type of document that has a browser-based display mechanism can be used. Commonly used documents are:
- Text Files
- Microsoft Word
- JPG
- PNG
- AutoCAD
- Solidworks