Database Query Utilities

Software implementations to connect to a database and read or modify the data stored in that database.

---

Teradata V13 and MS Excel 2010  |  Profile  |  SQLX  |  TeraSqlX  |  Utilities

---

Teradata V13 and MS Excel 2010

This utility provides a mechanism to connect to a Teradata database using ODBC and query the DBC.DBCInfo table. This program is written in Microsoft Excel 2010 Visual Basic for Applications.

Documentation	The documentation for the program.
Excel Macro Enabled Workbook	An Excel Macro Enabled Workbook containing the code for the program.

Profile

This utility provides a mechanism to connect to any ODBC database and profile (i.e., determine the unique values and frequency of occurance of each value) the data in all columns or a specified column in table. This program is written in Perl and requires the "Utilities" module to work.

Documentation	The documentation for the program.
Code	The code for the program.

SQLX

This utility provides a mechanism to connect to any ODBC database and execute an SQL statement. This program is written in Perl and requires the "Utilities" module to work.

Documentation	The documentation for the program.
Code	The code for the program.

TeraSqlX

This utility provides a mechanism to connect to a Teradata database using the .NET Data Provider for Teradata and execute an SQL statement. This program is written in PowerShell and requires the .NET Data Provider for Teradata.

Documentation	The documentation for the program including the source code.
.NET Data Provider for Teradata	The .NET Data Provider for Teradata.

Utilities

This is a Perl module that is required by many of the Perl programs provided on this site.

Documentation	The documentation for the program.
Code	The code for the program.