Bridge Specifications
| Vendor | ThoughtSpot |
| Tool Name | ThoughtSpot |
| Tool Version | 4.5 |
| Tool Web Site | https://www.thoughtspot.com/ |
| Supported Methodology | [Business Intelligence] Multi-Model, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing), BI Report (Relational Source, Dimensional Source, Report Structure) via REST API |
BRIDGE INFORMATION
Import tool: ThoughtSpot ThoughtSpot 4.5 (https://www.thoughtspot.com/)
Import interface: [Business Intelligence] Multi-Model, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing), BI Report (Relational Source, Dimensional Source, Report Structure) via REST API from ThoughtSpot
Import bridge: 'ThoughtSpotBi' 11.0.0
BRIDGE DOCUMENTATION
This bridge imports metadata from a ThoughtSpot server.
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | ||
| Server URL | Enter the ThoughtSpot Server URL here. | STRING | https://localhost/ | Mandatory | |||
| Login User | Enter the username which the bridge will use to log in. Be sure this user name has necessary permissions to access the objects you wish to import. | STRING | tsadmin | Mandatory | |||
| Login Password | Enter the password associated with the username which the bridge will use to log in. | PASSWORD | |||||
| Sticker filter | This option is used to select answer and pinboard reports by their assigned stickers. If a report has a sticker that was specified as filter, it will be selected for import. You can specify here multiple stickers, separated by semicolon (;) character. |
REPOSITORY_SUBSET | |||||
| Group filter | This option is used to select answer and pinboard reports by their author's assigned groups. If a report's author belongs to a group that was specified as filter, it will be selected for import. You can specify here multiple user groups, separated by semicolon (;) character. |
REPOSITORY_SUBSET | |||||
| Incremental import | Specifies whether to import only the changes made in the source or to re-import everything (as specified in other parameters). True - import only the changes made in the source. False - import everything (as specified in other parameters). An internal cache is maintained for each metadata source, which contains previously imported models. If this is the first import or if the internal cache has been deleted or corrupted, the bridge will behave as if this parameter is set to 'False'. |
BOOLEAN |
|
True | |||
| Miscellaneous | Specify miscellaneous options identified with a -letter and value. For example, -m 4G -v set environment variable(s) (e.g. -v var1=value -v var2="value with spaces"). -m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ). -j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G). |
STRING |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"ThoughtSpot" Metamodel ThoughtSpot (Repository) |
Mapping Comments |
| DirectoryStructureModel | Server | |
| Name | Name | |
| Folder | Sticker, Group | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| StoreContent | Answer, Business Data Model, Database, Pinboard | |
| Author | Author | |
| CreationTime | Creation Time | |
| Description | Description | |
| LastModificationTime | Last Modification Time | |
| Modifier | Modifier | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"ThoughtSpot" Metamodel ThoughtSpot (Business Data Model) |
Mapping Comments |
| ClassDiagram | Diagram | |
| Name | Name | |
| Dimension | Logical Table, Worksheet | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| PhysicalName | Physical Name | |
| DimensionAttribute | Logical Column | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| Join | Relationship | |
| Name | Name | |
| NativeId | Native Id | |
| StoreModel | Business Data Model | |
| ModificationTime | Modification Time | |
| Name | Name |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"ThoughtSpot" Metamodel ThoughtSpot (Answer) |
Mapping Comments |
| Condition | Filter | |
| Name | Name | |
| NativeId | Native Id | |
| ReportAttribute | Logical Column | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportChart | Visualization | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportDataSet | Worksheet | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportField | Field | |
| Name | Name | |
| ReportPage | Answer Sheet | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| StoreModel | Answer Model | |
| Author | Author | |
| CreationTime | Creation Time | |
| Description | Description | |
| ModificationTime | Modification Time | |
| Modifier | Modifier | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"ThoughtSpot" Metamodel ThoughtSpot (Database) |
Mapping Comments |
| Attribute | Column | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Class | Table | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| DatabaseSchema | Schema | |
| Name | Name | |
| StoreModel | Database | |
| Name | Name |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"ThoughtSpot" Metamodel ThoughtSpot (Pinboard) |
Mapping Comments |
| Condition | Filter | |
| Name | Name | |
| NativeId | Native Id | |
| Report | Answer Book | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportAttribute | Logical Column | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportChart | Visualization | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportDataSet | Worksheet | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| ReportField | Field | |
| Name | Name | |
| ReportPage | Pinboard Sheet, Answer Sheet | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| StoreModel | Pinboard Model | |
| Author | Author | |
| CreationTime | Creation Time | |
| Description | Description | |
| ModificationTime | Modification Time | |
| Modifier | Modifier | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type |