Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Any answer to my question?
Azure data factory DB2 connector is not converting EBCDIC encoded string
Sabyasachi Maity
1
Reputation point
Currently, I am facing a problem with the DB2 connector, DB2 connector is not supporting EBCDIC encoding. When I see the preview data, it's showing Chinese characters. I am connecting AS-400 Series DB and getting the data using the DB2 connector (not found any other connector in the data factory).
Can anyone let me know how I can fix the problem?
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,161 Reputation points2021-12-09T22:26:58.57+00:00 Hello and welcome to Microsoft Q&A @MaitySabyasachi-5168 .
So I noticed you reported the characters were not what you expected in the preview,
but you didn't say anything about the results of running the pipeline. In the past, there have been a couple cases where previewing behavior was slightly different from actual output behavior. Can you tell me what you see in the sink after running the pipeline? I am considering the possibility that the graphic user interface might be suppressing the encoding in preview while making the copy run correctly. -
Sabyasachi Maity 1 Reputation point
2021-12-10T08:30:58.693+00:00 Hi Martin,
Thank you so much for your reply. Unfortunately in the pipeline also I am getting the same result. Here is the result.
Regards,
Sabya
Sign in to comment
1 answer
Sort by: Most helpful
-
Sabyasachi Maity 1 Reputation point
2021-12-15T16:03:33.913+00:00 -
MartinJaffer-MSFT 26,161 Reputation points
2021-12-16T05:57:20.22+00:00 Sadly, you have stumped me on this one, and I do not have a DB2 environment to reproduce this with. Can I interest you in a support ticket, for more personalized assistance?
-
Sabyasachi Maity 1 Reputation point
2021-12-17T09:04:00.837+00:00 Hi Martin,
It will be great if you do more personalized assistance. Or will be nice if we can schedule a teams meeting, so I can describe more with screen share.
Thanks,
Sabya -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 69%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Caspar Boersma 0 Reputation points2025-02-07T12:30:29.5166667+00:00 Hi Martin and Sabyasachi,
I have the same issue. Did you resolve it with the DB2 connector settings, the DB2 database or performing transformations afterwards?
Thanks,
Caspar
Sign in to comment -