Configuring Oracle Data Source in Enterprise Gateway

[wonga]

I'm having trouble adding an Oracle database as a data source in the enterprise gateway. The error message I get is below:

Unable to connect: We encountered an error while trying to connect to SERVER_NAME. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details

Activity ID:	03e50d90-a4ee-4a5a-96c5-7dfe93a5ef4f
Request ID:	522f1644-0873-dd0c-719c-9d06e3972ddf
Cluster URI:	https://wabi-us-north-central-redirect.analysis.windows.net
Status code:	400
Error Code:	DM_GWPipeline_Gateway_MashupDataAccessError
Time:	Wed May 04 2016 14:48:55 GMT-0400 (Eastern Daylight Time)
Version:	13.0.1100.480

Underlying error code:	-2147467259
Underlying error message:	The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the offical provider.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error

I can confirm that I have the latest ODAC components installed on both the client machine and the server where the enterprise gateway is installed. I have also tested connecting to the data source through Power BI Desktop and it works just fine.

Any ideas? Thanks.

[ankitpatira]

@wonga Refer to this guide to find location where logs and generated and see if logs give you more information. Also previously i've found un-installing EG, downloading latest one and re-installing have fixed some problems.

As @jldaley86 suggested you can try cleaning registry values for EG and see if that works.

[wonga]

@ankitpatira Okay I'll give these 2 potential solutions a try. The weird thing is that I am able to add other data sources such as SQL Server, and File(s).

[wonga · Accepted solution]

I was able to setup the Oracle data source by reinstalling the gateway to the latest version and using the service name instead of the hostname in the "server" field when setting up the data source. Thanks.

[HelloWorld1]

any progress of this case ? I have met the same problem , thanks !

[GilbertQ]

I know that there is a solution to this post

But I do have a blog post explaining how to create and connect to the On-Premise Gateway for Oracle

Power BI – On-Premise Gateway Configuration steps to an Oracle Database