Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5
  3. Part 2: Versions 10.4.1 - 10.4.1.3
  4. Part 3: Versions 10.4 - 10.4.0.2
  5. Part 4: Versions 10.2.2 - 10.2.2 HotFix 1
  6. Part 5: Version 10.2.1
  7. Part 6: Version 10.2 - 10.2 HotFix 2

PowerExchange for Microsoft Azure SQL Data Warehouse

PowerExchange for Microsoft Azure SQL Data Warehouse

Effective in version 10.5, PowerExchange for Microsoft Azure SQL Data Warehouse includes the following features:
  • You can connect to Microsoft Azure Data Lake Storage Gen2 to stage files at runtime.
  • You can stage files in Parquet format when you read data from Microsoft Azure SQL Data Warehouse.
  • You can override the schema name and table name when you read data from and write data to Microsoft Azure SQL Data Warehouse.
  • You can use Gzip compression to compress data in Gzip format when you write data to Microsoft Azure SQL Data Warehouse in the native environment.
  • You can read and write data of Datetimeoffset data type when you run a mapping on the Spark Engine.
  • You can perform audits for read operations in Microsoft Azure SQL Data Warehouse mappings that run in the native environment or on the Spark engine.
  • You can read data from and write data to Microsoft Azure SQL Data Warehouse case-sensitive databases.
For more information, see the
Informatica 10.5 PowerExchange for Microsoft Azure SQL Data Warehouse User Guide
.