If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Trying to reverse engineer (recover) data from a .dat/.idx file set

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-01-12, 20:34
willlsteele willlsteele is offline
Registered User
 
Join Date: Feb 2012
Posts: 1
Trying to reverse engineer (recover) data from a .dat/.idx file set

I am not positive these are Informix files, but, am fairly confident they are. They came off a third-party accounting/inventory tracking system's server (Fedora Core). Unforunately, I cannot find out the name of the application.

I have two data collections. Each collection has exactly 1 .dat file and several .idx files. I presume the .idx files are just indexes for the .dat. Using Textpad and a hex editor I am able to identify several different sections of data in the .dat file. The first section contains what appear to be field headers. In examining the binary I have found clear patterns indicating header fields, but, cannot clearly denote datatypes from the binary yet. (Maybe some more analysis will help me sort it out). The actual records consist of rather long strings (3500 characters) where each separated by a set of null characters. I was able to parse the .dat file, extract the raw data, and, begin attempting to line up the headers with the fields. This works fine for some of them, but, for others I cannot get a 100% match based on obvious cues.

I know this is a long shot, but, does anyone have experience reversing from the .dat file to match records, rows and headers?
Reply With Quote
  #2 (permalink)  
Old 02-02-12, 03:18
begooden-it begooden-it is offline
Registered User
 
Join Date: Sep 2011
Location: Pont l'Abbé, Brittany, France
Posts: 183
Hi,

if these files are contained in a directory called xxx.dbs, these are either
Informix pre-SE tables, either Informix SE tables.

if these files are not contained in a xxx.dbs directory, chances are that they are Informix C-Isam files.

I can take a look on one of these files to check this. If they are, tools exist to extract data and produce a schema

I have those tools :-)

Regards,
Eric
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On