Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Locking Transformations

Locking Transformations 3 years 5 months ago #14966

  • TimJ
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
I have several objects in the transformation that needs to be locked or make it read-only.

Please Log in or Create an account to join the conversation.

Locking Transformations 3 years 5 months ago #14967

Advanced ETL Processor and Visual Importer ETL are capable of preventing changes on the transformations.

To make the transformations locked or read-only.



To make a single or several objects read-only, select top node from the objects tree for options.



.

Please Log in or Create an account to join the conversation.

Locking Transformations 3 years 5 months ago #14968

Transformations can be set to read-only by the following databases

Oracle
ALTER TABLE OBJECTS_TREE ADD READ_ONLY Integer NULL

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

MySQL
ALTER TABLE OBJECTS_TREE ADD READ_ONLY Numeric

PostgreSQL
ALTER TABLE OBJECTS_TREE ADD read_only double precision null

Interbase
ALTER TABLE OBJECTS_TREE ADD READ_ONLY DOUBLE PRECISION NOT NULL

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 145 guests and one member online