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 Azure Blob Source for JSON File

SSIS Azure Blob Source for JSON File can be used to read JSON files from Azure Blob Storage. You can extract data from single or multiple files (wildcard pattern supported). Also you can read compressed files (*.gz) without extracting files on disk.

Features

• Support for reading single or multiple files stored in Azure Blob Storage (wildcard pattern supported e.g. *.json)
• Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
• Support for reading zip and gzip compressed files (stream mode)
• Support for data pivot (transform columns into rows)
• Support for Dynamic file path using variable placeholder (e.g. /myroot/{{User::MyFolder}}/*.json )
• Support for SQL Server 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)

Click here to read more about Azure Blob Source for JSON File

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 ...

Data Integration Categories

• File Formats
  • JSON
  • XML
  • CSV
  • Excel
• Microsoft Azure Cloud
• Amazon AWS Cloud
• SOAP / REST API
• Secure FTP
• Big Data / NoSQL (MongoDB, DynamoDB, Redshift...)
• 3rd Party Online Services
• Email and Reporting
• Salesforce
• Microsoft Dynamics CRM
• Everyday things (Tasks to speedup common scenarios)

JSON / API Integration
Export JSON File Task	JSON File/REST API Source	JSON Parser Task
JSON Generator Transform	JSON Parser Transform	JSON File Destination
Azure Blob Source for JSON File	Amazon S3 Source for JSON File	Secure FTP Source for JSON File

XML Integration
Export XML File Task	XML File Source	XML Parser Task
XML Generator Transform	XML Parser Transform	XML Destination
Azure Blob Source for XML File	Amazon S3 Source for XML File	Secure FTP Source for XML File

CSV / Flat File Integration
Azure Blob Source for CSV File	Amazon S3 Source for CSV File	Secure FTP Source for CSV File
Azure Blob Destination for CSV File	Amazon S3 Destination for CSV File	Secure FTP Destination for CSV File
CSV Source (File / Web API)	CSV Destination	CSV Parser Transform
CSV Generator Transform	Export CSV File Task

Excel Integration
Excel Source	Excel Destination	Export Excel File Task

Microsoft Azure Cloud Integration
Azure Blob Storage Task	Azure Table Storage Source	Azure Table Storage Destination
Azure Queue Storage Source	Azure Queue Storage Destination	Azure Blob Source for XML File
Azure Blob Source for JSON File	Azure Blob Source for CSV File	Azure Blob Destination for CSV File

Amazon AWS Cloud Integration
Amazon S3 Task	Amazon Redshift Data Transfer Task	Amazon Redshift ExecuteSql Task
Amazon Redshift Cluster Management Task	Amazon DynamoDB Source	Amazon DynamoDB Destination
Amazon Redshift Source	Amazon Redshift Destination	Amazon SQS Queue Source
Amazon SQS Queue Destination	Amazon S3 Source for CSV File	Amazon S3 Destination for CSV File
Amazon S3 Source for XML File	Amazon S3 Source for JSON File	Amazon API Connection (Lambda, EC2, Glacier, SQS and more)

REST API, SOAP, Web API Integration
JSON Source Connector (File, REST API)	XML Source Connector (File, SOAP, REST API)	REST API Task
Export JSON File Task	JSON Parser Task	JSON Generator Transform
Web API Destination

Secure FTP Integration
SFTP Task (FTP,FTPS,Secure FTP)	Secure FTP Source for JSON File	Secure FTP Source for XML File
Secure FTP Source for CSV File	Secure FTP Destination for CSV File

Big Data / NoSQL Integration
MongoDB Source Connector	MongoDB Destination Connector	MongoDB ExecuteSQL Task
Amazon Redshift Data Transfer Task	Amazon Redshift Cluster Management Task	Amazon Redshift ExecuteSql Task
Amazon DynamoDB Source	Amazon DynamoDB Destination	Amazon DynamoDB ExecuteSQL Task
Amazon Redshift Source	Azure Table Storage Source	Azure Table Storage Destination
Amazon Redshift Destination

Salesforce Connectivity
Salesforce Source Connector	Salesforce Destination Connector	Salesforce API Task (Call REST/SOAP API)

PostgreSQL
PostgreSQL Source Connector	PostgreSQL Destination Connector	PostgreSQL ExecuteSQL Task

Microsoft Dynamics CRM (CRM Online 365 / On-Premises)
Dynamics CRM Source Connector	Dynamics CRM Destination Connector

3rd Party Online Services (REST/SOAP API Connectivity)
Google Analytics Source	Google Adwords API Integration	Google Map / Geocoding API Integration
Google SpreadSheet API Integration	Google DFP API Integration	Google SpreadSheet API Integration
Google BigQuery API Integration	SurveyMonkey API Integration	HubSpot API Integration
Amazon MWS API Integration (Marketplace Web Service)	Amazon Athena API Integration	Amazon AWS API Integration (EC2, Lambda, Gateway)
Office 365 API Integration (OneDrive, Calendar, Excel, Mail)	Zendesk API Integration	Twitter API Integration
LinkedIn API Integration	Xero API Integration	Zuora API Integration
Marketo API Integration	MailChimp API Integration	QuickBooks API Integration
WorkDay API Integration	Facebook Graph API Integration	Zoho CRM API Integration
Semantics3 API Integration	eBay API Integration	SmartSheet API Integration
NetSuite API Integration	Salesforce Marketing API Integration (ExactTarget)	LinkedIn API Integration
Zoom API Integration	TFS API Integration (VSTS)	ConstantContact API Integration
JIRA API Integration	Azure API Integration (Cognitive Services)	Sharepoint API Integration
ExactOnline API Integration	Shopify API Integration	SAP S4/HANA API Integration
Oracle UCM API Integration	Magento API Integration	Splunk API Integration
ElasticSearch API Integration