knowledgebase:repository_tables

Repository Tables

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
TEMPLATESLibrary of objects
ID_GENERATORPK Generators
CONNECTIONSConnection details
OBJECT_TYPESObject Types Lookup
OBJECTSHolds objects data: SQL, Forms, Transformations Mappings, Packages and Reports
OBJECTS_HISTORYVersion Control
OBJECTS_TREEObjects Tree
QUEUEList of objects being executed right now or waiting to be executed, once execution is completed records are moved into QUEUE_HISTORY table
QUEUE_ACTIONSCurrent execution details, once execution is completed records are moved into QUEUE_ACTIONS_HISTORY table
QUEUE_HISTORYObject Execution History
QUEUE_ACTIONS_HISTORYObject Actions Execution History
SCHEDULEExecution schedule
USERSList of users
GROUPSList of groups
ACCESS_RIGHTSAccess Rights
GROUP_MEMBERSList of groups members
NODESHolds computer metadata
NODE_STATUSHolds information about software installed
APPLICATION_SETTINGSApplication settings
SQL_EXECUTION_HISTORYHistory of SQL execution
MENUSUser menus

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/repository_tables.txt
  • Last modified: 13/04/2019 16:50
  • by admin