Related to Data Extraction.....

Connectivity
Enthusiast

Related to Data Extraction.....

Hi All,

i want to know how can i extract data from teradata into CSV files. i want know any of such tool available in market?

Thanks & Regards,
Dinesh
3 REPLIES
Max
Enthusiast

Re: Related to Data Extraction.....

Hi

I believe (I can't nconnect to a Teradata Db yet!) you can do it using Teradata SQL Assistant...

In the menu Tools=>Option You can select "Write all export answer to a single file", and choose which "delimeter between columns in Export/Import files"...like semicolon ( ;-)

I hope it helps you...

Massimiliano
Enthusiast

Re: Related to Data Extraction.....

Assuming this is something you are going to do repeatedly,
There are three ways I have done this. The first is use a SQL statement that creates the correctly formatted string for each record,

SELECT '"'||
char_column||
'",'||
char_column2|| (or cast some other data type into a char or varchar
'"'
FROM table

You can run this in SQL Assistant (and export it), Fast Export or BTEQ.
The other way is to use OLE_LOAD to setup an export to a set of files that act like tables using the Jet driver. See the Microsoft site on how to do that. It can take a bit of time to get right, but it does do the job.
Lastly, for really complex jobs, write a quick program and use the .NET provider or ODBC provider.

R
Enthusiast

Re: Related to Data Extraction.....

As well try to use Fastexport,if data is really huge and you need scheduled jobs to do this.