012 How to enable MS Teams Connections

Rename the repository connection object so Microsoft Teams connections appear correctly in the ETL designer.

Repository Database Updates
4.9 ★★★★★ Based on 16 reviews on Capterra See all reviews on Capterra →

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

  1. Create a repository backup.
  2. Stop services and open designers using the repository.
  3. Confirm that object type `380` is present in the repository.
  4. 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.

Note: If you are having problems upgrading our software please let us know and we will do our best to assist you.