New RELEASE OF ACTIVE TABLE EDITOR

The most important change is how settings are stored.  All of them used to be saved in the registry key HKEY_LOCAL_MACHINE and since Microsoft had tightened windows security it brought a lot of problems and error messages.  In order to make life everyone easier decision was made to move common settings into "ini files" and user-specific settings to HKEY_CURRENT_USER  registry key. The benefit of storing common settings in ini files that it is extremely easy to copy repository settings from one computer to another.  

Active Table Editor   5.3.4.0

Other changes are:

  • Added: Support for MongoDB
  • Fixed: User access issues
  • Fixed: Issues with checking the version
  • Fixed: Backup/Restore Issues
  • Improved: Third party components update
  • Improved: Various bug fixes and improvements

More information:

All settings are stored in C:\ProgramData\ETL-Tools.com folder, that makes moving software to a different computer much easier.

ATEOptions.ini holds designer user interface settings plus global variables values

Connections.ini holds a list of all available repository connections

Note: This list is shared among all applications

ATEConnection.ini this file holds repository connection name

Note: It might necessary to amend repository connection details after installation

Repository Upgrade Procedure

Notes:

  • If you are using the same repository as Advanced ETL Processor/Visual Importer ETL most likely it is already upgraded

Run the following SQL against your repository:

All repository types

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('903','MongoDB Connection')

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('904','MongoDB Connections')

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=22000
WHERE OBJECT_TYPE= '903'

For Oracle

CREATE TABLE EVENT_MONITORS (
EVENT_MONITOR_ID integer NOT NULL,
EVENT_MONITOR_DESCRIPTION VARCHAR (255) NOT NULL ,
EVENT_MONITOR_TYPE integer NOT NULL,
ENABLE_EXECUTION NUMBER(1,0) DEFAULT 0 NOT NULL ,
CONNECTION_ID integer NULL,
COMPUTER_TO_MONITOR VARCHAR (64) NOT NULL ,
EVENT_MONITOR_COMMENTS BLOB NULL ,
EVENT_MONITOR_PARAMETERS BLOB NULL ,
OBJECT_ID integer NULL,
COMPUTER_TO_EXECUTE_ON VARCHAR (64) NOT NULL,
APPLICATION_PLATFORM VARCHAR (30) NULL,
NUMBER_OF_EXECUTIONS integer DEFAULT 0 NULL,
TERMINATE_ON_TIMEOUT NUMBER (1) default 0 NOT NULL ,
EXPECTED_EXECUTION_TIME date NULL ,
CREATED date NOT NULL ,
CREATED_BY VARCHAR (32) NULL ,
CHANGED date NOT NULL ,
CHANGED_BY VARCHAR (32) NOT NULL
)
/

CREATE TABLE NODES (
NODE_NAME VARCHAR (64) NOT NULL ,
NODE_DESCRIPTION VARCHAR (255) NULL,
OPERATING_SYSTEM VARCHAR (255) NULL,
REGISTERED_COMPANY VARCHAR (255) NULL,
REGISTERED_OWNER VARCHAR (255) NULL,
NETWORK_DOMAIN VARCHAR (255) NULL,
IP_ADDRESS VARCHAR (30) NULL,
CREATED date NOT NULL ,
CREATED_BY VARCHAR (32) NULL ,
CHANGED date NOT NULL ,
CHANGED_BY VARCHAR (32) NOT NULL
)
/

CREATE TABLE NODE_STATUS (
NODE_NAME VARCHAR (64) NOT NULL ,
APPLICATION_NAME VARCHAR (64) NULL ,
APPLICATION_PLATFORM VARCHAR (30) NULL ,
APPLICATION_DESCRIPTION VARCHAR (255) NULL ,
APPLICATION_VERSION VARCHAR (30) NULL ,
APPLICATION_PARAMETERS BLOB NULL ,
ENABLE_EXECUTION NUMBER(1,0) DEFAULT 0 NOT NULL,
LICENSED_FROM date NULL ,
LICENSE_OWNER VARCHAR (255) NULL ,
LICENSE_TYPE VARCHAR (30) NULL ,
USER_NAME VARCHAR (64) NULL ,
STARTED date NULL ,
LAST_HART_BEAT date NULL ,
SHUT_DOWN date NULL ,
CREATED date NOT NULL ,
CREATED_BY VARCHAR (32) NULL ,
CHANGED date NOT NULL ,
CHANGED_BY VARCHAR (32) NOT NULL
)
/

ALTER TABLE EVENT_MONITORS ADD
CONSTRAINT PK_EVENT_MONITORS PRIMARY KEY
(
EVENT_MONITOR_ID
)
/

ALTER TABLE NODES ADD
CONSTRAINT PK_NODES PRIMARY KEY
(
NODE_NAME
)
/

ALTER TABLE NODE_STATUS ADD
CONSTRAINT PK_NODE_STATUS PRIMARY KEY
(
NODE_NAME,
APPLICATION_NAME,
APPLICATION_PLATFORM
)
/

ALTER TABLE NODE_STATUS ADD
CONSTRAINT FK_NODE_STATUS_NODE_NAME FOREIGN KEY
(
NODE_NAME
) REFERENCES NODES
(
NODE_NAME
)
/

ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT NUMBER (1) default 0 NOT NULL
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT NUMBER (1) default 0 NOT NULL
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT NUMBER (1) default 0 NOT NULL
For MS SQL Server

CREATE TABLE [EVENT_MONITORS] (
[EVENT_MONITOR_ID] decimal(28, 0) NOT NULL ,
[EVENT_MONITOR_DESCRIPTION] NVARCHAR (255) NOT NULL ,
[EVENT_MONITOR_TYPE] decimal(28, 0) NOT NULL ,
[ENABLE_EXECUTION] decimal(1, 0) NOT NULL default 0,
[CONNECTION_ID] decimal(28, 0) NULL ,
[COMPUTER_TO_MONITOR] NVARCHAR (64) NOT NULL ,
[EVENT_MONITOR_COMMENTS] [image] NULL ,
[EVENT_MONITOR_PARAMETERS] [image] NULL ,
[OBJECT_ID] decimal(28, 0) NOT NULL ,
[COMPUTER_TO_EXECUTE_ON] NVARCHAR (64) NOT NULL,
[APPLICATION_PLATFORM] NVARCHAR (30) NULL,
[NUMBER_OF_EXECUTIONS] decimal(28, 0) NULL default 0,
[TERMINATE_ON_TIMEOUT] decimal(1, 0) NULL default 0,
[EXPECTED_EXECUTION_TIME] [datetime] NULL ,
[CREATED] [datetime] NOT NULL ,
[CREATED_BY] NVARCHAR (32) NULL ,
[CHANGED] [datetime] NOT NULL ,
[CHANGED_BY] NVARCHAR (32) NOT NULL
)
GO

CREATE TABLE [NODES] (
[NODE_NAME] NVARCHAR (64) NOT NULL ,
[NODE_DESCRIPTION] NVARCHAR (255) NULL,
[OPERATING_SYSTEM] NVARCHAR (255) NULL,
[REGISTERED_COMPANY] NVARCHAR (255) NULL,
[REGISTERED_OWNER] NVARCHAR (255) NULL,
[NETWORK_DOMAIN] NVARCHAR (255) NULL,
[IP_ADDRESS] NVARCHAR (30) NULL,
[CREATED] [datetime] NOT NULL ,
[CREATED_BY] NVARCHAR (32) NULL ,
[CHANGED] [datetime] NOT NULL ,
[CHANGED_BY] NVARCHAR (32) NOT NULL
)
GO

