tools

Version: - Created: 14 Oct 2024

TdBench is a tool designed to simulate realistic database workloads for applications and platforms.This tool can be used with any DBMS supporting JDBC to:Measure performance before vs after a change to add indexes, partitioning, compression, etcMeasure the impact to your DBMS of changes to settings, a patch, or a new software releaseSimulate a workload for a new application or a proof of conceptCompare the performance of one platform to anotherCompare performance of different data base vendor’s productsGetting Software and Help for TdBench:You can download the latest package of the TdBench jar file and setup information with scripts for Teradata and non-Teradata DBMSs from this page and unzip it in a directory on a server of PC with connectivity to your DBMSTerdata's JDBC driver is included.  Search the web for other vendor's JDBC drivers and save them on your server or PCAdditional DBMS setup scripts and information may be found at https://github.com/Teradata/tdbench.  You can submit issues, questions or contribute DBMS setup information at https://github.com/Teradata/tdbench/discussions.  Manuals, white papers and videos are reference at the bottom of this page. What does TdBench do?TdBench simulates realistic production systems by allowing definition of the different types of work and adjusting the number of concurrent executions for each type of work;It captures the results each query execution in its internal database.It facilitates analysis host DBMS resource consumption by maintaining test metadata on the host DBMS to join with its query logs.Tests are defined with:queues of SQL queries and scripts or OS commandsvariable number of execution threads (workers) per queuecommands to pace queries by time or percentageparameterized queries to simulate different usersoptional query prepare reducing DBMS parsingscheduled start of processes or individual queriesFixed work or fixed period execution modelsScripting language to automate multiple testsTests can be defined as simply as 4 statements. Analysis capabilities have been used to track individual query performance over hundreds of runs during projects with constraints like:WHERE RunID in (79, 81, 105)Example:  Basic test of all queries in 1 worker session:define serial Test of queries executed seriallyqueue thequeries scripts/queries/*.sqlworker thequeries mydbmsrunExample:  Fixed period test of 10 minutes with 2 queues and a total of 5 worker sessions:define workload5 Test of 1 heavy and 4 reporting worker sessionsqueue hvy scripts/queries/hvy*.sqlworker hvy mydbms 1queue rpt scripts/queries/rpt*.sql;worker rpt mydbms 4run 10mThere are nearly 60 commands for defining and scripting multiple tests.  You could use:the PACE command with an interval reference command to control arrival of queries on a queue, orPACE with a percentage  to limit the percentage of total queries executed from one queue, orAT command to schedule events, or QUERY LIST to replay query starting as the executed in production There are built-in variables, user variables, IF and GOTO statements.There are 69 built-in help files and a TdBench 8.01 User Guide to help you get started.TdBench Documentation:TdBench 8.01 User GuideTdbench 8.01 Tri-Fold Command ReferenceWhite Papers:Essential Guide to Benchmarks for DBAs1-Page Essential Guide to Benchmarks for ExecutivesBenchmark DeceptionBenchmark Deception And How to Avoid Benchmark TricksVideos:TdBench Overview  - Why it was created and what it does (0:10:09)TdBench Command Language - Demonstration of use (0:14:19)Design of a Good Benchmark - Training session on constructing a benchmark that models realistic database workloads (0:41:33)

Version: 01.00.01.00 - Created: 10 May 2024

Vantage Editor DesktopVantage Editor Desktop is an easy to install, lightweight SQL Editor that offers a simple and intuitive user experience for connecting to Teradata and running queries.With the Vantage Editor Desktop you can:Manage connections to SQL Engine 17.20 and aboveCreate, edit, run, rename and save SQL statements and scriptsView, sort, filter and download query resultsView, sort, search, query history and copy/paste for re-executionExport/import query history between Vantage Editor instancesBrowse database objects, mark favorites as starred, view detailed object insightsUpload limited data into existing tablesManage panel size and visibilityAdjust and set defaults for various featuresView in-product helpView the FAQ for more information  Vantage Editor FAQWhat's New Latest release (01.00.01) contains several bug fixes including the following:VEDITOR-713: [Desktop] connections.yaml file not properly reading logonMechanism if directory created in advanceVEDITOR-658: Vantage Editor Desktop needs to work offlineVEDITOR-736: Editor is returning large decimal values that are rounded.VEDITOR-671: [Tech Spike] Request to output byte types values without converting them to integersVEDITOR-721: [tech spike] Investigate issue with changing timestamp  

Version: - Created: 16 May 2023

Teradata AI Unlimited CTL Teradata AI Unlimited CTL provides a command prompt interface to work with AI unlimited workspaces to manage projects and infrastructure. Project management: Create project List project Delete project List project users Create project object store authorization List project object store authorizations Delete project object store authorization Backup objects definitions created for the project work Restore objects definitions created for the project work Infrustructure management: Project engine deploy Project engine suspend Project engine list

Version: - Created: 20 Apr 2023

Visit the landing page for more information including sample notebooks, video clips and more ... Teradata Join the community discussion at Community Home - Community - Ecosystem Management Forum, topic: Jupyter Note: The docker image is also available on Docker Hub https://hub.docker.com/r/teradata/ai-unlimited-jupyter   Teradata AI Unlimited Jupyter Teradata AI Unlimited Jupyter provide extensions to the JupyterLab platform to enhance the user experience connecting, orchestrating and executing SQL statements on Teradata AI Unlimited . These extensions include the Teradata SQL Kernel, Navigator and Connection Manager. In addition, in the Docker image, we have bundled the Teradata driver for Python and teradataml library as well as the Teradata driver for R and tdplyr library. The teradataml and tdplyr libraries contain the analytic functions that interact with Teradata in the Python and R languages respectively. The SQL Kernel Provides: Teradata AI Unlimited orchestration and management of the projects and engines using custom magic commands Integration with Github to support project execution Connection management to add, remove, connect, and list connections Query engine that uses embedded Teradata SQL driver SQL aware notebook with SQL content assist and syntax checking Result set renderer that displays result data in easy to read, scrollable grid Execution history that stores execution metadata to recall SQL commands at a later time Visualization using Vega library to display charts, graphs, plots, etc. Support for basic data load from a file  Preference settings allow users to modify logging options for the SQL kernel Magic commands that provide additional custom kernel options to enhance the Teradata user experience The Navigator Provides: The ability to explore the Advanced SQL Engine catalog, regardless of the language you are using in your notebook (SQL, Python, R). Hierarchical display of SQL object-relational model Column metadata showing data type and indexes Row Count, Show DDL, Refresh, Sample Data, Profiling Information, and Column Distribution menu options The Connection Manager Provides: Connection management to add, remove, edit, copy, list, and test connections User interface that is independent of the SQL notebook Connections that are shared with the Navigator and SQL notebooks

Version: 20.00.03.00 - Created: 06 Oct 2022

TTU macOS Package This Teradata Tools and Utilities (TTU) 20.00 package is the full collection of Teradata client tools for macOS. This includes load & unload utilities, open interfaces and drivers to be used to connect to your Teradata Advanced SQL (database) instance.  Installation is easy and simple.  The size of the download zip file is ~50 MB.   For feedback, discussion, and community support, please visit the Tools forum. For Vantage Desktop Editor FAQ's please visit FAQ's.