Oracle to Oracle ETL PL/SQL vs SSIS

• baal32

  SSC-Addicted

  Points: 425

  More actions

  March 21, 2009 at 8:55 pm

  #207619

  We started exploring SSIS (2008) to do some Oracle to Oracle (10gR2) ETL but some of our developers are really pushing for us to use PL/SQL for all of the transformations, claiming that the performance must be better. I really enjoy SSIS and I'm hoping there are some points I can make in favor of continuing to use it. If its a consideration, we are also using SSRS for reporting... Can any Sql Server evangelists give me some good talking points or should I just suck it up and brush off my PL/SQL reference guide?

• sandhya_vemulla

  Say Hey Kid

  Points: 696

  More actions

  April 15, 2009 at 8:52 am

  #978142

  PL/SQL would be much faster

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  April 17, 2009 at 10:08 am

  #979783

  I would go with PL/SQL, it is simple to manage...

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers

  
  

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  April 21, 2009 at 1:52 pm

  #981761

  plenty of good reasons to use SSIS....might even consider using attunity's CDC for Oracle..

  http://www.attunity.com/change_data_capture_for_ssis

  Tommy

  Follow @sqlscribe

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  January 21, 2010 at 9:21 am

  #1106791

  baal32 (3/21/2009)

  ---

  Oracle to Oracle (10gR2) ETL

  Oracle to Oracle?

  Why would you want to add overhead?

  Use Oracle!

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.