IBM Cloud Pak® for Data Version 4.8 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.
Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.
Microsoft SQL Server Integration Services connection
To access your data in Microsoft SQL Server Integration Services, you must create a connection asset for it.
Microsoft SQL Server Integration Services (SSIS) is a data integration platform.
Supported versions
- Microsoft SQL Server Integration Services for Microsoft SQL Server 2012 or later
Create a connection to Microsoft SQL Server Integration Services
To create the connection asset, you need the following connection details:
- Hostname or IP address
- Port number
- If the Microsoft SQL Server has been set up in a domain that uses NTLM (New Technology LAN Manager) authentication, select Use Active Directory. Then enter the name of the domain associated with the username and password
- SSL certificate (if required by the database server)
- Username and password
For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.
- In a catalog
- Click Add to catalog > Connection. See Adding a connection asset to a catalog.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add assets from the connection
- In a project, create and run a metadata import with the Import ETL job or the Get ETL job lineage goal to add assets to a catalog. See Importing ETL jobs and Getting ETL job lineage.
Where you can use this connection
You can use the Microsoft SQL Server Integration Services connection in the following workspaces and tools:
Projects
Metadata import (discovery) and metadata import (lineage) (IBM Knowledge Catalog) Advanced metadata import must be enabled. For lineage imports, a MANTA Automated Data Lineage license key must be installed. See Installed features and license requirements and Enabling lineage import.
Catalogs
- Platform assets catalog
- Other catalogs (IBM Knowledge Catalog) for access to the assets added through metadata import
Federal Information Processing Standards (FIPS) compliance
The Microsoft SQL Server Integration Services connection cannot be created in a FIPS environment.
Microsoft SQL Server Integration Services setup
Restrictions
You can use this connection only for source data. You cannot write to data or export data with this connection.
Supported file types
The Microsoft SQL Server Integration Services connection supports importing ETL job information.
Learn more
SQL Server Integration Services
Parent topic: Supported connections