Skip to main content

 

ThoughtSpot

Set Up Lightweight ETL

Overview

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

Feature

To set up lightweight ETL, you'll need to provide an Informatica user name and password.

Lightweight ETL uses Informatica behind the scenes to perform the data import. Use this procedure to supply the user name and password used to connect to Informatica.

You can obtain the credentials from ThoughtSpot Support, if you do not have them. To set up Lightweight ETL:

  1. Log in to the Linux shell using SSH.
  2. Issue the ThoughtSpot SQL Command Line (TQL)(tscli) command to download the Informatica infaagent from the Informatica Cloud.
    tscli --testdev etl download-agent --mode=prod
  3. Invoke tscli again to enable the lightweight ETL Data Cache, which will register with Informatica Cloud and start the infaagent service. The process will take a couple of minutes:
    tscli --testdev etl enable-lw 
       --username <informatica_username>
       --mode=prod
       --admin_username tsadmin 
       --thoughtspot_url <thoughtspot_url>
  4. Create the ThoughtSpot connection on Informatica:
    1. Log in to the Informatica website: https://app.informaticaondemand.com/ma/.
    2. If a ThoughtSpot connection already exists, delete it.
    3. Create a new ThoughtSpot connection using your ThoughtSpot URL as the path to log in. The Environment Name for your Runtime Environment can be found under Configure and Runtime Environments.
  5. You will see a message confirming that the Informatica connection was successful.
  6. Access the feature on the UI by appending /?enableDataAssimilation=True to the URL for your cluster. .
    Enter this new URL into your Web browser. Doing this enables Lightweight ETL in the ThoughtSpot application.
  • Was this article helpful?