How to extract data from proprietary software database systems using TCP/IP?

TL;DR

This paper discusses techniques for extracting raw data from proprietary database systems via TCP/IP by reverse engineering, enabling data conversion into structured formats like XML without official interfaces.

Contribution

It presents a method combining reverse engineering and programming skills to access and convert proprietary database data into structured formats using TCP/IP.

Findings

Demonstrates data extraction from Harmony CRM system

Shows conversion of raw data into XML format

Utilizes Python and security methods for quick access

Abstract

This document is an white paper about how to connect reverse engineering and programing skills to extract data from a proprietary implementation of a database system to build EML-Tools for data format conversion into raw data. This article shows how to access data of a source software system without any interface for data conversion. We discuss how raw data can be transfered into structural format by using XML or any other custom designed software solution. For demonstration purposes only, we will use a CRM system called Harmony(r) by Harmony(r) Software AG, the programing language Python and methods of computer security, which are used to get quick access to the raw data. All trademarks are property of their owners, as Harmony(r) is of Harmony Software AG.