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

ReadOnlyPackage

It is also possible to make several objects read-only by selecting the top node from the objects tree.

ReadOnlyMenu 

To make it work one would need to add READ_ONLY field to OBJECTS_TREE table by running the script

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 

Direct link, no registration required.
 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies