011 How to enable Block Transformation

The Update procedure

This update adds Block Transformation objects to the repository. Use it when the product version supports block transformations but the repository does not show them yet. The transformation is not being shy. The repository just needs the right rows.

It applies to repositories used by Advanced ETL Processor and Visual Importer ETL.

Before you run the SQL

1. Create a repository backup.
2. Stop services and scheduled jobs using the repository.
3. Confirm that the repository belongs to the product installation you are upgrading.
4. Restart the application after applying the update.

Run this SQL against the repository

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME,OBJECT_TYPE_GROUP)
Values
(420,'Block Transformations',51000)

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME,OBJECT_TYPE_GROUP)
Values
(421,'Block Transformation Group',51000)

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME,OBJECT_TYPE_GROUP)
Values
(422,'Block Transformation',51000)

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-10 as OBJECT_ID,
PARENT_ID,
'Block Transformations' as NAME,
420 as OBJECT_TYPE
From
OBJECTS_TREE
where
OBJECTS_TREE.OBJECT_TYPE=390

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=51000
WHERE OBJECT_TYPE= '420'

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=51000
WHERE OBJECT_TYPE= '421'

After the repository update

Restart the product and check the transformation area in the repository tree. Block Transformations should now be available. If not, verify the active repository connection before changing anything else.