Making ETL Objects Read Only

No one wants to be famous for the wrong reason, this is why it is important to prevent changes to ETL transformations once they are deployed to production.

This can be easily done with the latest versions of Advanced ETL Processor and Visual Importer ETL

All the user have to do is to press the read-only button.

For Oracle

ALTER TABLE OBJECTS_TREE ADD READ_ONLY Integer NULL

For MS SQL Server

ALTER TABLE OBJECTS_TREE ADD READ_ONLY decimal(28, 0) NULL

For MySQL

ALTER TABLE OBJECTS_TREE ADD READ_ONLY Numeric

For PostgreSQL

ALTER TABLE OBJECTS_TREE ADD read_only double-precision null

For Interbase

ALTER TABLE OBJECTS_TREE ADD READ_ONLY DOUBLE PRECISION NOT NULL

We would like to thank Orlando Cabrera from Xerox Canada Ltd for providing us with valuable feedback