Trace Id is missing

Unlock your potential with Microsoft Copilot

Get things done faster and unleash your creativity with the power of AI anywhere you go.
Download the Copilot app
Microsoft Copilot app being utilized to generate pictures of a singing dog, assisting to identify a flower, and helping to generate an email to congratulate a coworker on a promotion.

Microsoft Connectors v2.0 for Oracle and Teradata

Download the SSIS Connectors v2.0 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2012.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    2.0

    Date Published:

    4/27/2017

    File Name:

    AttunitySSISOraAdaptersSetup.msi

    AttunitySSISOraAdaptersSetupX64.msi

    AttunitySSISTeraAdaptersSetup.msi

    AttunitySSISTeraAdaptersSetupX64.msi

    File Size:

    2.3 MB

    4.0 MB

    2.8 MB

    5.0 MB

    Microsoft Connector Version 2.0 for Oracle by Attunity - The Oracle source and destination components are written to achieve optimal performance when loading data into Oracle or unloading data from Oracle in the context of Microsoft SSIS.

    Microsoft Connector Version 2.0 for Teradata by Attunity - The components are written to achieve optimal performance when loading data into Teradata or unloading data from Teradata in the context of Microsoft SSIS.

    Microsoft SSIS Connectors by Attunity Version 2.0 is a minor release. It supports SQL Server 2012 Integration Services and includes bug fixes and support for updated Oracle and Teradata product releases.

    The following enhancements were made:
    • Oracle Enhancement - LOB Support
    • Support was added for the following Oracle LOB types: CLOB, NCLOB and BLOB. These LOB types are supported by the Oracle Source component and the Oracle Destination component in array load mode.
    • Oracle and Teradata Bug Fixes – Some hot key issues were fixed in the Oracle and Teradata connectors UI.
    • Oracle and Teradata Bug Fixes – Localization issues were fixed in the Oracle and Teradata connectors.
    • Teradata Enhancement - Support for TPT API 14.0 and TPT API 13.10.
    • Support was added for Teradata 13.10 and Teradata 14.0 by supporting TPT API version 13.0 and TPT API version 14.0 (14.00.00.02 or higher). Previous versions of the TPT API are still supported.
    • Teradata Enhancement - Starting from Teradata 13.0 Teradata database supports DDL with no primary index which was introduced specifically for loading data faster into Teradata; these tables were not listed in the table dropdown list.
    • Teradata Bug Fix - Teradata DDL supports column names being reserved words. Teradata Connector could not work with tables having such columns.
    • Teradata Bug Fix - Teradata destination component failed to read problematic rows from the error table with the following error: “Errors while trying to read error tables. Invalid TPT operator”.
    • Oracle and Teradata Bug Fix - Msi is unable to be installed in quiet (no UI) mode because it always has a dialog popping up.
      Add the following property for Oracle and Teradata connectors to suppress it: RestartSqlServerSilent=true
      For example: msiexec -i AttunitySSISOraAdaptersSetupX64.msi RestartSqlServerSilent=true /quiet /qn

  • Supported Operating Systems

    Windows 7, Windows Server 2008, Windows Server 2008 R2, Windows Vista

    • Required operating environment : Enterprise or Developer edition of SQL Server 2012 Integration Services
    • Supported Oracle databases : Oracle 9.2.0.4 and higher; Oracle 10.x; Oracle 11.x

    • Supported Teradata databases : Teradata Database version 2R6.0; Teradata Database version 2R6.1; Teradata Database version 2R6.2; Teradata Database version 12.0; Teradata Database version 13.0; Teradata Database 13.10; Teradata Database 14.0

    • Download the appropriate file by clicking the correct DOWNLOAD button as outlined below, then run the downloaded file to install that package.

    • Microsoft Connector Version 2.0 for Oracle
      The Microsoft Connector for Oracle is a set of managed components for transferring data from or to an Oracle database. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2012 Integration Services and will only operate in those environments. To install the component, run the platform-specific installer for x86 or x64 computers respectively. Read the installation topic in the Help file for installation prerequisites and additional information.

      X86 Package (AttunitySSISOraAdaptersSetup.msi)
      X64 Package (AttunitySSISOraAdaptersSetupX64.msi)

    • Microsoft Connector Version 2.0 for Teradata
      The Microsoft Connector for Teradata is a set of managed components for transferring data from or to Teradata database. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2012 Integration Services and will only operate in those environments. To install the component, run the platform-specific installer for x86 or x64 computers respectively. Read the installation topic in the Help file for installation prerequisites and additional information.

      X86 Package (AttunitySSISTeraAdaptersSetup.msi)
      X64 Package (AttunitySSISTeraAdaptersSetupX64.msi)
Follow Microsoft
Back To Top