Enable Teradata Access

Contents:

Expand all Collapse all

Contents:

This section provides information on how to enable connection to Teradata .

Teradata provides Datawarehousing & Analytics solutions and Marketing applications. The Teradata supports all of their Data warehousing solutions. For more information, see http://www.teradata.com.
For more information on supported versions, see Connection Types.

This connection supports reading and writing. You can create multiple Teradata connections in the Designer Cloud application.

Supported Versions: 14.10+

Supported Environments:

Operation	Designer Cloud Enterprise Edition	Amazon	Microsoft Azure
Read	Supported	Supported	Not supported
Write	Supported	Supported	Supported

Limitations

By default, Teradata does not permit the publication of datasets containing duplicate rows. Workarounds:
- Your final statement for any recipe that generates results for Teradata should include a Remove duplicate rows transformation.
  
  NOTE: The above transformation removes exact, case-sensitive duplicate rows. Teradata may still prevent publication for case-insensitive duplicates.
- It's possible to change the default writing method to Teradata to enable duplicate rows. For more information, contact Alteryx Support.
When creating custom datasets using SQL from Teradata sources, the ORDER BY clause in standard SQL does not work. This is a known issue.

For more information on creating a Teradata connection, see Teradata Connections.

Error	Description
Duplicate row error	This error occurs when duplicate rows are being inserted during publishing to Teradata. Workaround: All inserted rows must be unique ,or the Teradata tables must be `MULTISET`. To configure Designer Cloud Enterprise Edition to use `MULTISET` tables, please contact Alteryx Support.

Steps:

After you create your connection, load a small dataset based on a table in the connected Teradata. See Import Data Page.
Perform a few simple transformations to the data. Run the job. See Transformer Page.
Verify the results.

For more information, see Verify Operations.

See Also for Enable Teradata Access: