Integration: SQL

Automated File Transfer Plus Batch

Maritz designs and operates employee recognition and reward programs, sales channel incentive programs, and customer loyalty programs. To execute thousands of daily file transfers and the batch processes necessary upon receipt required an application stack that spread across 3 separate applications. JAMS consolidated all scheduling and automation – both Windows and Linux jobs – into one console, saving the company hours of overhead.

JAMS runs more than 800 jobs with excellent reliability. Maritz leverages JAMS central monitor to view its entire schedule of jobs and keeps business users informed of the status of critical jobs with JAMS alerts and notifications.

Automated Order Processing

TGW (The Golf Warehouse) needed an efficient method to move orders from its ERP system to its warehouse system. This process uses an EDI to gather related data from the ERP database and transfer it (via SFTP) to cloud-based tools for a comprehensive customer experience.

TGW uses JAMS to combine PowerShell, SQL*Plus, and Ecometry jobs into unified business processes. Their ability to build workflows in a single console has greatly reduced the manual hours needed to connect jobs on different platforms.

End-to-End Business Processing

A U.S. government agency’s infrastructure group was inundated with many menial tasks, and needed its complex processes to have “reliability of programming”. With JAMS orchestrating each task, the agency has brought uniformity to the time and conditions under which processes execute.

Automating Fuel Oil Delivery Logistics

An Australian utility manages its entire load and order process for fuel oil across 23 terminals. More than 25,000 file transfers, JDE jobs, bank transfers, and ESB triggers come together daily to support critical business processes.

Insurance Suite Batch Processing

Jewelers Mutual provides comprehensive repair and replacement insurance policies for jewelry. The company runs a series of critical jobs against its insurance suite and orchestrates data loads into its analytics platform and data warehouse every night.

Batch Credit Card Processing

A hospitality company had been using SQL Agent and Windows Task Scheduler to move loyalty points between their database and partner networks. The system was difficult to maintain and didn’t provide visibility into the current status of jobs, since the jobs were stored in different systems.

Automated Billing & Payroll

Amedisys’s billing, payroll, and accounting processes required several sequences of jobs to regularly generate invoices, export electronic claims, and export information to journal entries. The jobs were managed by a custom-built scheduler that lacked advanced functionality, and that still required manual processes to complete every step.

Automated Distribution of Market Data

Securities America collects daily market data from a variety of sources, processes it in several databases, then distributes customized reports to its customers. Behind the scenes, more than 10,000 jobs are run to transfer files securely, encrypt/decrypt files, and generate reports. The IT team had to manage an abundance of servers to run individual tasks, which created mounting overhead as the business grew.

Accounting Data Conversion

Camden Asset Management needed to continuously convert accounting and trading data, pull in financial data from various sources, and distribute P&L reports to its internal and external customers. They used a mix of SQL Agent, Windows Task Scheduler, and open source scheduler SOS to run the thousands of jobs necessary for these business processes, but “simple timed schedulers” made error handling nearly impossible.