The Update procedure
This repository update adds Amazon and Azure connection object types so the designer can show those connection groups in the object tree. Without the repository rows, the software may be ready for cloud work while the repository looks at it blankly. Databases can be very committed to pretending they have never met you.
Advanced ETL Processor and Visual Importer ETL store connection definitions in the repository. The SQL below registers the Amazon and Azure object types, assigns their object type groups, and adds both nodes below the cloud connection area.
Before you run the SQL
- Create a repository backup.
- Stop services and scheduled jobs that use the repository.
- Check that you are connected to the ETL repository database, not a source database.
- Run the update once, then restart the application.
Run this SQL against the repository
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('907','Amazon Connection')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('908','Amazon Connections')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('909','Azure Connection')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('910','Azure Connections')
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=25000
WHERE OBJECT_TYPE= '907'
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '908'
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '909'
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=26000
WHERE OBJECT_TYPE= '910'
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-5 as OBJECT_ID,
PARENT_ID,
'Amazon' as NAME,
907 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-6 as OBJECT_ID,
PARENT_ID,
'Azure' as NAME,
909 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322After the repository update
Open the application and check the connection tree. Amazon and Azure should now appear as available connection groups. If they do not appear, confirm that the SQL was run against the active repository used by the installed product.