How can we improve Microsoft Azure SQL Data Warehouse ?

Provide File Format to read JSON and XML data from Storage

Able to read the JSON and XML file as part of external system OR provide functionality like Extractor in Data Lake analytics so we can write our own Extractor to read respective data format.

84 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Satya shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Bushra Anjum commented  ·   ·  Flag as inappropriate

    Try the following ":
    https://zappysys.com/products/ssis-powerpack/ssis-json-integration-pack/

    Here you can see following features :

    =>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 (e.g. Extract Orders nested under Customer Node).
    =>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
    =>Create simple or nested JSON documents inside DataFlow Task using simple drag and drop approach
    =>Ability to create nested JSON from Multiple datasets
    =>Ability to create single JSON document for all input records or create one document for each input row from ROOT dataset
    =>Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
    =>Export SQL query output to JSON file
    =>Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
    =>Automatically Split exported JSON data into multiple files by Size or Number of records
    =>Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
    =>Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)

  • Mike commented  ·   ·  Flag as inappropriate

    Also please support per-line json objects, without an enclosing array, as written by Stream Analytics.

Feedback and Knowledge Base