Regarding Data Extraction.......

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Regarding Data Extraction.......

Rate Topic

Display Mode

Topic Options

Author

Message

lokhande.dinesh29

Posted 6/7/2007 11:00:04 AM

Junior Member

Group: Forum Members
Last Login: 11/2/2007 2:04:32 AM
Posts: 14, Visits: 11

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

Post #7772

Daniel Giabbai

Posted 6/13/2007 7:28:24 AM

Supreme Being

Group: Forum Members
Last Login: 7/22/2008 3:48:36 AM
Posts: 173, Visits: 5

Besides some Teradata PS offer solutions, the market offers a plethora of ETL tools to do the job.
Look for Oracle Data Integrator (former Sunopsis), Informatica, IBM WebSphere DataStage (former Ascential Datastage) to name a few.

Post #7848

Vincent McBurney

Posted 6/14/2007 9:51:15 PM

Junior Member

Group: Forum Members
Last Login: 4/22/2008 1:21:41 AM
Posts: 11, Visits: 12

There are some Teradata utilities for exporting data such as BTEQ or Fast Export.

In addition to expensive ETL tools like DataStage and Informatica you can also go with free or cheap open source ETL tools that can pull data from a Teradata ODBC or JDBC connection write it to whatever flat file format you need. You can at a pinch pull data into Excel via an ODBC link and save it as CSV. The trick is convincing the administrators of the database that you need a connection to pull data off since they don't like unauthorised extracts.

Here are some open source ETL tools, they wont be as fast or easy to use as a premium ETL tool but for a small number of extracts they offer good value:
Ketl
CloverETL
Enhydra Octupus
Talend
Pentatho Data Integration (Kettle)

Vincent McBurney
blogs.ittoolbox.com/bi/websphere

Post #7884

lokhande.dinesh29

Posted 6/15/2007 1:58:19 AM

Junior Member

Group: Forum Members
Last Login: 11/2/2007 2:04:32 AM
Posts: 14, Visits: 11

Thanks for such a valuable reply

Post #7889

Gruutal

Posted 2/20/2009 11:31:20 AM

Junior Member

Group: Forum Members
Last Login: 9/25/2009 5:20:08 AM
Posts: 14, Visits: 16

Hi,

I would suggest you look at Kettle and Talend. I tend to enjoy both programs, even though I like a lot Talend. With Talend you can extract data from teradata into CSV files but you can also import data into mysql, do data integration, migration or even deduplication. Go on the Talend wesite and try Talend Open Studio. http://www.talend.com/

Talend, Open source data Integration software

Post #14524

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 9:25pm