ADF - SAP BW via MDX - language option

Anonymous
2021-03-03T16:58:34.517+00:00

Hi, I'm reading data from SAP BW, but there is one field that relies on the language of the connection. When I run the query from my computer (language = PT), it works OK But when I run the same query from Azure Data Factoy, the field gets the english translation. It is the same result as running from my computer and changing the language to EN Where do I configure the language?

73931-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,931 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee
    2021-03-04T07:36:01.587+00:00

    Hi @Anonymous ,

    Welcome to Microsoft Q&A forum and thanks reaching out.
    It has not been exposed in UI, but we can set it by editing the linked service JSON payload. To do so please go to SAP BW LinkedService->code-> set language by add the below property in "typeProperties":

    "language": "PT"

    Please see below GIF for more clarification:

    74150-sapbwlinkedservicepayloadedit.gif

    Please make sure to publish the changes before you the linked service.

    Hope this helps.

    ----------

    Thank you
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful