Synchronize ThoughtSpot (private preview)
Synchronizing ThoughtSpot is the process of importing and updating metadata from your ThoughtSpot tenant into Collibra Platform.
The integration automatically creates or updates metadata objects as assets in the Data Catalog based on the defined operating model.
You can synchronize manually or automate the process by adding a synchronization schedule.
Prerequisites
Ensure that the requirements are met in both the Collibra and ThoughtSpot environments.
In your Collibra environment
- You have added the ThoughtSpot synchronization capability for the connection.
- You have a resource role with the Configure external system resource permission, for example, Owner.
- You have a global role with the Catalog global permission, for example, Catalog Author.
- You have a global role with the View Edge connections and capabilities global permission, for example, Edge integration engineer.
Steps
-
On the main toolbar, click
→
Catalog.
The Catalog homepage opens. -
In the tab bar, click Integrations.
The Integrations page opens. - Click the Integration Configuration tab.
- Locate the ThoughtSpot connection that you used when you added the ThoughtSpot Synchronization (Preview) capability and click the link in the Capabilities column.
The synchronization configuration page opens. - In the Synchronization Configuration section, click the Edit icon.
- Complete the fields as needed.
Field Action Required Domain Select the domain where ThoughtSpot assets will be created. Use a BI Catalog or Technology Asset domain type.
Yes Org Filter Enter one or more ThoughtSpot Orgs names or identifiers to restrict the scope. If left blank, Collibra synchronizes all Orgs accessible to the credentials.
Yes - Click Save.
- Click Synchronize.
A notification indicates the synchronization has started.
-
On the main toolbar, click
→
Catalog.
The Catalog homepage opens. -
In the tab bar, click Integrations.
The Integrations page opens. - Click the Integration Configuration tab.
- Locate the ThoughtSpot connection that you used when you added the ThoughtSpot Synchronization (Preview) capability and click the link in the Capabilities column.
The synchronization configuration page opens. - In the Synchronization Configuration section, click the Edit icon.
- Complete the fields as needed.
Field Action Required Domain Select the domain where ThoughtSpot assets will be created. Use a BI Catalog or Technology Asset domain type.
Yes Org Filter Enter one or more ThoughtSpot Orgs names or identifiers to restrict the scope. If left blank, Collibra synchronizes all Orgs accessible to the credentials.
Yes - Click Save.
- In the Synchronization Schedule section, click the Add synchronization schedule icon.
- Enter the information.
Field Description Repeat The interval when you want to synchronize automatically. The possible values are: Daily, Weekly, Monthly, and Cron expression. CronThe Quartz Cron expression that determines when the synchronization takes place.
This field is only visible if you select
Cron expressionin the Repeat field.EveryThe day on which you want to synchronize, for example, Sunday.
This field is only visible if you select
Weeklyin the Repeat field.Every firstThe day of the month on which you want to synchronize, for example, Tuesday.
This field is only visible if you select
Monthlyin the Repeat field.At
The time at which you want to synchronize automatically, for example, 14:00.
- You can only schedule on the hour. For example, you can add a synchronization schedule at 8:00, but not at 8:45.
- This field is only visible if you select
Daily,Weekly, orMonthlyin the Repeat field.
Time zone The time zone for the schedule. - Click Save
After the synchronization:
- You can view a summary of the results from the Activities list.
- For information on the integrated data, go to Integrated ThoughtSpot data.