connectivity

Version: - Created: 04 Sep 2024

Teradata SQL Driver Dialect for SQLAlchemyThis package enables SQLAlchemy to connect to the Teradata Database.This package requires 64-bit Python 3.4 or later, and runs on Windows, macOS, and Linux. 32-bit Python is not supported.For community support, please visit the Teradata Community forums.For Teradata customer support, please visit Teradata Access.Copyright 2024 Teradata. All Rights Reserved.

Version: - Created: 29 Mar 2024

Overview teradatamlspk is a Python package, built as an extension of teradataml, Teradata Python package. Syntax and user accessibility of teradatamlspk APIs are kept similar to PySpark APIs, allowing, the existing PySpark workloads, that run on Spark engine, can be easily run on Teradata Vantage with minimal changes to migrate PySpark workloads to Vantage. teradatamlspk offers another function pyspark2teradataml that enables conversion of a PySpark script to a teradatamlspk Python script. It also generates the HTML report for the conversion, that is useful for the user to understand the changes done and also carry out any manual changes in the generated script, so that the script can be run on Vantage. Dependent Python Packages:  teradataml 20.0.0.0 or Later PrettyTable  

Version: - Created: 16 Nov 2023

The Teradata SQL Driver for Node.js enables Node.js applications to connect to the Teradata database. For documentation, license information, and sample programs, please visit the driver GitHub page. For community support, please visit Teradata Community. For Teradata customer support, please visit Teradata Customer Service. We recommend that you follow the Installation instructions listed on the driver GitHub page. If the recommended installation procedure is not possible for you, then follow these manual installation steps: .list-with-disc { list-style-type: disc !important; } Download the .tgz file from the link above. In your command prompt or shell, run npm install tgzFileName

Version: - Created: 16 Nov 2023

The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET specification. It provides direct access to the Teradata Database and integrates with the DataSet. .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.   For Visual Studio 2017 and newer, you will need to download the Integrated Help package and/or the appropriate VS Integration package if you wish to use these features. For the VS Integration features, simply download the file and execute it. Microsoft Edge changes the file extension from VSIX to ZIP. You must rename the file back to VSIX to execute it. VSIXInstaller.exe is part of Visual Studio 2017 and VSIX extension should already be associated with VSIXInstaller.exe.  For Integrated Help, unzip the file to a temporary directory and then use the Help, Add and Remove Content menu to install the help. Use the Browse [...] button near the bottom of the dialog to select the extracted helpcontentsetup.msha file, then click Update. PLEASE NOTE that the VS Integration package is self-contained and does not require the .NET Data Provider for Teradata to be installed. However, a runtime dependency conflict may arise if your project depends on both, VS Integration and .NET Data Provider for Teradata. To avoid such conflict, the .NET Data Provider for Teradata must be the same or greater version than the VS Integration package. For older versions of Visual Studio, the main Windows installation package (version 16.10 and older) can optionally install the integrated help and Visual Studio integration features. The Teradata Developer Tools for Visual Studio is available from the Visual Studio Marketplace for Visual Studio 2015-2019 and Visual Studio 2022. The release contains a query tool that enables queries to be composed and executed against a Teradata Database. Queries are composed using a custom editor window with intellisense capabilities. Separate windows are used to display results and history. The .NET Data Provider for Teradata is also available as a NuGet package at https://www.nuget.org/packages/Teradata.Client.Provider/. The Entity Framework Core Provider is available as a NuGet package at https://www.nuget.org/packages/Teradata.EntityFrameworkCore/.   For community support, please visit the Connectivity forum.

Version: - Created: 15 Sep 2023

Teradata Partner API The Partner API is composed of two separate components.  The first component is an in-database function (a Table Operator named API_Request) that enables Vantage users to predict (score) machine learning models that are built on 3rd party partner platforms against Vantage data through a Vantage query.  For example, the release 1.4.0 release supports AWS SageMaker, Azure Machine Learning (and OpenAI), Google Vertex AI, and OpenAI model endpoints, with data passed from Vantage to these external platforms using a web services call, and the results are returned to the Vantage end user as results from the query. The second component is a Python library (named tdapiclient), which is a companion package of the Teradata Package for Python (teradataml), Teradata's Python package for client-side processing.  The tdapiclient Python packages allows AWS SageMaker, AzureML and/of Google VertexAI users of Vantage to call each CSP’s Python library interfaces to train and predict using data in Teradata Vantage tables.  tdapiclient also transparently converts and copies the Teradata DataFrame to S3, AzureBlob Storage or Google Cloud Storage for training as part of the fit() method which can invoke any of the API’s offered by the CSP.  For inference, it will use the data directly from Vantage input tables or queries via API_Request.  Test inferences on small amounts of data can also be done directly through the client library.  The tdapiclient also wraps the required BYOM calls to productionize the scoring process.  ** Note that for OpenAI and Azure OpenAI, only the API_Request static API is available in tdapiclient.  Download tdapiclient from:  https://pypi.org/project/tdapiclient/ For more information, see the Partner API Integration Guide on docs.teradata.com.