Optimized Bulk Loading of Data into Oracle

יום שישי, יוני 21, 2013

SQL Server 2008 and SQL Server 2008 R2 (Enterprise and Developer editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise and non-Developer editions of SQL Server 2008 and 2008 R2, there are alternatives for achieving optimal performance when loading Oracle data. This paper discusses these alternatives.The Enterprise and Developer editions of SQL Server 2012 also support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. To review the document, please download the Optimized Bulk Loading of Data into...
תגיות: , , , ,
אין תגובות

BI חומרים נוספים ללימוד

יום שישי, מרץ 25, 2011

  בנוסף לבלוגים קריאת ספרים וגוגלינג, תוכלו למצוא חומרים מעניינים גם ב TECNET ובMSDN- ריכזתי כאן מספר לינקים שיקצרו לכם את זמן ההגעה. SSAS - Multidimensional Data http://msdn.microsoft.com/en-us/sqlserver/cc510300.aspx SSAS - Data Mining http://technet.microsoft.com/en-us/sqlserver/cc510301.aspx PowerPivot for Excel http://technet.microsoft.com/en-us/bi/ff604673.aspx  
תגיות: , , ,
אין תגובות

Oracle Driver Installation for SSIS 2008 R2

יום ראשון, ינואר 16, 2011

  If your SSIS server will require access to  Oracle DB you can find interest in this blog. You must still request access and provide valid credentials to access the information on the Oracle warehouse. This section only instructs how to install and configure the Oracle driver for connectivity. Preparing for the Installation Download the Oracle client to your server’s local C:\ drive, use the table below to determine which installations or additional downloads you must perform. For x64 systems you MUST download BOTH clients and install BOTH clients starting with x86 first then x64. ...
9 תגובות