SSIS Catalog

E307900

SQL Server feature SSIS management framework centralized SSIS repository

SSIS Catalog is a centralized SQL Server repository and management framework for deploying, storing, configuring, and monitoring SQL Server Integration Services (SSIS) projects and packages.

Try in SPARQL Jump to: Surface forms Disambiguation Statements Elicitation Referenced by

All labels observed (3)

Label	Occurrences
SSIS Catalog canonical	1
SSISDB	1
SSISDB database	1

How this entity was disambiguated

This entity first appeared as the object of triple T2880509 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.

NED1 Entity disambiguation (via context triple) gpt-5-mini-2025-08-07

Target entity: SSIS Catalog
Context triple: [SQL Server Integration Services, hasComponent, SSIS Catalog]

A. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
B. SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
C. SQL Server Analysis Services
SQL Server Analysis Services is a Microsoft server-based data analysis and business intelligence platform used to create and manage OLAP cubes and data mining models for advanced analytics and reporting.
D. SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
E. SQL Server Analysis Services Tabular
SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.
F. None of above. chosen
G. Unsure - the case is ambiguous/there is not enough information to decide.

NED2 Entity disambiguation (via description) gpt-5-mini-2025-08-07

Target entity: SSIS Catalog
Target entity description: SSIS Catalog is a centralized SQL Server repository and management framework for deploying, storing, configuring, and monitoring SQL Server Integration Services (SSIS) projects and packages.

A. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
B. SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
C. SQL Server Analysis Services
SQL Server Analysis Services is a Microsoft server-based data analysis and business intelligence platform used to create and manage OLAP cubes and data mining models for advanced analytics and reporting.
D. SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
E. SQL Server Analysis Services Tabular
SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.
F. None of above. chosen

Statements (52)

Predicate	Object
instanceOf	SQL Server feature ⓘ SSIS management framework ⓘ centralized SSIS repository ⓘ
allows	manual execution of SSIS packages ⓘ scheduling via SQL Server Agent jobs ⓘ
captures	data statistics for executions ⓘ event logs ⓘ execution messages ⓘ
createdBy	SSISDB creation wizard ⓘ
defaultDatabaseName	SSISDB ⓘ linked to: SSIS Catalog
developedBy	Microsoft ⓘ
exposedAs	SSISDB database ⓘ linked to: SSIS Catalog
integratesWith	SQL Server Management Studio ⓘ
introducedInVersion	SQL Server 2012 ⓘ linked to: SQL Server
monitors	execution performance counters ⓘ package execution status ⓘ
provides	built-in SSIS reports ⓘ centralized configuration ⓘ centralized deployment ⓘ centralized execution ⓘ centralized monitoring ⓘ logging of SSIS executions ⓘ rollback to previous project versions ⓘ versioning of deployed projects ⓘ
replaced	MSDB deployment model for SSIS ⓘ file system deployment model for SSIS ⓘ
requires	CLR integration enabled ⓘ SQL Server Agent for scheduling executions ⓘ SQL Server Integration Services feature ⓘ
runsOn	Microsoft SQL Server ⓘ linked to: SQL Server
schemaName	catalog ⓘ
securedBy	SQL Server database roles ⓘ linked to: SQLAgentUserRole SQL Server permissions ⓘ
stores	SSIS environment variables ⓘ SSIS environments ⓘ SSIS packages ⓘ SSIS projects ⓘ package parameters ⓘ project parameters ⓘ
supports	encryption of sensitive data ⓘ environment references ⓘ environment-level security ⓘ folder-level security ⓘ package-level configurations ⓘ parameter binding to environment variables ⓘ project deployment model ⓘ project-level configurations ⓘ project-level security ⓘ
uses	catalog stored procedures ⓘ catalog views ⓘ database master key for encryption ⓘ internal SSISDB schema ⓘ

How these facts were elicited

Referenced by (3)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server Integration Services → hasComponent → SSIS Catalog ⓘ

SSIS Catalog → exposedAs → SSISDB database ⓘ

linked to: SSIS Catalog

SSIS Catalog → defaultDatabaseName → SSISDB ⓘ