商品説明の翻訳が完了していない商品については、Google翻訳サービスへのリンクを表示しております。 ただし機械による自動翻訳は必ずしも翻訳結果が正確ではないことにご注意願います。

Powered by

SSIS PowerPack の主な機能

SSIS Web API Integration Tasks/Components (REST API, SOAP, JSON, XML).
Web API Integration
SSIS JSON Integration Tasks/Components (Read, write, parse JSON data).
JSON Integration
SSIS Amazon AWS Integration Tasks/Components (S3 Storage, Redshift, DynamoDB).
AWS Integration
SSIS MongoDB Integration Tasks/Components.
MongoDB Integration
SSIS Google Analytics Integration Component (with AdWord, AdSense, Ad Exchange, DoubleClick support).
Google Analytics Integration
SSIS Azure Integration Tasks/Components.
Azure Integration
SSIS XML / SOAP Integration Tasks/Components.
XML / SOAP Integration
Secure FTP (SFTP, FTP/SSL) / File System Integration.
Secure FTP / File System Integration
SSRS Report Integration (Exporting reports).
SSRS Report Integration
Other useful SSIS tasks and components.
Other Tasks / Components
SSIS Web API Integration Tasks/Components (REST API, SOAP, JSON, XML).

SSIS Web API Integration Tasks/Components (REST API, SOAP, JSON, XML).

SSIS PowerPack gives you a complete toolset for web API Integration inside SSIS. You can call REST API/SOAP/OAuth/OData Service. Using simple drag and drop interface you can consume data from any Web Service in few clicks (XML or JSON format). You can also send Ad-hoc request to any web server including file upload requests. It includes JSON Source Connector, XML Source Connector and REST API Task.

  • Consume any RESTful Web API (like this) or XML SOAP Web Service in few clicks.
  • Send Ad-hoc Http Web Request (e.g. GET, POST) and save response into SSIS variable or file.
  • Filter, Pivot, De-normalize nested XML or JSON into flat document just like regular database table.
  • Read data from JSON/XML files or RESTful API services (such as Twitter, Zendesk).
  • JSONPath style expression to extract sub-documents or array.
SSIS JSON Integration Tasks/Components (Read, write, parse JSON data).

SSIS JSON Integration Tasks/Components (Read, write, parse JSON data).

SSIS PowerPack gives you complete JSON integration toolset to solve any JSON integration scenarios in SSIS (e.g. Consume, Produce, Parse). Using simple drag and drop interface you can read data from JSON files or JSON Web Service (i.e. REST API). It includes JSON Source Connector, Export JSON File Task, JSON Parser Transform and JSON Generator Transform.

  • Read JSON data from any REST API Web Service using methods such as GET/POST.
  • Read JSON data from single or multiple JSON files (use of wildcard allowed. e.g. c:\data\*.json).
  • Support for Path expression to extract data from any level.
  • Support for passing custom headers to API Web service.
  • REST API Paging support to loop through multiple requests (see).
  • Parse source JSON String/Documents into multiple columns/rows.
  • Ability to de-normalize nested JSON data into flat structure.
SSIS Amazon AWS Integration Tasks/Components (S3 Storage, Redshift, DynamoDB).

SSIS Amazon AWS Integration Tasks/Components (S3 Storage, Redshift, DynamoDB).

SSIS PowerPack comes with many tasks/components to integrate with Amazon AWS Services such as S3 Storage, Redshift and DyanmoDB.

  • 30+ Amazon S3 operations for S3 buckets and files (e.g. Download, Upload, Copy, Delete…).
  • Support client side and server side encryption (AES, RSA).
  • Extremely fast way to load on-premises data to Amazon Redshift in few clicks from files or relational database system (e.g. SQL Server, Oracle, MySQL, DB2).
  • Execute Ad-Hoc DDL or DML script/queries against Amazon Redshift (e.g. CREATE, UPDATE, DROP).
  • Read data from DynamoDB using SQL style queries.
  • Load data/raw JSON into DynamoDB.
  • Call API call for DynamoDB (e.g. Create table).
SSIS MongoDB Integration Tasks/Components.

SSIS MongoDB Integration Tasks/Components.

SSIS PowerPack gives you complete JSON integration toolset to solve MongoDB integration scenarios in SSIS. Using simple drag and drop interface you can read data from MongoDB or Bulk insert/update data into MongoDB. You can also execute any valid MongoDB API commands inside SSIS (e.g. Create Table/ Drop Table/Get Count). It includes MongoDB Source Connector, MongoDB Destination Connector and MongoDB ExecuteSQL Task.

  • Bulk extract/output MongoDB data using.
  • SQL Like query language.
  • Bulk insert/update/delete/upsert data into MongoDB Table.
  • Support for loading Raw JSON documents from any source or generated by JSON Generator Transform.
  • Support for executing custom MongoDB Shell functions / server side JavaScript.
SSIS Google Analytics Integration Component (with AdWord, AdSense, Ad Exchange, DoubleClick support).

SSIS Google Analytics Integration Component (with AdWord, AdSense, Ad Exchange, DoubleClick support).

SSIS Google Analytics Source connector can be used to read data from Google Analytics Service without learning complex API. Easy to use interface allows you extract large amount of data adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use inbuilt reports or specify direct query URL to get desired data.

  • Simple drag and drop interface.
  • Support for OAuth 2.0 Authentication and Google service account (*.p12 certificate file).
  • Three ways to query google analytics data (1) Build query from UI (2) Use built in query templates (3) Use direct query.
  • Support for dynamic dimensions, metrics, segments, filters and sortby fields (e.g. supply these values at runtime).
  • Support for AdWords, AdSense, Ad Exchange and DoubleClick for Publisher (DFP).
SSIS Azure Integration Tasks/Components.

SSIS Azure Integration Tasks/Components.

SSIS PowerPack comes with many tasks/components to integrate with Azure Services such as Blob storage and table storage.

  • 30+ Azure blob storage operations for containers and blobs (e.g. Download, Upload, Copy, Delete…).
  • Read data from Azure Table using SQL style queries.
  • Load data into Azure Table Storage.
  • Call API call for DynamoDB (e.g. Create table).
SSIS XML / SOAP Integration Tasks/Components.

SSIS XML / SOAP Integration Tasks/Components.

SSIS PowerPack gives you complete toolset to automate XML integration scenarios in SSIS (e.g. Consume/Produce/Parse). Using simple drag and drop interface you can read data from XML files or XML Web Services (i.e. REST API/SOAP). It includes XML Source Connector, Export XML File Task, XML Parser Transform and XML Generator Transform.

Secure FTP (SFTP, FTP/SSL) / File System Integration.

Secure FTP (SFTP, FTP/SSL) / File System Integration.

SSIS PowerPack comes with many tasks to handle file related operations. You can use Secure FTP Task, Advanced File System Task, Download File Task and Validation Task.

SSRS Report Integration (Exporting reports).

SSRS Report Integration (Exporting reports).

SSIS Report Generator Task can be used to export or email SSRS reports inside SSIS Package. This task also supports dynamic data driven export which can export several reports to disk and email to specified users based on settings stored in sql table.

  • Automate reporting services report export and email process using SSIS.
  • Support for SSRS 2005/2008/2012 and higher.
  • Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.
  • Support for Sharepoint Integrated Mode.
  • Export report in xls, pdf, doc, xml, mhtml and csv format.
  • Send report as attachment to list of users.
  • Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process.
Other useful SSIS tasks and components.

Other useful SSIS tasks and components.

SSIS PowerPack comes with many useful tasks and components which are not listed in previous categories.