DTS in Oracle

Posted by David Yahalom under ETL, SQL Server, Oracle

If you are an SQL Server DBA you are probably well aware of the power and simplicity of Microsoft’s DTS.

DTS stands for Data Transformation Services and is a part of SQLServer 2000 Enterprise Edition (also called Data Integration Services in SQLServer 2005).

DTS is a powerful and simple to use ETL engine making complex data transformations jobs about as easy as using a mouse. I found myself using DTS almost exclusively everyime I had to move data between different database vendors. There are other, more complex and powerful packages (such as IBM’s DataStage), but because DTS is bundled with SQLServer 2000 EE it was always the most accessible tool for me.

Many DBAs are unaware that Oracle also has a very good ETL package called “Oracle Wearhouse Builder“. I have seen many DBAs installing SQLServer in a strict Oracle environment solely for the purpose of using DTS. If you qualify as one, have a look at Oracle Warehouse builder first as it just might suite your needs.

For more details.