CREATE TABLE [NODE_STATUS] (
[NODE_NAME] NVARCHAR (64) NOT NULL ,
[APPLICATION_NAME] NVARCHAR (64) NOT NULL ,
[APPLICATION_PLATFORM] NVARCHAR (30) NOT NULL ,
[APPLICATION_DESCRIPTION] NVARCHAR (255) NULL ,
[APPLICATION_VERSION] NVARCHAR (30) NULL ,
[APPLICATION_PARAMETERS] [image] NULL ,
[ENABLE_EXECUTION] decimal(1, 0) NOT NULL default 0,
[LICENSED_FROM] [datetime] NULL ,
[LICENSE_OWNER] NVARCHAR (255) NULL ,
[LICENSE_TYPE] NVARCHAR (30) NULL ,
[USER_NAME] NVARCHAR (64) NULL ,
[STARTED] [datetime] NULL ,
[LAST_HART_BEAT] [datetime] NULL ,
[SHUT_DOWN] [datetime] NULL ,
[CREATED] [datetime] NOT NULL ,
[CREATED_BY] NVARCHAR (32) NULL ,
[CHANGED] [datetime] NOT NULL ,
[CHANGED_BY] NVARCHAR (32) NOT NULL
)
GO

ALTER TABLE [EVENT_MONITORS] ADD
CONSTRAINT [PK_EVENT_MONITORS] PRIMARY KEY
(
[EVENT_MONITOR_ID]
)
GO

ALTER TABLE [NODES] ADD
CONSTRAINT [PK_NODES] PRIMARY KEY
(
[NODE_NAME]
)
GO

ALTER TABLE [NODE_STATUS] ADD
CONSTRAINT [PK_NODE_STATUS] PRIMARY KEY
(
[NODE_NAME],
[APPLICATION_NAME],
[APPLICATION_PLATFORM]
)
GO

ALTER TABLE [NODE_STATUS] ADD
CONSTRAINT [FK_NODE_STATUS_NODE_NAME] FOREIGN KEY
(
[NODE_NAME]
) REFERENCES [NODES]
(
[NODE_NAME]
)
GO

ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT decimal(1, 0) NULL default 0
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT decimal(1, 0) NULL default 0
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT decimal(1, 0) NULL default 0

For MySQL

CREATE TABLE EVENT_MONITORS (
EVENT_MONITOR_ID NUMERIC NOT NULL,
EVENT_MONITOR_DESCRIPTION NVARCHAR (255) NOT NULL ,
EVENT_MONITOR_TYPE NUMERIC NOT NULL,
ENABLE_EXECUTION NUMERIC(1,0) NOT NULL DEFAULT 0,
CONNECTION_ID NUMERIC NULL,
COMPUTER_TO_MONITOR NVARCHAR (64) NOT NULL ,
EVENT_MONITOR_COMMENTS BLOB NULL ,
EVENT_MONITOR_PARAMETERS BLOB NULL ,
OBJECT_ID NUMERIC NULL,
COMPUTER_TO_EXECUTE_ON NVARCHAR (64) NOT NULL,
APPLICATION_PLATFORM NVARCHAR (30) NULL,
NUMBER_OF_EXECUTIONS NUMERIC NULL DEFAULT 0,
TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0,
EXPECTED_EXECUTION_TIME datetime NULL ,
CREATED DATETIME NOT NULL ,
CREATED_BY NVARCHAR (32) NULL ,
CHANGED DATETIME NOT NULL ,
CHANGED_BY NVARCHAR (32) NOT NULL
)
;

CREATE TABLE NODES (
NODE_NAME NVARCHAR (64) NOT NULL ,
NODE_DESCRIPTION NVARCHAR (255) NULL,
OPERATING_SYSTEM NVARCHAR (255) NULL,
REGISTERED_COMPANY NVARCHAR (255) NULL,
REGISTERED_OWNER NVARCHAR (255) NULL,
NETWORK_DOMAIN NVARCHAR (255) NULL,
IP_ADDRESS NVARCHAR (30) NULL,
CREATED DATETIME NOT NULL ,
CREATED_BY NVARCHAR (32) NULL ,
CHANGED DATETIME NOT NULL ,
CHANGED_BY NVARCHAR (32) NOT NULL
)
;

