Connect a Looker integration

In this guide we will go through the steps to connect to a Looker integration on the Tekst App.

Setup

Step 1: Navigate to "Integrations".

On the Tekst platform, locate and click on the "Integrations" option. This is typically found in the bottom navigation menu.

Step 2: Add a Looker Integration

Click the Connect Integration button in the top-right corner of the Integrations page. The Connect page lists the available integrations (you can filter on the Analytics category). Find "Looker" and click Connect. If Looker is not enabled for your organization yet, a message asks you to contact support to enable it.

Step 3: Create a user

Create a username that fulfills the below requirements:

• Contains only lowercase letters.
• Contains no special characters.
• Contains at least 6 characters.
• Is not admin or default.

Then click Connect & Continue.

This process creates a user within your customer-specific Amazon Redshift environment, allowing access to fetch data directly from Looker.

Tekst then shows the username, the generated password and the connection details. Be sure to securely store the username and password in a password management tool for future use: the password is not shown again after this step. Then check the confirmation box and click Next.

Step 4: Connect to the Tekst datasource in Looker

Add an Amazon Redshift datasource connector to your Looker project. Use your username and password to authenticate and following parameters:

• Server URL: the Server URL Tekst shows next to your username and password. It has the form <yourcompany>.bi.tekst.com. You can find it again later on the Settings tab of the integration.

• Database: data

• Port: 5439

Select "Public" as the schema and add the "datasources" and "threads" tables to your environment.

If you have an issue following this guide or have any other questions, please submit a request or send your question to support@tekst.com.