[SSIS]SSIS效能問題--Oarcle資料來源

摘要:[SSIS]SSIS效能問題--Oarcle資料來源如何解決

目前在使用SSIS轉拋Oarcle資料來源與目的地,資料量大約每次為百萬筆資料,

資料來源 : 使用OLE DB 當作資料來源

資料目的地 : 使用OLE DB 當作資料目的地

每次轉拋都要一小時左右

http://sharedderrick.blogspot.tw/2012/03/ssis-oracle-attunityoracle-client.html

想用以前的做法試試看

資料來源 : 使用OLE DB 當作資料目的地

資料目的地 : 緩時變為度

但似乎SSIS的緩時變為度不支援Oarcle連線

http://sharedderrick.blogspot.tw/2015/02/slowly-changing-dimension.html

 

因此想試試看

Microsoft Connectors by Attunity

Attunity's high speed connectors for Oracle and Teradata have been selected by Microsoft to be included with SQL Server 2008 Integration Services (SSIS). Included with SQL 2008 Enterprise Edition, these high speed connectors created by Attunity provide:

  • Optimized, best-in-class performance

The connectors deliver unparalleled throughput for extracting and loading data to and from Oracle and Teradata. Architected with Microsoft, the connectors use direct integration into internal SSIS buffering APIs, cutting through .NET and other layers, and also use the high speed load/extract utilities offered by Oracle and Teradata.

  • Ease-of-use

The connectors are fully integrated into the Business Intelligence Development Studio (BIDS), part of Microsoft Visual Studio 2008, offering a user experience similar to that of the SSIS generic OLEDB Connector, with intuitive capabilities including configuration, metadata browsing, and error routing.

The following diagrams provide an overview of the connectors’ architecture:

 

http://www.attunity.com/products/attunity-connect/ssis-connectors-for-oracle-and-teradata

 

Microsoft Connectors v3.0 for Oracle and Teradata 

for SQL Server 2014

http://www.microsoft.com/en-us/download/details.aspx?id=44582

Microsoft® Connectors v1.2 for Oracle and Teradata

for SQL Server 2008

https://www.microsoft.com/en-us/download/details.aspx?id=29284