CREATE TABLE NODE_STATUS (
NODE_NAME NVARCHAR (64) NOT NULL ,
APPLICATION_NAME NVARCHAR (64) NULL ,
APPLICATION_PLATFORM NVARCHAR (30) NULL ,
APPLICATION_DESCRIPTION NVARCHAR (255) NULL ,
APPLICATION_VERSION NVARCHAR (30) NULL ,
APPLICATION_PARAMETERS Blob NULL ,
ENABLE_EXECUTION NUMERIC(1,0) NOT NULL DEFAULT 0,
LICENSED_FROM DATETIME NULL ,
LICENSE_OWNER NVARCHAR (255) NULL ,
LICENSE_TYPE NVARCHAR (30) NULL ,
USER_NAME NVARCHAR (64) NULL ,
STARTED DATETIME NULL ,
LAST_HART_BEAT DATETIME NULL ,
SHUT_DOWN DATETIME NULL ,
CREATED DATETIME NOT NULL ,
CREATED_BY NVARCHAR (32) NULL ,
CHANGED DATETIME NOT NULL ,
CHANGED_BY NVARCHAR (32) NOT NULL)
;

ALTER TABLE EVENT_MONITORS ADD
CONSTRAINT PK_EVENT_MONITOR PRIMARY KEY
(
EVENT_MONITOR_ID
)
;

ALTER TABLE NODES ADD
CONSTRAINT PK_NODES PRIMARY KEY
(
NODE_NAME
)
;

ALTER TABLE NODE_STATUS ADD
CONSTRAINT PK_NODE_STATUS PRIMARY KEY
(
NODE_NAME,
APPLICATION_NAME,
APPLICATION_PLATFORM
)
;

ALTER TABLE NODE_STATUS ADD
CONSTRAINT FK_NODE_STATUS_NODES FOREIGN KEY
(
NODE_NAME
) REFERENCES NODES (
NODE_NAME
) ON DELETE CASCADE
;

CREATE INDEX NODE_STATUS_IDX1 ON NODE_STATUS
(
NODE_NAME
)
;

ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
For PostgreSQL

create table event_monitors (
event_monitor_id double precision not null,
event_monitor_description varchar (255) not null ,
event_monitor_type double precision not null,
enable_execution numeric(1) not null DEFAULT 0,
connection_id double precision null,
computer_to_monitor varchar (64) not null ,
event_monitor_comments bytea null ,
event_monitor_parameters bytea null ,
object_id double precision null,
computer_to_execute_on varchar (64) not null,
application_platform varchar (30) null,
number_of_executions double precision null DEFAULT 0,
terminate_on_timeout numeric (1) not null DEFAULT 0,
expected_execution_time timestamp null ,
created timestamp not null ,
created_by varchar (32) null ,
changed timestamp not null ,
changed_by varchar (32) not null
)
;
create table nodes (
node_name varchar (64) not null ,
node_description varchar (255) null,
operating_system varchar (255) null,
registered_company varchar (255) null,
registered_owner varchar (255) null,
network_domain varchar (255) null,
ip_address varchar (30) null,
created timestamp not null ,
created_by varchar (32) null ,
changed timestamp not null ,
changed_by varchar (32) not null
)
;
create table node_status (
node_name varchar (64) not null ,
application_name varchar (64) null ,
application_platform varchar (30) null ,
application_description varchar (255) null ,
application_version varchar (30) null ,
application_parameters bytea null ,
enable_execution numeric(1) not null default 0,
licensed_from timestamp null ,
license_owner varchar (255) null ,
license_type varchar (30) null ,
user_name varchar (64) null ,
started timestamp null ,
last_hart_beat timestamp null ,
shut_down timestamp null ,
created timestamp not null ,
created_by varchar (32) null ,
changed timestamp not null ,
changed_by varchar (32) not null)
;

alter table nodes add
constraint pk_nodes primary key
(
node_name
)
;

alter table node_status add
constraint pk_node_status primary key
(
node_name,
application_name,
application_platform
)
;

 alter table node_status add
constraint fk_node_status_node_name foreign key
(
node_name
) references nodes
(
node_name
)
;

