You create an OLE DB connection using the Oracle OLE DB provider.
Make sure the Oracle client tools and the ODAC components are installed on the development machine.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP