Forum Discussion
Excel 2016 missing Oracle database connection options
Hello everyone!
Firstly, I'm sorry if this is not the correct place to ask this, but I'm not sure where should I ask.
I'm not a developer, I'm a simple sysadmin in SMB company that has pl...
Hi Jan,
From my memory Office 365 Business doesn't include Oracle connector, you need to have Enterprise plan.
Hi Sergei,
thanks for quick response.
So what are my options then, besides upgrading our 365 plan?
I'm currently trying to add OBDC connector from Administration Tools but for some reason it won't connect.
I also don't understand why registering OracleOLEDB.dll did not add the connector to Excel. Are there any other limitations?
Thank you
thanks for quick response.
So what are my options then, besides upgrading our 365 plan?
I'm currently trying to add OBDC connector from Administration Tools but for some reason it won't connect.
I also don't understand why registering OracleOLEDB.dll did not add the connector to Excel. Are there any other limitations?
Thank you
Jan,
More details about the plans is here, first in FAQ https://support.office.com/en-us/article/get-transform-and-power-pivot-in-excel-42d895c2-d1d7-41d0-88da-d1ed7ecc102d and in more details for previous versions of Excel
- Microsoft Office 2013:
- Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel 2013 Standalone
- Power Query Public: Available for all other Office 2013 Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce
https://www.microsoft.com/en-us/download/details.aspx?id=39379
I didn't work with Oracle and I'm on E3 plan, don't know if workaround exists or not. My understanding you have connector or you don't have connector, independently of registering Oracle dll.