List of Microsoft SQL Server Integration Services (SSIS) Customers
Redmond, 98052-6399, WA,
United States
Since 2010, our global team of researchers has been studying Microsoft SQL Server Integration Services (SSIS) customers around the world, aggregating massive amounts of data points that form the basis of our forecast assumptions and perhaps the rise and fall of certain vendors and their products on a quarterly basis.
Each quarter our research team identifies companies that have purchased Microsoft SQL Server Integration Services (SSIS) for Analytics and BI from public (Press Releases, Customer References, Testimonials, Case Studies and Success Stories) and proprietary sources, including the customer size, industry, location, implementation status, partner involvement, LOB Key Stakeholders and related IT decision-makers contact details.
Companies using Microsoft SQL Server Integration Services (SSIS) for Analytics and BI include: The University of Manchester, a United Kingdom based Education organisation with 12800 employees and revenues of $1.87 billion, AltaMed, a United States based Healthcare organisation with 5700 employees and revenues of $1.80 billion, Kfc South Africa, a South Africa based Leisure and Hospitality organisation with 20000 employees and revenues of $400.0 million, Total Terminals International, a United States based Transportation organisation with 150 employees and revenues of $32.0 million, Canada Post Corporation, a Canada based Professional Services organisation with 7 employees and revenues of $1.0 million and many others.
Contact us if you need a completed and verified list of companies using Microsoft SQL Server Integration Services (SSIS), including the breakdown by industry (21 Verticals), Geography (Region, Country, State, City), Company Size (Revenue, Employees, Asset) and related IT Decision Makers, Key Stakeholders, business and technology executives responsible for the software purchases.
The Microsoft SQL Server Integration Services (SSIS) customer wins are being incorporated in our Enterprise Applications Buyer Insight and Technographics Customer Database which has over 100 data fields that detail company usage of software systems and their digital transformation initiatives. Apps Run The World wants to become your No. 1 technographic data source!
Apply Filters For Customers
| Logo | Customer | Industry | Empl. | Revenue | Country | Vendor | Application | Category | When | SI | Insight |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
AltaMed | Healthcare | 5700 | $1.8B | United States | Microsoft | Microsoft SQL Server Integration Services (SSIS) | Analytics and BI | 2018 | n/a |
In 2018 AltaMed implemented Microsoft SQL Server Integration Services (SSIS) within its Analytics and BI environment to centralize ETL and support enterprise reporting. The deployment was executed by the Database Administration and Enterprise Data Analytics teams in Monterey Park, focused on on-premise operational data stores and reporting databases. The initiative targeted delivery of managerial strategies and consolidated KPIs to clinical and administrative leadership.
SSIS was administered alongside BCP, PowerShell, and Python ETL processes to construct package orchestration, data cleansing, bulk load operations, scheduled extractions, and transformation workflows. Functional capabilities included SSIS package development, complex SQL stored procedures, and performance tuning using SQL Profiler. Output feeds were directed to SSRS and Tableau for analytic consumption and operational dashboards.
The implementation integrated monitoring and database performance tooling such as SentryOne, IDERA, and SolarWinds, and used TFS for source control and release deployments. Replication and disaster recovery strategies were implemented for on-premise databases, and SSIS packages were incorporated into 24x7 support runbooks and rotating on-call schedules. Operational coverage spanned IT infrastructure, application areas supported by database systems, and enterprise analytics functions.
Governance followed formal systems development life cycle processes, with change controls, scheduled patching, backups, purges, and end-user training programs. Project governance included planning, resource allocation, conflict resolution, and reporting led by the Sr. Database Administrator, with TFS-based versioning and controlled release deployments. Workflows were structured to enforce HIPAA compliance for protected health information during development and operations.
The SSIS implementation enabled centralized delivery of analytic reports and compliance factors, supporting management decision making through SSRS and Tableau outputs. Ongoing responsibilities included routine maintenance, tuning, and operational support by the Database Administration and Enterprise Data Analytics teams. AltaMed Microsoft SQL Server Integration Services (SSIS) Analytics and BI implementation established the core ETL orchestration for enterprise reporting and data integration.
|
|
|
Canada Post Corporation | Professional Services | 7 | $1M | Canada | Microsoft | Microsoft SQL Server Integration Services (SSIS) | Analytics and BI | 2012 | Innovapost |
In 2012, Canada Post Corporation deployed Microsoft SQL Server Integration Services (SSIS) as part of an Analytics and BI initiative to operationalize enterprise ETL for reporting and analytics. Innovapost designed and built a scale out SSIS solution for Canada Post, explicitly documented in the Microsoft SSIS case note, to handle large daily data workloads reported at approximately 10 to 15 GB per day.
The implementation focused on data warehousing and ETL functions, with SSIS packages responsible for data collection, cleansing, transformation, and automated distribution. Microsoft SQL Server Integration Services (SSIS) was used to orchestrate batch ingestion, apply deterministic cleansing logic, and populate downstream reporting datasets to support both operations and analytics use cases.
Integrations centered on delivering curated datasets into Canada Post enterprise reporting and analytics infrastructure across Canada, with automated delivery pipelines scheduled to run against daily source extracts. Innovapost acted as the systems integrator and implementation partner, configuring the SSIS scale out architecture to support parallelism and operational scheduling.
Governance emphasized operationalization of automated data distribution and repeatable ETL workflows, with SSIS package orchestration and scheduled execution forming the core of rollout and ongoing operations. The engagement delivered automated data distribution at scale and is recorded in the Microsoft SSIS blog case note, which documents the technical approach and implementation details.
|
|
|
Kfc South Africa | Leisure and Hospitality | 20000 | $400M | South Africa | Microsoft | Microsoft SQL Server Integration Services (SSIS) | Analytics and BI | 2015 | Prosys Infotech |
In 2015, Kfc South Africa implemented Microsoft SQL Server Integration Services (SSIS) as the ETL backbone of a Microsoft BI solution delivered by Prosys Infotech. The deployment centralized ingestion of transactional point of sale POS data from more than 900 restaurants into a relational data warehouse to enable Analytics and BI for sales and operations analytics across KFC Africa.
The implementation combined Microsoft SQL Server Integration Services (SSIS) for ETL, SQL Server Analysis Services tabular modeling for the semantic layer, and Power BI for visualization and reporting, ensuring an end to end Microsoft BI stack. SSIS packages orchestrated extraction, transformation, and load workflows, and incorporated data validation and cleansing routines to improve data accuracy and to support automated report generation.
Integrations were focused on transactional POS feeds from 900 plus restaurant sites into the relational data warehouse, with SSIS coordinating scheduled load pipelines and processing across the region. Operational coverage targeted store level reporting and regional rollups, enabling analysts and operations teams to consume unified store performance metrics via Power BI dashboards.
Prosys Infotech is documented as the implementation partner responsible for delivery and BI configuration. The solution produced a 360 degree view of store performance and improved data accuracy and reporting automation for Kfc South Africa.
|
|
|
The University of Manchester | Education | 12800 | $1.9B | United Kingdom | Microsoft | Microsoft SQL Server Integration Services (SSIS) | Analytics and BI | 2020 | n/a |
In 2020, The University of Manchester deployed Microsoft SQL Server Integration Services (SSIS) as part of its Analytics and BI environment, initiating a program to migrate significant integration workloads from IBM webMethods (formerly Software AG) to SSIS. The University implemented SSIS to support structured ETL processing and orchestration while retaining a mixed integration estate during transition, aligning SSIS with the institution's IT Services priorities for staff, students, and research data flows.
The Microsoft SQL Server Integration Services (SSIS) implementation focused on package-based ETL, scheduled workflow orchestration, SQL connectivity and API invocation patterns consistent with Analytics and BI practices. Configurations emphasized SSIS packages, data flow tasks, control flow orchestration and source control practices, and the implementation accommodated both batch and near real-time processing scenarios commonly required by university reporting and administrative systems.
Operational coverage encompassed the Integration Delivery Team within IT Services that manages over 800 integration jobs, supporting interfaces to core internal and external systems. Integrations maintained or transitioned included Web Service, SQL, API and file-based transports, and interoperated with Oracle and MSSQL sources noted in team requirements, while coexisting with webMethods and Calopus tools during staged cutover and ongoing BAU support.
Governance and process changes centered on establishing an Integration Centre of Excellence to codify architectural principles, systems standards, process flow, governance and BAU service design standards for Analytics and BI integration work. The program included documented design and build practices, training and upskilling plans for a future consolidation of the integration platform, and a stated intention to finalize a new integration platform by the end of 2023.
|
|
|
Total Terminals International | Transportation | 150 | $32M | United States | Microsoft | Microsoft SQL Server Integration Services (SSIS) | Analytics and BI | 2021 | Jade Global |
In 2021, Total Terminals International engaged Jade Global to implement Microsoft SQL Server Integration Services (SSIS) for Analytics and BI to centralize finance reporting across its US terminal operations, targeting AR, AP and account analysis. The engagement positioned Microsoft SQL Server Integration Services (SSIS) as the core ETL engine to populate a Power BI data warehouse supporting finance reporting workflows.
The implementation delivered a Microsoft-based data integration and warehousing architecture using SSIS maps to load financial extracts and ERP extracts into staging and analytical layers. SSIS packages were configured for scheduled, automated ETL processing, canonical finance schemas were modeled to support account-level analysis, and data preparation logic was embedded in the SSIS workflows to produce Power BI-ready datasets.
Integrations focused on extracting source ledgers and operational ERP extracts and feeding those feeds into the Power BI data warehouse, enabling Power BI dashboards to surface consolidated AR/AP and account analysis. Operational coverage was concentrated on the finance function for the US terminal operator, with data flows designed to support routine financial reporting and ad hoc account investigations.
Jade Global led rollout and operationalization, instituting scheduled ETL jobs and Power BI refresh patterns and establishing finance reporting handoffs between IT and finance. The project delivered automated ETL and Power BI dashboards to improve financial visibility and decision-making for Total Terminals International, with governance centered on scheduled data refresh and dataset lineage to support ongoing finance reporting.
|
Buyer Intent: Companies Evaluating Microsoft SQL Server Integration Services (SSIS)
Discover Software Buyers actively Evaluating Enterprise Applications
| Logo | Company | Industry | Employees | Revenue | Country | Evaluated | ||
|---|---|---|---|---|---|---|---|---|
| No data found | ||||||||