SSIS Integration Services features supported by the editions of SQL Server (不同SQL Server版本SSIS支援的功能)

1.Standard Edition就有SSIS所有標準功能

2.Enterprise Edition的SSIS含有以下進階功能

(1)Integration Services - Advanced sources and destinations

• High-performance Oracle source and destination by Attunity
• High-performance Teradata source and destination by Attunity
• SAP BW source and destination
• Data mining model training destination
• Dimension processing destination
• Partition processing destination

(2)Integration Services - Advanced tasks and transformations

• Change Data Capture components by Attunity
• Data mining query transformation
• Fuzzy grouping and fuzzy lookup transformations
• Term extraction and term lookup transformations

(3)Scale Out Master

Integration Services features supported by the editions of SQL Server

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver15

SSIS (SQL Server Integration Service) support Database

SQL Server

安裝SQL Server預設會自動安裝Driver

或自行下載安裝

Download ODBC Driver for SQL Server 

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

Oracle

建議使用Oracle官方Driver

安裝Oracle Client 32bit for Visual Studio/SSMS

安裝Oracle Client 64bit for SQL Server Instance(Linked Server to Oracle)

Microsoft OLE DB Provider for Oracle (MSDAORA) for 64 bit?

https://blog.sqlauthority.com/2016/12/17/sql-server-download-microsoft-ole-db-provider-oracle-msdaora-64-bit/

1. MSDAORA is short form for “Microsoft OLE DB Provider for Oracle”.
2. MSDAORA is driver provided by Microsoft to connect to Oracle database server.
3. There is no 64-bit version provided by Microsoft for MSDAORA. Its only available for 32 bit.
4. MSDAORA is no longer supported by current versions of Oracle. It was last updated for Oracle 9, and is no longer being updated.
5. For 64 bit, we need to download and use the Oracle client and the provider from their site for connecting with SQL. Oracle has a 64-bit version that is usable for us.
6. Oracle is a provider which is supported by Oracle.

MySQL

Connect to a MySQL Data Source (SQL Server Import and Export Wizard)

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-mysql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15

Get the MySQL connectors

Download the providers and drivers described in this topic from the MySQL Connectors page.

MariaDB

MariaDB Connectors

https://mariadb.com/downloads/#connectors

PostgreSQL

Connect to a PostgreSQL Data Source (SQL Server Import and Export Wizard)

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-postgresql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15

Get the PostgreSQL ODBC driver

Install the ODBC driver with Stack Builder

Run Stack Builder to add the PostgreSQL ODBC driver (psqlODBC) to your installation of PostgreSQL.

Install PostgreSQL ODBC with Stack Builder

Or, download the latest ODBC driver

Or, download the Windows installer for the latest version of the PostgreSQL ODBC driver (psqlODBC) directly from this FTP site - https://www.postgresql.org/ftp/odbc/versions/msi/. Extract the files from the .zip file and run the .msi file.

Sybase

Sybase ASE/Sybase IQ

SAP SQL Anywhere Database Client Download

https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download

Users Guide

Adaptive Server® Enterprise

OLE DB Provider by Sybase 

15.7

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00075.1570/pdf/oledb.pdf

Connecting to SAP ASE (SybaseToSQL)

https://docs.microsoft.com/en-us/sql/ssma/sybase/connecting-to-sybase-ase-sybasetosql?view=sql-server-ver15

• Import and Export from SQL Server to Sybase DB using SSIS
• SSIS with Sybase Connectors
• connecting to Sybase from Sqlserver SSIS
• Extracting data from Sybase SQL Anywhere using SSIS through ODBC
• Powerful SAP Sybase ADO.NET driver

DB2

IBM Data Server Driver Package (DS Driver)

設定ODBC Data Source選擇IBM DB2 ODBC DRIVER -IBMDBCLI

10.5的32位元版本安裝檔檔名：ibm_data_server_driver_package_win32_v10.5.exe

10.5的64位元版本安裝檔檔名：ibm_data_server_driver_package_win64_v10.5.exe

或用

Microsoft OLE DB Provider for DB2 Version 6.0

https://www.microsoft.com/en-us/download/details.aspx?id=100917

Installing Data Provider Version 6.0

https://docs.microsoft.com/en-us/host-integration-server/db2oledbv/installing-data-provider-version-6-0

Creating a linked server to DB2 using Microsoft OLE DB provider for DB2

https://support.microsoft.com/en-us/help/222937/creating-a-linked-server-to-db2-using-microsoft-ole-db-provider-for-db