Connect Teradata to Row Zero

Row Zero's built-in Teradata connector makes it easy to connect your spreadsheets to Teradata. Follow the instructions below to connect to Teradata, share your connection with others, and import data to a spreadsheet.

Create your Teradata connection

The Teradata connector supports two result delivery modes:

• Staged - Recommended for larger datasets and better performance. Staged mode requires a Bring Your Own Bucket configuration, where query
  results are staged through an AWS S3 bucket that you control. Before creating a Staged connection, set up an S3 bucket and IAM role by following the Bring Your Own Bucket setup guide.
• Streaming - Intended for smaller datasets. Streaming mode retrieves data directly to your workbook and only requires host, port, username, and password.

1. In a Row Zero workbook, click on the 'Data' icon in the upper right-hand corner, click 'Add connection', and select Teradata.

   

2. Select your result delivery mode (Staged or Streaming), then fill in the required fields:

   

   • Connection name - This field can be anything that helps identify the data source being connected (e.g. "Production Data" or "Product Metrics"). It will be visible to all users who have access to this connection.
   • Result delivery mode - Choose Staged for larger datasets and better performance, or Streaming for smaller datasets with simpler setup.
   • Host - This is the Teradata server address that typically takes the form of a string like 'teradata.mydomain.com'.
   • Port - This is often 1025.
   • User - This is the username for your Teradata database.
   • Password - The password used to log into your Teradata database.
   • The following fields are required only for Staged mode:
     • S3 Bucket - The name of the staging bucket you created during the Bring Your Own Bucket.
     • Region - The AWS region of your staging bucket.
     • IAM Role ARN - The ARN of the IAM role you created during the Bring Your Own Bucket.

3. Once all the information is entered, hit 'Test connection' to ensure the information is correct. If the test connection icon turns green and says 'Connected', proceed by clicking on 'Create Connection'.

   • Note: If your database is behind a VPN or firewall, you'll need to allow the Row Zero IP addresses: 18.217.97.112 and 18.224.119.220.

4. If you would like other users to be able to use this connection to query Teradata from Row Zero, you can securely share the connection with them in Row Zero. This is appropriate if multiple users share a service account. To share your connection in Row Zero:

   1. Navigate to your Connections page.
   2. Find the Connection that you'd like to share, click '...' next to the name of the connection, and select 'Manage sharing'.
   3. Enter the emails of the users or groups that should have access to this connection.

Write a query to import Teradata data

Now that your spreadsheet is connected to Teradata, you can import data by writing queries directly from Row Zero.

1. From any Workbook, click 'Data', and then click the "+" sign next to your Teradata connection to insert a connected table. This adds a data table to your spreadsheet that is connected to Teradata and opens a query editor.

   

2. Write a SQL query for the data you'd like to import. The easiest query to write is a 'select *' statement, which pulls in the entire table. For example:

   select * from table_name

3. Click 'Run' to execute the query and import the queried Teradata data into your spreadsheet.

   

4. The data imports directly into a connected table, a dynamic, condensed view that makes it easy to refresh and analyze your data. Double-click on the connected table to re-run your query for the latest data or schedule auto-refresh and everything built on connected data automatically updates and stays in sync.

   

5. Once you've imported your Teradata data, you can build out your connected spreadsheet, adding computed columns, pivot tables, charts, and more.