SaaSipedia

SQL Server Integration Services

docs.microsoft.com/en-us/sql/integration-services
Data Integration
Weekend Project

A platform for building enterprise-level data integration and data transformations solutions

How to Replace SQL Server Integration Services
Compare:vs Censusvs LabArchivesvs Rivery

Overview

SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformation solutions. It enables organizations to solve complex business problems such as copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data. SSIS can extract and transform data from a wide variety of sources including XML data files, flat files, and relational data sources, then load the data into one or more destinations.

Features

12 features across 6 categories

Cloud Integration(1)

Azure Data Factory Integration Runtime

SSIS Integration Runtime in Azure Data Factory for cloud-based data integration

Also in: Traefik, Proofpoint, Wiz

Core Functionality(4)

Built-in Tasks and Transformations

A rich set of built-in tasks and transformations for data integration workflows

Data Extraction

Extract data from a wide variety of sources such as XML data files, flat files, and relational data sources

Data Loading

Load transformed data into one or more destinations

Data Transformation

Transform and cleanse data as part of the integration pipeline

Also in: Perforce Akana API Management Platform, BrightPay, Roam Research

Data Operations(3)

Data Cleansing and Mining

Cleanse and mine data as part of integration workflows

Data Warehouse Loading

Load data into data warehouses

File Copy and Download

Copy or download files as part of data integration processes

Also in: Ruler Analytics, Etleap

Development(1)

Programmatic Object Model

Extensive Integration Services object model to create packages programmatically and code custom tasks

Also in: Kissflow, Lattice, WordPress.com

Management(2)

SQL Server Object Management

Manage SQL Server objects and data

SSIS Catalog Database

A database to store, run, and manage packages

Also in: Kajabi, Lexion, Juro

User Interface(1)

Graphical Tools

Graphical tools for building packages without writing code

Also in: Zapier, BrightPay, GnuCash

Cost Calculator

Pricing data not available for SQL Server Integration Services. Check their website for current pricing.

Build vs Buy

Should you build a SQL Server Integration Services alternative or buy the subscription? Estimate based on 12 features.

Buy SQL Server Integration Services

Better Value
Monthly costContact Sales
3-year totalVaries
Time to deployDays

Build Your Own

Development cost$12,000
Maintenance$180/mo
3-year total$18,480
Dev time~1 months

Buying SQL Server Integration Services saves ~$18,480 over 3 years vs building.

Estimates based on 12 features and a BuildScore of 5/5. Actual costs vary.

Integrations

2 known integrations

Azure Data FactorySQL Server