[Synapse Analytics][DB2][AS400] - Linked service settings and code page conversion

Christophe Salvai 0 Reputation points
2023-07-07T07:15:00.0533333+00:00

Dear all,

I have defined a DB2 linked service in Azure Synapse Analytics. Final purpose is to copy data from AS400 system to an Azure data lake storage.

I added some optional connection properties (please see print screens). Test connection is OK but data is not correctly converted, in both preview data and sink parquet file (copied to ADLS).

I am not sure of the additional connection properties and defined values. Unfortunately I did not find an example of DB2 linked service with additional connection properties to ensure settings is correct.

It is a blocking point. I would appreciate any help, thank you!

Christophe

User's image

User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,187 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,249 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.