| Author |
Topic |
|
manusid
Starting Member
5 Posts |
 Posted - 2009-04-01 : 11:02:33
|
| I am going to get daily feed from teradata . I have to load that in sql 2000 tables every morning using sql 2000 DTS. Can anyone please guide me that how I can laverage the power of SQL 2000 DTS to connect to Terada EDW.I have searcched a lot buut I am not able to get a way out to use DTS to get data out from Teradata on daily basis.Please your direction will be of great help. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 11:19:08
|
| Try some of these results:http://www.google.com/search?q=teradata+oledb+providerSince you say you're "getting a feed" it sounds like they're exporting data to text files and sending them to you. These are easy to import using DTS as long as the format is plain flat text like comma-separated or tab-separated values.If you need to connect to Teradata directly, you'll want an OLE DB data provider for Teradata, which is available in the first link of the Google results. |
 |
|
|
manusid
Starting Member
5 Posts |
Posted - 2009-04-01 : 11:24:22
|
| Sorry for the misunderstanding.I am not getting feed. I have to make connection from sql 2000 to teradata edw using dts.I have to schedule the process on daily basis to pull out data from teradata edw.please throw some more light that is it feasible or can you please suggest bets option how I can get the data from teradata to sql 2000 tables. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 12:11:58
|
| Download the OLE DB provider and install it on your SQL Server, and also your development machine. You'll have to get the Teradata connection info from whoever is managing that server (server name, login and password, etc.)DTS is fairly straightforward to use, I'd recommend reading Books Online and doing some tests. Teradata shouldn't function any differently than any other OLE database source. I can't help with the actual transformations since I don't know your data, but it should be easy to figure out.Once you get your DTS package working like you want, you can schedule it by right-clicking the package and choosing the Schedule Package option. |
|
|
|
manusid
Starting Member
5 Posts |
Posted - 2009-04-01 : 12:16:13
|
| Thanks a lot to share about this.Actually i am sql 2000 developer and I can create DTS.Infact i have already tried to install teradata ODBC but when I try to use that teradata odbc drivers i doesnot open the connection and takes hours to open. have you experience using dts to get data from teradata.if you can throw some more light that will be great.highly apprecaited. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 13:27:10
|
| I've never used Teradata. I would suggest using OLEDB instead of ODBC though, it will likely be faster and have more options. Any other connection issues will have to be addressed to the people who maintain the Teradata server.Sorry I can't be more help. |
|
|
|
manusid
Starting Member
5 Posts |
Posted - 2009-04-01 : 13:55:05
|
| Thanks a lot once gain to share but do you have idea if i install the OLEDB you mentioned will be sufficient along with the teradata server details .actually I have oracle client 9i odbc also installed and when I tried to install the OLEDB or odbc drivers for teradata it overwrites and creates problem for the oracle drivers.according to you if i install the oldedb driver and create a connection with teradata , that should work right! |
|
|
|
manusid
Starting Member
5 Posts |
Posted - 2009-04-01 : 13:56:36
|
| Thanks a lot once gain to share but do you have idea if i install the OLEDB you mentioned will be sufficient along with the teradata server details .actually I have oracle client 9i odbc also installed and when I tried to install the OLEDB or odbc drivers for teradata it overwrites and creates problem for the oracle drivers.according to you if i install the oldedb driver and create a connection with teradata , that should work right! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 15:13:57
|
| I don't know why it would interfere with Oracle drivers. My suggestion would be to check the Teradata support forums, or email their support line.I assume the Teradata server is being managed by someone, have you tried contacting them? |
|
|
|
|
Loading data in sql 2000 from Teradata using sql 2