013 How to enable Scripts

The Update procedure

This update adds Script objects to the repository. Use it when the product version supports scripts but the repository does not show the Scripts branch. Scripts are supposed to automate work, not play hide and seek in the object tree.

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

The SQL creates repository object types for Scripts, Script Groups, and individual Script objects. It also creates the top-level Scripts node below the relevant repository branch.

Before you run the SQL

1. Create a repository backup.
2. Stop services, schedulers, and open designers using the repository.
3. Confirm that you are updating the repository database used by the product.
4. Restart the application after the update.

Run this SQL against the repository

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME,OBJECT_TYPE_GROUP)
Values
(423,'Scripts',52000)

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME,OBJECT_TYPE_GROUP)
Values
(424,'Script Group',52000)

Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME,OBJECT_TYPE_GROUP)
Values
(425,'Script',52000)

INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-20 as OBJECT_ID,
PARENT_ID,
'Scripts' as NAME,
423 as OBJECT_TYPE
From
OBJECTS_TREE
where
OBJECTS_TREE.OBJECT_TYPE=390

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=52000
WHERE OBJECT_TYPE= '423'

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=52000
WHERE OBJECT_TYPE= '424'

After the repository update

Restart the product and check the repository tree. The Scripts branch should now be available. If it is still missing, verify the active repository connection before running any further updates.