AuthorityBase is an IT knowledgebase dedicated to the world of databses and RDBMS systems by David Yahalom. Here you'll find articles, tips and general knowledge about Oracle, DB2 LUW, Sql Server, MySql and more. I hope you'll enjoy your stay.
24th
JAN
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.
Recent Posts
- Hashing strings in Oracle 8i,9i,10g
- Started a new job!
- Migrating from SPARC to x86
- Show full process name / path / string in Solaris using ps
- Limelight
Categories
- DB2 LUW (11)
- ETL (2)
- General IT (5)
- Hardware (3)
- Linux (3)
- MySQL (1)
- Oracle (27)
- RAC (3)
- Security (3)
- Solaris (3)
- SQL Server (1)
- Uncategorized (1)
- Unix (2)
- Windows (1)
Archives
- November 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- October 2007
- September 2007
- July 2007
- June 2007
- April 2007
- March 2007
- February 2007
- January 2007
- March 2006
Blogroll
AuthorityBase by David Yahalom is powered by Wordpress. Designed by Free WordPress Themes.