Document toolboxDocument toolbox

Working with Teradata connection

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)


With Kyvos, you can set up a data connection to connect to your Teradata data warehouse and use it as a data source.

Note

Raw data querying is not supported on Teradata.

To create a Teradata connection, perform the following steps.

  1. You need to first upload the third-party JAR files for Teradata through the Kyvos Manager.

Important

Kyvos is not responsible for maintaining or validating the licenses and sanity of these third-party JAR files, and cannot be held liable for any system errors arising due to these JAR files. You must ensure you have a valid Teradata license for the correct working of the connection.

  1. After you have uploaded the third-party JAR files, navigate to Setup > Connections on the Kyvos Web Portal.

  2. Open the DefaultHadoopConnection and click Properties.
    The kyvos.connection.sparkclasspath.jar property is displayed. 

  3. From the Actions menu ( ⋮ ) click Add Connection.

  4. Enter a name or select it from the Connection list.

  5. After you finish configuring the settings using the table shown below, click the Test button from the top left to validate the connection settings.

  6. If the connection is valid, click the Save button. 

  7. To refresh connections, click the Actions menu ( ⋮ ) at the top of the Connections column and select Refresh.

  8. Enter the following details:

Parameter/Field

Comments/Description

Name

Enter a unique name for the connection.

Category

Select the Warehouse option.

NOTE: There may be more than one warehouse connection.

Provider

Select the Teradata option.

Driver Class

Enter the Driver Class for your Teradata Server.
NOTE: You must ensure that Kyvos can connect to the server.

URL 

Enter the URL for your Teradata Server.
NOTE: You must ensure that Kyvos can connect to the server.

User Name

Enter your Teradata account user name. 

Password

Enter your Teradata account password.  

Use as source

By default, the Use as source checkbox is selected as this connection can only be used to read data (creating registered files) on which the semantic model will be created. 

Properties 

Click Properties to view or set properties.

Copyright Kyvos, Inc. All rights reserved.