Good afternoon everyone
Post for the first time, so excuse me if I make mistakes.
I'm a newbie to oracle and I'm really struggling with this concept of 32 and 64 bit oracle business.
All I really want to do is import data from an Oracle 12c DW into a local 2019 SQL Server daily and then connect Power BI over it.
The reason for this is that we are trying to switch from Oracle to SQL Server and I have to PoC.
So far I've looked up and down and can't figure out WHAT to install to access WHAT in Oracle.
All I really need, if I understand it correctly, is to install an Oracle CLIENT so that I can use SSIS to create my ETL routines. BUT when I install a 32-bit client it says that a 64-bit client is needed and when I install a 64-bit client it means that an ODAC is needed. I installed that too and still have no success.
I also have problems understanding which folder level is included in the PATH in the system environment variables.
It's so complicated compared to SQL Server – so I could really use your help in the following questions.
Given that SSMS is 32-bit – Can I only install 32-bit Oracle client and ODAC – If so, what software do I download and install from Oracle – Can't tell the difference between xcopy and other versions ( and can you tell me how the path is updated)?
Do I have to install x64-bit at all since I am on a 64-bit workstation? If so, what software do I download?
My ultimate goal is to be able to
– Connect to ORACLE with SQL SERVER SSIS and import data daily via ETL routines
– As a temporary backup, also establish a connection to ORACLE via Power BI.
Any help and advice much appreciated.