unable to connect to SAP RFC using SAP Table connector in ADF

Prashanth Kumar Rama 1 Reputation point
2021-01-13T17:38:04.67+00:00

Hi,
We are unable to connect to SAP RFC using SAP Table connector in ADF.
Steps:

  1. Installed Self-hosted Integration Runtime in the machine where SAP Server at On-premise
  2. Installed SAP .Net connector 3.0
  3. In the ADF pipeline -> Copy Activity -> Source configuration ->provided the SAP Server details and test connection was successfull
  4. But When we give the RFC name in the Table text box we are getting the below error.
    Error details
    Error code2200Troubleshooting guide
    Failure typeUser configuration issue
    DetailsFailure happened on 'Source' side. 'Type=SAP.Middleware.Connector.RfcInvalidParameterException,Message=Element QUERY_TABLE of container metadata ZF08_GL_ACC_BAL unknown,Source=sapnco,'
    SourcePipelineSAPTable
    MonitorCopy activityCopy data1

Please help us.
Thanks,
Prashanth

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,477 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.