Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Note
Attunity Connectors for Oracle and Teradata support SQL Server 2017 and below.
From SQL Server 2019, get latest connectors for Oracle and Teradata here:
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.
Get the latest version of the connectors here:
Microsoft Connectors v5.0 for Oracle and Teradata
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. (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.
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. This version of SSDT adds support for SQL Server 2017. 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. This version of the connectors also adds support for SQL Server 2017.
Check the installed version of SSDT in Visual Studio from Help | About Microsoft Visual Studio, or in Programs and Features in the Control Panel. Then install the corresponding version of the Attunity connectors from the following table.
SSDT version | SSDT build number | Target SQL Server version | Required version of Connectors |
---|---|---|---|
17 | Starts with 14 | SQL Server 2017 | Microsoft Connectors v5.0 for Oracle and Teradata |
16 | Starts with 13 | SQL Server 2016 | Microsoft Connectors v4.0 for Oracle and Teradata |
Get the latest version of SSDT here:
Download SQL Server Data Tools (SSDT)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Learning path
Data integration at scale Azure Data Factory - Training
Data integration at scale with Azure Data Factory or Azure Synapse Pipeline
Certification
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.