Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

on-premise data gateway sap bw

Hi all,   I'm having an issue setting up a schedle refresh for reports which have SAP BW database as a source.   We are using the new SAP BW connector (Implementation 2.0) and have installed the ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi EdEvetts 

 

Microsoft traced the error to the Gateway making a test connection before trying to make the live connection.  They resolved this in the April 2019 version of the Gateway which has added a tick box to "Skip Test Connection".

 

When I checked this box I was able to sucessfully set up the SAP BW datasource on the Gateway.

The scheduled refresh doesn't always work as the "Skip Test Connection" box doesn't seem to stay selected.

EdEvetts's avatar
EdEvetts
Icon for Helper II rankHelper II
7 years ago

Thanks Anonymous 

 

I saw the check box, I'll give that a go, why does that make it work?

 

thanks Ed

  • EdEvetts's avatar
    EdEvetts
    Icon for Helper II rankHelper II
    7 years ago

    Anonymous I did see the check box, but when I looked again today it seems to not be there, can you still see it?

     

    thanks Ed

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi EdEvetts .

      I looked this morning and the check box does not appear in the datasource in Manage Gateways.  However, when I clicked on "Test all connections" all reported successful.

       

      I checked the Data Source credentials in Workspace/Datasource there is a warning "Some credentials aren't validated as they are set to skip test connection.".

      I am now confused - I will check to see if an update is available for the Gateway.