1. Microsoft Attunity Connector For Oracle
2. Microsoft Attunity Connector For Oracle Services

Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base. Attunity has supplied innovative software solutions to its enterprise-class customers for over 20 years and has successful deployments at thousands of organizations worldwide. Attunity provides software directly and indirectly through a number of partners such as Microsoft, Oracle, IBM and Hewlett Packard Enterprise.

APLICA-SE A: SQL Server, incluindo no Linux Banco de Dados SQL do Azure SQL Data Warehouse do Azure Parallel Data WarehouseAPPLIES TO: SQL Server, including on Linux Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

Observação

Os conectores Atunity para Oracle e Teradata dão suporte ao SQL Server 2017 e inferior.Atunity Connectors for Oracle and Teradata support SQL Server 2017 and below.

Para o SQL Server 2019, obtenha os conectores para o Oracle e Teradata mais recentes aqui: Microsoft Connector para OracleFrom SQL Server 2019, get latest connectors for Oracle and Teradata here: Microsoft Connector for Oracle

Você pode baixar os conectores para o Integration Services da Attunity que otimizam o desempenho ao carregar dados de ou para Oracle ou Teradata em um pacote do SSIS.You can download connectors for Integration Services by Attunity that optimize performance when loading data to or from Oracle or Teradata in an SSIS package.

Baixar os conectores Attunity mais recentesDownload the latest Attunity connectors

Obtenha a versão mais recente dos conectores aqui:Get the latest version of the connectors here:
Microsoft Connectors v5.0 para Oracle e TeradataMicrosoft Connectors v5.0 for Oracle and Teradata

Problema – os conectores da Attunity não estão visíveis na caixa de ferramentas do SSISIssue - The Attunity connectors aren't visible in the SSIS Toolbox

Para ver os conectores da Attunity na caixa de ferramentas do SSIS, sempre é necessário instalar a versão dos conectores que se destina à mesma versão do SQL Server que a versão do SSDT (SQL Server Data Tools) instalado em seu computador.To see the Attunity connectors in the SSIS Toolbox, you always have to install the version of the connectors that targets the same version of SQL Server as the version of SQL Server Data Tools (SSDT) installed on your computer.(Você também pode ter versões anteriores dos conectores instalados.) Esse requisito é independente da versão do SQL Server que você deseja usar como destino em seus pacotes e projetos do SSIS.(You may also have earlier versions of the connectors installed.) This requirement is independent of the version of SQL Server that you want to target in your SSIS projects and packages.

Por exemplo, se você instalou a versão mais recente do SSDT, você tem a versão 17 do SSDT com um número de build que começa com 14.For example, if you've installed the latest version of SSDT, you have version 17 of SSDT with a build number that starts with 14.Essa versão do SSDT adiciona suporte ao SQL Server 2017.This version of SSDT adds support for SQL Server 2017.Para ver e usar os conectores da Attunity no desenvolvimento de pacotes do SSIS – mesmo que você deseje usar uma versão anterior do SQL Server como destino – você também precisará instalar a versão mais recente dos conectores da Attunity, versão 5.0.To see and use the Attunity connectors in SSIS package development - even if you want to target an earlier version of SQL Server - you also have to install the latest version of the Attunity connectors, version 5.0.Essa versão dos conectores também adiciona suporte ao SQL Server 2017.This version of the connectors also adds support for SQL Server 2017.

Microsoft Attunity Connector For Oracle

Verifique a versão instalada do SSDT no Visual Studio de AjudaSobre o Microsoft Visual Studio ou em Programas e Recursos no Painel de Controle.Check the installed version of SSDT in Visual Studio from HelpAbout Microsoft Visual Studio, or in Programs and Features in the Control Panel.Em seguida, instale a versão correspondente dos conectores da Attunity da tabela a seguir.Then install the corresponding version of the Attunity connectors from the following table.

Baixar o SSDT (SQL Server Data Tools) mais recenteDownload the latest SQL Server Data Tools (SSDT)

Obtenha a versão mais recente do SSDT aqui:Get the latest version of SSDT here:
Baixar o SQL Server Data Tools (SSDT)Download SQL Server Data Tools (SSDT)

In one of our company meetings with Microsoft we were advised to use Microsoft SSIS Connectors by Attunity Version 4.0 if we extract data from Oracle. We used to extract the data from Oracle using Oracle Provider for OLE DB.

I have tried to install the recommended components without success. I have oracle clients 32 bits (ODTwithODAC122010.zip) and 64 bits (ODAC122010_x64.zip) installed and then I attempted to install SSIS Attunity Connectors as explained on this post. It's supposed that after the installation I would see the components on the SSIS toolbox (Data Flow section) but no matter what I do they simply don't show up.

I can successfully connect to oracle server using the component we have always used.

My SSIS projects target version is SQL Server 2016. Visual Studio 2015 Enterprise. My OS: Windows 10 Enterprise.

I tried to install v4 32-bit version of the attunity connector and it did not work, I also tried to install v3 64-bit version of the attunity connector and the installation failed because I don't have SQL Server 2014 installed only 2016, which is why I'm supposed to use v4 64-bits.

You can also try to extract the drivers from an existing system - there are a couple of freeware toolsto help you do this. Lenovo sccm driver packages. Using 7-zip won't help. Finally, you may end just having to install the drivers using the exe during the Windows portion of the TS similar to installing an application using a package.Jason @jasonsandys.

Microsoft Attunity Connector For Oracle Services

Any advice from anybody who had an issue like this before?

1 Answer

Stronghold crusader demo download. You need both x86 and x64 versions of the Oracle clients.And you should install both 4.0 and 5.0 x64 (x86 will be added automatically) versions of Attunity connectors.After that you should be able (almost guaranteed) to see Attunity connectors in the SSIS Toolbox in VS2015.

Hope this helps.

Not the answer you're looking for? Browse other questions tagged oraclevisual-studio-2015ssisattunityssis-2016 or ask your own question.