alter table queue add terminate_on_timeout numeric(1) DEFAULT 0
alter table queue_history add terminate_on_timeout numeric(1) DEFAULT 0
alter table schedule add terminate_on_timeout numeric(1) DEFAULT 0
For Interbase

CREATE TABLE EVENT_MONITORS (
EVENT_MONITOR_ID DOUBLE PRECISION NOT NULL,
EVENT_MONITOR_DESCRIPTION VARCHAR (255) NOT NULL ,
EVENT_MONITOR_TYPE DOUBLE PRECISION NOT NULL,
ENABLE_EXECUTION NUMERIC(1) default 0,
CONNECTION_ID DOUBLE PRECISION,
COMPUTER_TO_MONITOR VARCHAR (64) NOT NULL ,
EVENT_MONITOR_COMMENTS BLOB ,
EVENT_MONITOR_PARAMETERS BLOB ,
OBJECT_ID DOUBLE PRECISION,
COMPUTER_TO_EXECUTE_ON VARCHAR (64) NOT NULL,
APPLICATION_PLATFORM VARCHAR (30) ,
NUMBER_OF_EXECUTIONS DOUBLE PRECISION default 0,
TERMINATE_ON_TIMEOUT NUMERIC (1) default 0,
EXPECTED_EXECUTION_TIME Date,
CREATED date NOT NULL ,
CREATED_BY VARCHAR (32) NOT NULL ,
CHANGED date NOT NULL ,
CHANGED_BY VARCHAR (32) NOT NULL
)
;

CREATE TABLE NODES (
NODE_NAME VARCHAR (64) NOT NULL ,
NODE_DESCRIPTION VARCHAR (255) ,
OPERATING_SYSTEM VARCHAR (255) ,
REGISTERED_COMPANY VARCHAR (255) ,
REGISTERED_OWNER VARCHAR (255) ,
NETWORK_DOMAIN VARCHAR (255) ,
IP_ADDRESS VARCHAR (30) ,
CREATED date NOT NULL ,
CREATED_BY VARCHAR (32) NOT NULL ,
CHANGED date NOT NULL ,
CHANGED_BY VARCHAR (32) NOT NULL
)
;

CREATE TABLE NODE_STATUS (
NODE_NAME VARCHAR (64) NOT NULL,
APPLICATION_NAME VARCHAR (64) NOT NULL,
APPLICATION_PLATFORM VARCHAR (30) NOT NULL,
APPLICATION_DESCRIPTION VARCHAR (255),
APPLICATION_VERSION VARCHAR (30),
APPLICATION_PARAMETERS blob ,
ENABLE_EXECUTION NUMERIC(1) DEFAULT 0,
LICENSED_FROM date,
LICENSE_OWNER VARCHAR (255),
LICENSE_TYPE VARCHAR (30),
USER_NAME VARCHAR (64),
STARTED date,
LAST_HART_BEAT date,
SHUT_DOWN date,
CREATED date NOT NULL,
CREATED_BY VARCHAR (32) NOT NULL,
CHANGED date NOT NULL ,
CHANGED_BY VARCHAR (32) NOT NULL
)
;

ALTER TABLE NODES ADD
CONSTRAINT PK_NODES PRIMARY KEY
(
NODE_NAME
)
;

ALTER TABLE NODE_STATUS ADD
CONSTRAINT PK_NODE_STATUS PRIMARY KEY
(
NODE_NAME,
APPLICATION_NAME,
APPLICATION_PLATFORM
)
;

CREATE INDEX NODE_NAME_IDX1 ON NODES
(
NODE_NAME
)
;

CREATE INDEX NODE_STATUS_IDX1 ON NODE_STATUS
(
NODE_NAME,
APPLICATION_NAME,
APPLICATION_PLATFORM
)
;

ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT NUMERIC (1) default 0,
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0

Note: If you are having problems upgrading our software please let us know and we will do our best to assist you

Learn More About Active Table Editor... Read WIKI

We have 208 guests and no members online