The Update procedure
This update renames the repository object used for Microsoft Teams connections. It is a small update, but small repository labels can cause large amounts of head scratching. Naming things remains one of the two hard problems in computing, and this page is not helping the joke retire.
It applies to repositories used by Advanced ETL Processor and Visual Importer ETL.
The SQL updates the existing object tree record with object type `380` so it appears as `MS Teams` in the designer.
Before you run the SQL
- Create a repository backup.
- Stop services and open designers using the repository.
- Confirm that object type `380` is present in the repository.
- Restart the product after applying the update.
Run this SQL against the repository
UPDATE OBJECTS_TREE SET NAME='MS Teams' where OBJECT_TYPE=380; After the repository update
Open the designer and check the connection tree. The connection should now be labelled `MS Teams`. If the label does not change, check that you updated the repository used by the running application.