You can use a PowerExchange for HDFS or a PowerExchange for Microsoft Azure Data Lake Store connection to read data from ADLS data objects. If you use a PowerExchange for Microsoft Azure Data Lake Store connection, you cannot read compressed binary files from ADLS.

The following table shows the complex files that a PowerExchange for Microsoft Azure Data Lake Store connection can process within ADLS storage in the Hadoop environment:

File Type	Supported Formats	Supported Engines
Avro	Flat Hierarchical 1	Spark
JSON	Flat Hierarchical 1	Spark
Parquet	Flat Hierarchical 1	Spark
1 To run on the Spark engine, the complex file read operation must be enabled to project columns as complex data type.

The following table shows the complex files that a PowerExchange for HDFS connection can process within ADLS storage in the Hadoop environment:

File Type	Supported Formats	Supported Engines
Avro	Flat Hierarchical 1 2	Blaze Spark
JSON	Flat 1 Hierarchical 1 2	Blaze Spark
ORC	Flat	Spark
Parquet	Flat Hierarchical 1 2	Blaze Spark
1 To run on the Blaze engine, the complex file data object must be connected to a Data Processor transformation. 2 To run on the Spark engine, the complex file read operation must be enabled to project columns as complex data type.