What's New and Changed (10.5.1)

Back Next

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