BMC Attachments without ARS Server

You have probably experienced what’s happening in the whole world now and it’s better to stay at home. But what can we do at home? Yes, learn. In recent days I was asked to retrieve files from a database where BMC ARSystem Remedy is running, I said to myself a “How hard can it be?”, we already have an app using ARAPIlibraries, so yes, no problem!

Customers thought that their configuration could be a showstopper because of MSSQL 2000 and Remedy 7, but no way! This 20 years old grandpa system doesn’t support ARAPI, but we still have the SQL where data are stored. For sure, attachments are stored in binary so How hard can it be?

After a google search for “How to decrypt BMC files in DB for beginners” with no relevant results this got my attention, so I’ve decided to develop my own solution.


What is the case?

  1. SQL DB as a data source

  2. Files are encrypted by BMC

  3. Export files and save to disk or load into another DWH

  4. Unknown size and count of stored attachments

Simple schema of Export process from BMC's DB
Export schema for BMC ARS Remedy

What do we need?

  1. JDK8

  2. ARAPI71.jar or newer – this depends on the version, but BMC’s algorithm was not changed so much since 2003

  3. JDBC driver for SQL Server

  4. DB Server with stored DB

  5. Knowledge of schema like field id. schema id etc.

What is the plan?

  1. Connect and extract Files via JDBC from MSSQL

  2. Decrypt each file via the ARDecompressor method.

  3. Save files to the folder

Do you need this app? Contact us. 🙂