Unable to set enterprise gateway for ServiceNow (ODBC)

[neerav_singh]

We are using ODBC connection to connect to Servicenow env, I can schedule the reports using personal gateway but unable to select data gateway.

with continual use of Personal gateway we get below messages:

"The last refresh attempt failed. Your Personal Gateway is offline or could not be reached." as my login on the server where Personal gateway is installed expires.

I have installed both Personal and Enterprise gateway on the server.

[antonstorozhuk]

Hello @neerav_singh 

In case you're still struggling exporting data from Servicenow, you might want to try out our Servicenow app: Power BI Connector:

• https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
• https://www.alphaservesp.com/products/servicenow/power-bi/

We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.

Thank you.

Regards,

Anton

===

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-qiuyu-msft]

Hi @neerav_singh,

The machine hosts the gateway needs to be access the ODBC DSN. In your scenario, you need to sign in to get gateway work again in the same machine as ODBC DSN created on. 

When you use the on-premise data gateway, please use the same connection information as you defined in desktop. By the way, please always keep the gateway to be run as the latest version. 

Best Regards,
Qiuyun Yu

[neerav_singh]

The machine hosting gateway has the ODBC DSN created & is working, still the option is greyed out.