Excel Integration

Microsoft's Excel is one of the most popular tools for data analysis and presentation. Recent releases have added more and more functionality to allow Excel to funciton as a business intelligence (BI) tool. Data can be analyzed within Excel using connections to data residing in a Teradata database.

It is easy and straight-forward to integrate Excel with the Teradata database through the Teradata ODBC driver and connection wizard (sets up connection). Teradata also provides a .NET Data Provider interface between Microsoft and Teradata. With this interface it is possible to run SQL queries and stored procedures from within Excel connected to a Teradata database and return those results to an Excel spreadsheet or .csv file.

Spotlight can assist with the integration of Excel-to-Teradata.
Copyright ©2013 Spotlight Technology, LLC
Teradata® is a registered trademark of Teradata Corporation
Other Legal Notices