Making ETL Transformations 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.
It is also possible to make several objects read-only by selecting the top node from the objects tree.
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