Eurotrace Hands-On

The Eurotrace File System

2

The Eurotrace file system Under MS ACCESSEUROTRACE generates several different files when you create a domain The EUROTRACE files will be stored in the directories that you specify when you create the EUROTRACE Domain and related Datasets.

Some files can only be opened by the EUROTRACE application others can be opened outside EUROTRACE by using Microsoft Access.

Files that can only be opened by EUROTRACE: .dom

All the definitions and structures of the EUROTRACE Domain including:

- Links between the dictionaries and datasets.

3

The Eurotrace file system

Files that can be opened by the MS Access DB engine:

– .plc This file contains the nomenclatures and the Scope definitions.

– .dta This file is where the actual data are stored as well as the:

– Error table This stores any error records that occur when you import data to your EUROTRACE Dataset.

– History table Stores relocated and updated records when you import data.– Flow table This file store the flow of the records per fields and operation– Operations table This is a log table that keeps track of all operations performed

within a dataset, including user name, time and date, …– .bak Backup files are created automatically when you delete a Dataset or change the

structure, and will be stored with the ‘.bak’ extension.

Files that can be opened by any text Editor:– .bki This file contains schema for text file importation. – ESEXPParameters.txt This file contains schema for text file exportation with add in

EstatExport. – Rangeparameters.txt This file contains schema for running the add in “Range”

4

The Eurotrace file system Under ORACLE

For Oracle DB, users will have to specify the Driver to use as well as the name of the database (where the dedicated table space is available)

The Test button enables you to check if parameters enable you to connect properly to the database.

5

The Eurotrace file system Under ORACLEOracle storage parameters

Parameters

6

The Eurotrace file system Under ORACLEOracle storage parameters

indexes alternate table space

Index Start size:

Index Extend size

Generate log file

7

The Eurotrace file system Under SQL Server

specify the Driver to use

8

The Eurotrace file system Under SQL Server

user ID and the password