Can on-premise gateway be used with excel and excel online?

%3CLINGO-SUB%20id%3D%22lingo-sub-1528609%22%20slang%3D%22en-US%22%3ECan%20on-premise%20gateway%20be%20used%20with%20excel%20and%20excel%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528609%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20want%20to%20fetch%20data%20into%20excel%20from%20an%20on-premise%20Oracle%20server.%20On-premise%20gateway%20seems%20to%20be%20right%20tool%20to%20enable%20this.%20It%20can%20be%20used%20in%20Power%20BI%20but%20I%20don't%20see%20any%20way%20to%20define%20a%20connection%20in%20excel%20to%20an%20on-premise%20gateway.%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20the%20data%20is%20loaded%20into%20excel%2C%20the%20file%20would%20be%20uploaded%20to%20sharepoint%20for%20further%20collaboration%20through%20excel%20online.%20We%20are%20hoping%20that%20%22Refresh%20all%20connections%22%20would%20work%20in%20excel%20online%20to%20enable%20users%20in%20refreshing%20the%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20guide%20me%20on%20how%20can%20I%20use%20on-premise%20gateway%20in%20excel%20(2016)%20and%20in%20excel%20online%20(to%20refresh%20data)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1528609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529668%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20on-premise%20gateway%20be%20used%20with%20excel%20and%20excel%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730281%22%20target%3D%22_blank%22%3E%40amitshah1935%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20a%20comment%20if%20you%20connect%20using%20Power%20Query%2C%20Refresh%20is%20not%20supported%20for%20it%20in%20Excel%20Online.%20If%20that's%20data%20model%20connector%20you%20shall%20do%20nothing%20within%20Excel%20to%20connect%2C%20adding%20connection%20to%20Enterprise%20data%20GW%20shall%20be%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1532689%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20on-premise%20gateway%20be%20used%20with%20excel%20and%20excel%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532689%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E-ERR%3AREF-NOT-FOUND-%40Sergei%20Baklan%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730281%22%20target%3D%22_blank%22%3E%40amitshah1935%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that's%20data%20model%20connector%20you%20shall%20do%20nothing%20within%20Excel%20to%20connect%2C%20adding%20connection%20to%20Enterprise%20data%20GW%20shall%20be%20enough.%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20II%20didn't%20follow%20what%20you%20meant%20by%20%22Enterprise%20data%20GW%22%3F%20Is%20it%20different%20from%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdata-integration%2Fgateway%2Fservice-gateway-onprem%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%20on-premise%20gateway%3C%2FA%3E%3F%20Could%20you%20please%20elaborate%20how%20does%20it%20help%20in%20my%20requirements%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1532938%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20on-premise%20gateway%20be%20used%20with%20excel%20and%20excel%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730281%22%20target%3D%22_blank%22%3E%40amitshah1935%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20old%20terminology.%20Enterprise%20data%20GW%20is%20called%20now%26nbsp%3B%3CSTRONG%3EOn-premises%20data%20gateway%3C%2FSTRONG%3E%2C%20and%20Personal%20data%20GW%20-%26nbsp%3B%3CSTRONG%3EOn-premises%20data%20gateway(personal%20mode).%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533038%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20on-premise%20gateway%20be%20used%20with%20excel%20and%20excel%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533038%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20right%20and%20I%20could%20not%20find%20a%20way%20to%20load%20data%20from%20an%20on-premise%20gateway%20into%20Excel.%20Let%20me%20know%20if%20you%20could%20guide%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533115%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20on-premise%20gateway%20be%20used%20with%20excel%20and%20excel%20online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533115%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730281%22%20target%3D%22_blank%22%3E%40amitshah1935%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20do%20not%20load%20data%20from%20gateway%2C%20you%20load%20from%20on-premises%20database.%20You%20add%20data%20source%20to%20GW%2C%20not%20to%20Excel%20or%20any%20other%20app%2C%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20762px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206364i4B2B8264701601E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPerhaps%20there%20is%20some%20specific%20for%20the%20Oracle%2C%20but%20didn't%20work%20with%20it%20for%20about%2010%20years.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

We want to fetch data into excel from an on-premise Oracle server. On-premise gateway seems to be right tool to enable this. It can be used in Power BI but I don't see any way to define a connection in excel to an on-premise gateway. 

Once the data is loaded into excel, the file would be uploaded to sharepoint for further collaboration through excel online. We are hoping that "Refresh all connections" would work in excel online to enable users in refreshing the data. 

 

Could you guide me on how can I use on-premise gateway in excel (2016) and in excel online (to refresh data)?

 

Thanks.

5 Replies
Highlighted

@amitshah1935 

As a comment if you connect using Power Query, Refresh is not supported for it in Excel Online. If that's data model connector you shall do nothing within Excel to connect, adding connection to Enterprise data GW shall be enough.

Highlighted

 


@Sergei Baklan wrote:

@amitshah1935 

If that's data model connector you shall do nothing within Excel to connect, adding connection to Enterprise data GW shall be enough.


@Sergei Baklan - II didn't follow what you meant by "Enterprise data GW"? Is it different from this on-premise gateway? Could you please elaborate how does it help in my requirements?

Highlighted

@amitshah1935 

Sorry, old terminology. Enterprise data GW is called now On-premises data gateway, and Personal data GW - On-premises data gateway(personal mode).

 

 

Highlighted

@Sergei Baklan - right and I could not find a way to load data from an on-premise gateway into Excel. Let me know if you could guide me.

Highlighted

@amitshah1935 

You do not load data from gateway, you load from on-premises database. You add data source to GW, not to Excel or any other app, like

image.png

Perhaps there is some specific for the Oracle, but didn't work with it for about 10 years.