Microsoft SQL Server Integration Services (SSIS)

URI: https://gptkb.org/entity/Microsoft_SQL_Server_Integration_Services_%28SSIS%29
GPTKB entity
Statements (56)
Predicate Object
gptkbp:instance_of gptkb:software
gptkbp:bfsLayer 5
gptkbp:bfsParent gptkb:Info_Sphere_Data_Stage
gptkbp:can_be SSIS packages
gptkbp:can_be_extended_by custom components
gptkbp:can_be_used_with gptkb:Power_BI
gptkbp:connects various data sources
gptkbp:deployment gptkb:Azure_Data_Factory
gptkb:Cloud_Computing_Service
gptkbp:developed_by gptkb:Microsoft
https://www.w3.org/2000/01/rdf-schema#label Microsoft SQL Server Integration Services (SSIS)
gptkbp:includes data flow
control flow
gptkbp:integrates_with gptkb:Cloud_Computing_Service
gptkbp:intelligence gptkb:SQL_Server_Agent
gptkbp:is_integrated_with gptkb:Microsoft_Dynamics
gptkbp:is_used_for business intelligence
data migration
generate reports
automate data workflows
create data pipelines
monitor data flows
transform data formats
implement data governance
migrate data between systems
schedule data tasks
gptkbp:latest_version gptkb:2019
gptkbp:provides data lineage tracking
data transformation capabilities
data visualization tools
error handling
metadata management
package management
data profiling tools
performance tuning options
logging features
user interface for package design
gptkbp:released April 2005
gptkbp:supports gptkb:language
ETL processes
ODBC
XML data
data synchronization
data validation
data warehousing
data cleansing
data archiving
data extraction
cloud data sources
data federation
real-time data integration
data quality services
data integration scenarios
flat files
OLEDB
gptkbp:uses Visual Studio for development