Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
 |
ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check outour products including many FREE tools. If you are an MVP you may qualify for FREE MVP License |
SSIS JSON File Source (File, REST API, OData)
- Read data from JSON files or RESTful API services (such as Twitter, Zendesk)
- De-normalize nested JSON into flat document just like regular database table
- Support for JSONPath expression to extract sub-documents or array
- Support for OAuth 1.0 and 2.0 security standard which is adopted by major cloud services (e.g. Google API, Facebook, Salesforce, Dynamics CRM, Office 365, MailChimp and many more)
- Support for OData format (see)
- Support for Basic authorization (Passing UserID and Password to REST API Service)
- Support for looping through multiple files using wild card pattern (e.g. *.json).
- Support for HTTP Request with Custom Headers.
- Support for REST API Paging (3 different methods) – Loop through multiple requests (explainedhere and here)
- Support for very large JSON files
- Support for Pivoting (Convert Columns to Rows)
- Ability to output and indent raw JSON from inner array
- Support for SSL3 and TLS 1.2 protocol for encryption
- Support for passing cookies
- Support for Proxy
- Support for SQL Server 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
Screenshots
 |
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...
|
Why SSIS PowerPack?
- Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
| |
