Active Table Editor

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, the 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

Active Table Editor

Testimonials

What customers say about us

I used Advanced ETL Processor in 2 Enterprises for many business processes and Business automation (outside finance department). I did not find any other tool with so many functions and broad flexibility for that Price! If you need support for bugs or solution design you will get it very fast. Best Support I have ever seen.

Lionel Albrecht
IQVIA and DB Software Laboratory (DBSL) partnered in 2010 and have been working in close cooperation ever since. Over this period of time, DBSL software components formed an integral part of a large number of IQVIA applications currently used by over 20 UK NHS Trusts (Hospitals).

Dmitry Dorsky,
Director
The product is easy to learn and once a developer understands the ETL way for solving the problem at hand, the developer's productivity will increase. Even our DBAs now uses the ETL software to quickly create solutions instead of SSIS or SQL jobs.

Daniel Fung
Solutions Architect

Read ETL Software customers feedback

Active Table Editor - 5.3.4.0

New Release Of Active Table Editor

Other changes are:

More information:

Repository Upgrade Procedure

All repository types

For Oracle

For MySQL

Testimonials

Lionel Albrecht

Dmitry Dorsky,Director

Daniel FungSolutions Architect

Dmitry Dorsky,
Director

Daniel Fung
Solutions Architect