Using Excel/ODBC to create object in Teradata?

[wcassell]

We are moving from an Oracle DB to Teradata. In the past we have used Excel (connected to Oracle) for many of our reports. I've written macros before that use OO4E to create (or replace) views in Oracle based on the date range that a user selects in Excel. The view is then selected and the results are brought back to Excel.

Does anyone know if there is similar functionality available for Teradata? Would it be through ODBC or direct connect? I'd really like to be able to generate and run code through Excel.

Thanks

 

[dnoeth]

I use ODBC to access Teradata from within Excel.
The demo version includes an "Excel Sample Query" in
Teradata for Microsoft Windows Demo -> Sample Applications

Btw, there's no need to create a view before selecting it, just submit the query or maybe create a macro which accepts the date range as parameters.

Dieter