Servers

    Microsoft Connectors v2.0 for Oracle and Teradata

    Language:
    English
    Download the SSIS Connectors v2.0 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2012.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      2.0

      File Name:

      AttunitySSISOraAdaptersSetup.msi

      AttunitySSISOraAdaptersSetupX64.msi

      AttunitySSISTeraAdaptersSetup.msi

      AttunitySSISTeraAdaptersSetupX64.msi

      Date Published:

      4/3/2012

      File Size:

      2.3 MB

      3.9 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”.
    • Supported Operating System

      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)

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

       Download a free trial of SQL Server 2014.
    SQL Server 2014
    Faster transactions, faster queries, and faster insights.
    Free trial