Forum Discussion
Configuring Oracle Data Source in Enterprise Gateway
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.
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.
5 Replies
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.
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).
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.
