Skip to main content

 

ThoughtSpot

Data Connect connectors reference

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

Here is a list of all of the source connectors, and their connection credentials, that are supported in ThoughtSpot Data Connect. As you create a new connection, you will need specific connection information to enter into the create connection dialog box. You can find more detailed information below for each of the connection types ThoughtSpot Data Connect supports.

Table 1. Connection types and credentials
Connection Type Connection Credentials
Amazon S3
  • Connection name*: Enter a new Amazon S3 connection name.
  • Access Key: Enter the access key ID used to access the Amazon account resources. This is required if you do not use AWS Identity and Access Management (IAM) authentication.
  • Secret Key: Enter the secret access key used to access the Amazon account resources. This value is associated with the access key and uniquely identifies the account. You must specify this value if you specify the access key ID.
  • Folder Path*: Enter the complete path to the Amazon S3 objects. You must include the bucket name and any folder name. For example, <bucket name>/<my folder name>.
  • Master Symmetric Key: Provide a 256-bit AES encryption key in the Base64 format when you enable client-side encryption. You can generate a key using a third-party tool.
  • Code Page*: Choose either MS_1252 or UTF_8 from the dropdown menu. The code page should be compatible with the Amazon S3 source.
  • Region Name*: Make a selection from the dropdown menu, which includes US East (N. Virginia), US West (N. California), and US West (Oregon). This is where the Amazon S3 bucket is available.
Flat File
  • Connection name*: Enter a new Flat File connection name.
  • Directory*: Enter the directory where you want to connect to.
  • Date Format*: Choose your date format from the dropdown menu.
  • Code Page*: Choose either MS_1252 or UTF_8 from the dropdown menu. The code page should be compatible with the Flat File source.
Jira
  • Connection name*: Enter a new JIRA connection name.
  • Username*: Enter the JIRA account username.
  • Password*: Enter the JIRA account password.
  • URL*: Enter the base JIRA URL of the JIRA instance you want to connect to. For example, https://<your_company_name>.atlassian.net/.
MySQL
  • Connection name*: Enter a new MySQL connection name.
  • Username*: Enter the MySQL account username.
  • Password*: Enter the MySQL account password.
  • Host*: Enter the host number. For example, 192.156.3.123.
  • Port*: Enter the port number. For example, 3305.
  • Database Name*: Enter the database name you want to connect to.
  • Code Page*: Choose either MS_1252 or UTF_8 from the dropdown menu. The code page should be compatible with the MySQL source.
Oracle
  • Connection name*: Enter a new Oracle connection name.
  • Username*: Enter the Oracle account username.
  • Password*: Enter the Oracle account password.
  • Host*: Enter the host number. For example, 192.156.3.123.
  • Port*: Enter the port number. For example, 3305.
  • Service Name*: Enter the service name. You can find the service name by connecting to the server as "system" using SID, then executing the query: select value from v$parameter where name like '%service_name%';.
  • Schema*: Enter the schema you want to connect to.
  • Code Page*: Choose either MS_1252 or UTF_8 from the dropdown menu. The code page should be compatible with the Oracle source.
REST
  • Connection name*: Enter a new REST API connection name.
  • Base Url*: Enter the REST endpoint URL, without the Query parameters, that you want to connect to.
  • Is BaseUrl Dynamic*: Choose either true or false from the dropdown menu. The base URL is dynamic if each request is different.
  • Url Request Parameters: Enter the request that is URL query parameters. Parameters should be separated by semicolons. The Property and value should be separated by 'equals' (=).
  • Form Request Parameters: Enter the request that is form query parameters.
  • Header Request Parameters: Enter the request that is header query parameters.
  • Media Type*: Choose your media type from the dropdown menu. This is the data that you're receiving.
  • Request Type*: Choose your request type from the dropdown menu. Currently, only GET is supported, even though other types are listed.
  • Authentication Type*: Choose your authentication type from the dropdown menu. If you choose CUSTOM_AUTH, please contact ThoughtSpot Support to help you create the authentication.
  • OAuth Consumer Key: Provide the consumer key for OAuth authentication.
  • OAuth Consumer Secret: Provide the consumer secret for OAuth authentication.
  • OAuth Token: Mention the token key for OAuth authentication.
  • OAuth Token Secret: Mention the token secret for OAuth authentication.
  • URL Input Parameters Config File Name: Mention the URL input parameter file name with the path. The file path should be entered for a dynamic base URL. The URLs are generated at run time with values that are fetched from the CSV file.
  • FORM Input Parameters Config File Name: Mention the form input parameter file name with the path.
  • HEADER Input Parameters Config File Name: Mention the header input parameter file name with the path.
SalesForce
  • Connection name*: Enter a new Salesforce connection name.
  • Username*: Enter the Salesforce account email address.
  • Password*: Enter the Salseforce account password.
  • Security Token*: Enter the security token generated from the Salesforce application. If your account requires a security token and you don't have one, you can generate or reset a security token. After logging in to the Salesforce web site, click Setup > My Personal Information > Reset My Security Token.
  • Service URL*: Enter the Salesforce service URL. You can use the following versions of the Salesforce API:
SQL Server
  • Connection name*: Enter a new SQL Server connection name.
  • Server Version*: Make a selection from the dropdown menu, which includes SQL Server 2000, 2005, 2008, and 2012.
  • Username*: Enter the SQL Server account username.
  • Password*: Enter the SQL Server account password.
  • Host*: Enter the host number. For example, 192.156.3.123.
  • Port*: Enter the port number. For example, 3305.
  • Instance Name: Enter the instance name.
  • Database Name*: Enter the database name you want to connect to.
  • Schema: Enter the schema you want to connect to.
  • Code Page*: Choose either MS_1252 or UTF_8 from the dropdown menu. The code page should be compatible with the SQL Server source.
Teradata
  • Connection name*: Enter a new Teradata connection name.
  • Username*: Enter the Teradata account username.
  • Password*: Enter the Teradata account password.
  • Schema*: Enter the schema you want to connect to.
  • JDBC Connection URL*: Enter the JDBC connection URL that you want to connect to. For example, jdbc:teradata://capri1.teradata.ws.
  • JDBC Jar Directory*: Enter the JDBC jar directory that you want to connect to. For example, /home/admin/pr_temp/jdbc/Teradata.
Twitter
  • Connection name*: Enter a new Twitter connection name.
  • Username*: Enter the Twitter account username.
  • Password*: Enter the Twitter account password.
  • OAuth settings details: You can generate your Twitter OAuth setting details if you don't know them. Start by going to https://www.dev.twitter.com and logging in using your login credentials. Click on the user icon at the top right of the home page and select My applications. From the list of available applications, select the application for which you want to create a connection. The page containing the OAuth settings details appears. If the tokens are not generated, click Recreate my access token.
    • OAuth Consumer Key*: Enter the OAuth consumer key obtained from Twitter.
    • OAuth Consumer Secret*: Enter the OAuth consumer secret obtained from Twitter.
    • OAuth Access Token*: Enter the OAuth access token obtained from Twitter.
    • OAuth Access Token Secret*: Enter the OAuth access token secret obtained from Twitter.
  • Enable Logging*: Choose either true or false from the dropdown menu.
Zendesk
  • Connection name*: Enter a new Zendesk connection name.
  • Username*: Enter the Zendesk account email address.
  • Password*: Enter the Zendesk account password.
  • Zendesk Sub-Domain*: Enter the URL of the Zendesk account. For example, https://informaticabusinesssolutionh...esk.com/api/v2.
* Required fields
  • Was this article helpful?