Skip to end of banner
Go to start of banner

Teradata Snap Pack

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 75 Next »

Teradata’s leading portfolio of big data analytic solutions, integrated marketing applications, and services can help organizations gain a sustainable competitive advantage with data. 

Use Snaps in this Snap Pack to export data from a Teradata database by providing a table name and configuring the connection. 

Supported Version

This Snap Pack is tested against:

  • 15.10.07.08
  • 16.20.22.01

You need tdgssconfig-15.00.00.33.jar and terajdbc4-15.00.00.33.jar of Teradata. See the Teradata Tools & Utilities documentation for your platform and Teradata version.

In this Section

Snap Pack History

 Click to view/expand

4.25 (main9554)

  • No updates made.

4.24 Patch 424patches8799

  • Enhances the Teradata Execute Snap by adding a new field, Advanced options, which extends support with microsecond precision for TIMESTAMP data type.
  • Fixes an issue in the TPT Load Snap where the Snap failed to load data into the table while creating an output.
  • Fixes an issue with the TPT LoadSnap wherein now a null value is loaded as null and empty string is loaded as empty string.

    • This fix may cause existing pipelines to fail if empty string values are expected to be loaded as null.

    • Following are the new configurations:

      • VARCHAR QuotedData= Optional

      • VARCHAR OpenQuoteMark= \”

      • VARCHAR NullColumns= Yes

4.24 (main8556)

  • Enhances the Teradata Select Snap to return only the selected output fields or columns in the output schema (second output view) using the Fetch Output Fields In Schema check box. If the Output Fields field is empty all the columns are visible.

4.23 (main8556)

  • Fixes an issue with TPT Load Snap wherein now a null value is load as null and empty string is load as empty string.
  • This fix may cause existing pipelines to fail if empty string values are expected to be loaded as null.

  • Following are the new configurations:

    • VARCHAR QuotedData= Optional

    • VARCHAR OpenQuoteMark= \”

    • VARCHAR NullColumns= Yes

4.23 (main7430)

  • Enhances the accounts in this Snap Pack to allow Windows-based (Active Directory) authentication and user impersonation for SQL Server user accounts.

4.22 (main6403)

  • No updates made.

4.21 Patch 421patches6272

  • Fixes the issue where Snowflake SCD2 Snap generates two output documents despite no changes to Cause-historization fields with DATE, TIME and TIMESTAMP Snowflake data types, and with Ignore unchanged rows field selected.

4.21 Patch 421patches6144

  • Fixes the following issues with DB Snaps:
    • The connection thread waits indefinitely causing the subsequent connection requests to become unresponsive.
    • Connection leaks occur during Pipeline execution.

4.21 Patch MULTIPLE8841

  • Fixes the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. 

4.21 (snapsmrc542)

  • No updates made.

4.20 (snapsmrc535)

  • No updates made.

4.19 Patch db/teradata8414

  • Fixes an issue with the TPT Update Snap wherein the Snap is unable to perform operations when:
    • An expression is used in the Update condition property.
    • Input data contain the character '?'.

4.19 (snapsmrc528)

  • No updates made.

4.18 (snapsmrc523)

  • No updates made.

4.17 Patch ALL7402

  • Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17 (snapsmrc515)

  • Fixed an issue with the Teradata Execute Snap wherein the Snap would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snap sends the input document to the output view, under the key original, only if you select the Pass through field.
  • Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16 (snapsmrc508)

  • No updates made. Automatic rebuild with a platform release.

4.15 Patch db/teradata6338

  • Replaced Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings.

4.15 (snapsmrc500)

  • No updates made. Automatic rebuild with a platform release.

4.14 (snapsmrc490)

  • No updates made. Automatic rebuild with a platform release.

4.13 (snapsmrc486)

  • No updates made. Automatic rebuild with a platform release.

4.12 (snapsmrc480)

  • No updates made. Automatic rebuild with a platform release.

4.11 (snapsmrc465)

  • No updates made. Automatic rebuild with a platform release.

4.10 (snapsmrc414)

  • Added Auto commit property to the Select and Execute Snaps at the Snap level to support overriding of the Auto commit property at the Account level.

4.9.0 Patch teradata3077

  • Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap

4.9.0 (snapsmrs405)

  • Enhanced the Output view of the Snap with Order Summary field that displays the output values (added to the out, err, status, classpath and env fields of the single output view that display the subprocess only).
  • Teradata Export to HDFS Snap supported with Dynamic account.

4.8.0 Patch teradata2762

  • Updated the Snap with the property, Delete table data if present.
  • Potential fix for JDBC deadlock issue.

4.8.0 (snapsmrs398)

  • Introduced the TPT Delete, Insert, Load, Upsert and Update Snaps in this release.
  • Introduced Teradata Export to HDFS Snap in this release.
  • Info tab added to accounts.
  • Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

4.7.0 Patch teradat2243

  • Resolved an issue with TPT Fast Export failing with errors but writing output to the specified directory on the Groundplex machine.

4.7.0 Patch teradata2204

  • Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter.

4.7.0 (snapsmrs382)

  • Introduced the Teradata FastLoad and Execute Snaps in this release.
  • Migration impact: In Teradata FastExport, the values of the Data Format field have been standardized to be in all caps. Existing pipelines that use the values of Binary, Text, or Unformatted will fail unless the new value of BINARY, TEXT, or UNFORMAT are used.

4.6.0 Patch teradata2140

  • Resolved an issue with Teradata FastExport not working when the log table name is greater than 24 characters for Teradata v14.

4.6.0 Patch teradata2107

  • Resolved an issue that prevented the Snap from completing.

4.6.0 (snapsmrc362)

  • Snap Pack introduced in 4.6.0. This includes only Teradata extract functionality to move data out of Teradata database using the FastExport Utility. It does not include Snaps for load, select, insert, delete, execute or others at this time. It also does not utilize the Teradata Parallel Transporter to extract data.

  • No labels