摘要:[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