I am looking to set up an ODBC driver for Teradata. Due to operational regulations, we are unable to use the Parallel Teradata stage as it creates temporary files for inserts, and the batch users that are set up cannot be granted create table permissions. Due to further operational regulations, the use of the bulk load facilities (Fastload, Multiload) has substantial scheduling overheads imposed, adding considerably to implementation costs.
Therefore,
How do I set up the Teradata ODBC stage for light weight projects?
Any help is appreciated
Teradata v2R5 ODBC driver
Moderators: chulett, rschirm, roy
Hi ,
you must have the necessary privileges like create table, insert, delete, select ON devserver TO orchclient user is Terradata Enterprise Stage basic configuration . We can't control.
if you want to use Terradata ODBC may impact performance. you may use dynamic RDBS stage ( select DBMS type ODBC).
You need to setup ODBC drivers by using Teradata Utilities
Cheers,
Krish
you must have the necessary privileges like create table, insert, delete, select ON devserver TO orchclient user is Terradata Enterprise Stage basic configuration . We can't control.
if you want to use Terradata ODBC may impact performance. you may use dynamic RDBS stage ( select DBMS type ODBC).
You need to setup ODBC drivers by using Teradata Utilities
Cheers,
Krish