You may be tempted to use 32-bit ODAC however since you are working on the server you will already have a 64-bit version of the Oracle client installed so you need to have a separate Oracle home for the 32-bit version of the client, the simplest way to do this is to use this client rather than the 32-bit ODAC.
I HAVE MS OFFICE 32BIT CAN I INSTALL POWER PIVOT 64BIT 64 BIT
As the name implies this is for 64 bit applications so be sure to check your applications to confirm they are running in 64 bit mode.
Do not use this if you have any server software such as SQL Server installed on this computer. 64 bit Oracle Data Access Components - Use this if you only have 64 bit applications like Excel or Power BI.This is for 32 bit applications so be sure to check if Excel is 32 bit or 64 bit. 32 bit Oracle Data Access Components with Oracle Developer Tools for Visual Studio - Use this if you only have applications like Visual Studio, Excel or Power Pivot on your computer.Do not use this if you are using server software such as SQL Server or Change Data Capture Service for Oracle by Attunity. Use this if you are trying to connect to Oracle with applications like Excel or Power BI. In order to connect to an Oracle database using a MS product you must installl an Oracle client. In this post I will share some of the lessons that I have learned as well as provide some practical advice so that you can have a smooth, hassle free expereince when taking on this task.
Whether you are using Microsoft Power Pivot, SQL Server Analysis Services, Power BI, SharePoint Excel Services or the Change Data Capture Service for Oracle by Attunity it can be a confusing process to install and configure the required software to enable this functionality. Connecting to an Oracle database with various Microsoft (MS) products can be a challenge.