Repository Tables

Repository Tables List

Below is a list of tables used by etl-tools.com products

Table Name	Usage	Visual Importer ETL	Advanced ETL Processor	Active Table Editor	Database Browser
TEMPLATES	Library of objects	X	X
ID_GENERATOR	PK Generators	X	X	X	X
CONNECTIONS	Connection details	X	X	X	X
OBJECT_TYPES	Object Types Lookup	X	X	X	X
OBJECTS	Holds objects data: SQL, Forms, Transformations Mappings, Packages and Reports	X	X	X
OBJECTS_HISTORY	Version Control	X	X
OBJECTS_TREE	Objects Tree	X	X
QUEUE	List of objects being executed right now or waiting to be executed, once execution is completed records are moved into QUEUE_HISTORY table	X	X
QUEUE_ACTIONS	Current execution details, once execution is completed records are moved into QUEUE_ACTIONS_HISTORY table	X	X
QUEUE_HISTORY	Object Execution History	X	X
QUEUE_ACTIONS_HISTORY	Object Actions Execution History	X	X
SCHEDULE	Execution schedule	X	X
USERS	List of users			X
GROUPS	List of groups			X
ACCESS_RIGHTS	Access Rights			X
GROUP_MEMBERS	List of groups members			X
NODES	Holds computer metadata	X	X
NODE_STATUS	Holds information about software installed	X	X
APPLICATION_SETTINGS	Application settings	X	X
SQL_EXECUTION_HISTORY	History of SQL execution	X	X	X	X
MENUS	User menus			X