Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

SQL Server Integration Services serves as a robust platform designed for developing high-level solutions focused on data integration and transformation. It enables organizations to tackle intricate business challenges by facilitating the copying or downloading of files, populating data warehouses, cleaning and analyzing data, as well as overseeing SQL Server objects and their corresponding data. The platform is capable of extracting and transforming data from numerous sources, including XML files, flat files, and relational databases, before loading it into various destinations. Integration Services comes equipped with a comprehensive array of built-in tasks and transformations, along with user-friendly graphical tools that allow users to construct packages seamlessly. Additionally, the Integration Services Catalog database serves as a repository for storing, executing, and managing these packages. Users can take advantage of the visual tools within Integration Services to devise solutions without the need for any coding, but they also have the option to leverage the extensive object model to develop packages programmatically and implement custom tasks as needed. This flexibility makes Integration Services suitable for both novice users and experienced developers alike.

Description

SSIS PowerPack encompasses over 70 efficient, drag-and-drop connectors and tasks specifically designed for SSIS, which stands for Microsoft SQL Server Integration Services. This suite aims to enhance user productivity by offering intuitive, code-free components that facilitate connections to a wide variety of cloud and on-premises data sources, including but not limited to REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, and various Google APIs like Analytics and AdWords. Additionally, it supports integration with platforms such as SOAP/Web API, Facebook, Twitter, Zendesk, and eBay, among others. SSIS PowerPack also features a selection of high-quality free commercial components and tasks that come with full support and upgrade options. The built-in Layout Editor allows for the creation of intricate XML structures, accommodating nested attributes and Document Arrays while also handling CData sections effectively. Furthermore, users can automatically divide exported XML data into multiple files based on size or record count, and they have the capability to read XML documents to extract specific properties by name or through the use of XPath expressions, thus providing comprehensive utility for data management tasks. Such features make SSIS PowerPack an invaluable tool for those looking to streamline their data integration processes.

API Access

Has API

API Access

Has API

Screenshots View All

Screenshots View All

Integrations

AnalyticsCreator
Azure Data Factory
Azure Database Migration Service
Data Sentinel
FairCom DB
FairCom EDGE
OpenText Analytics Database (Vertica)
SQL Server
SolarWinds Task Factory
Web APIs by Melissa

Integrations

AnalyticsCreator
Azure Data Factory
Azure Database Migration Service
Data Sentinel
FairCom DB
FairCom EDGE
OpenText Analytics Database (Vertica)
SQL Server
SolarWinds Task Factory
Web APIs by Melissa

Pricing Details

No price information available.
Free Trial
Free Version

Pricing Details

No price information available.
Free Trial
Free Version

Deployment

Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook

Deployment

Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook

Customer Support

Business Hours
Live Rep (24/7)
Online Support

Customer Support

Business Hours
Live Rep (24/7)
Online Support

Types of Training

Training Docs
Webinars
Live Training (Online)
In Person

Types of Training

Training Docs
Webinars
Live Training (Online)
In Person

Vendor Details

Company Name

Microsoft

Founded

1975

Country

United States

Website

learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

Vendor Details

Company Name

ZappySys

Founded

2015

Country

United States

Website

zappysys.com/products/ssis-powerpack/

Product Features

Integration

Dashboard
ETL - Extract / Transform / Load
Metadata Management
Multiple Data Sources
Web Services

Product Features

Integration

Dashboard
ETL - Extract / Transform / Load
Metadata Management
Multiple Data Sources
Web Services

Alternatives

Alternatives

Apache Airflow Reviews

Apache Airflow

The Apache Software Foundation
accel-DS Reviews

accel-DS

Proden Technologies
Dentsoftware Reviews

Dentsoftware

Avengersoft Solutions