Archives of the TeradataForum

Message Posted: Wed, 14 Jan 2009 @ 14:55:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Assuming you have SSH access to the remote Oracle server:

1) SSH into Oracle UNIX server.

2) Use SQL*Plus to spool out the results you need to flat file(s).

3) SCP (SSH Copy) the file(s) to your local Linux environment.

4) Load them to Teradata using the appropriate load tool.

For good measure it may make sense to also generate a control file that contains the number of records and size of the flat file being transferred so you can compare it after it is copied to make sure it is not corrupt. You could also possiblly use an MD5 checksum as well.

Another option would be to have the Oracle client installed localling in your Linux environment so you could eliminate the SSH and SCP steps above. Beyond that, I would imagine a proper ETL tool would also allow for you to get data from the remote Oracle client to load into your local Teradata system.

Lastly, this is also assuming that any secure tunneling between your data center and the remote data center has been addressed.

Hope this helps.

	<Prev	Next>		<<First	<Prev	Next>	Last>>