Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle version of SQL Server DTS/ SSIS.

430270Dec 13 2006 — edited Dec 13 2006

Howdy all. Im starting to teach myself Oracle and have a couple of questions.

What is Oracles equivelant of SQL Servers DTS/ SSIS (ETL tool)? One of my hangups with SSIS (new to SQL Server 2005, replaced DTS in SQL Server 2000) is that it requires VB .net to accomplish certain things whereas DTS could use VB Script. That being said:

What lanuage(s) does Oracles ETL tool use when the GUI does not do what you need?

Are these tasks usually done by Developers or DBA's in the Oracle world. As a SQL Server DBA, I've done lots of these tasks throughout my career, but it seems as though MS is looking to redefine the lines between DBA and Developer (not just based on this, but other things as well).

TIA, ChrisR

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2007

Added on Dec 13 2006

#general-database-discussions

2 comments

2,088 views