i am trying to get data from oracle database to sql database i have 3 environments
- Oracle development server 1
- SQL development server 2
- my local host window 8.1 64 bit with SQL data tool 2012
now when i go to add new connection manager under connection manager to connect to oracle server, i am not able to see the oracle connection manager type, i know that i have to install oracle client, but where to install it? in my machine or in the oracle server.
i already downloaded "Microsoft Connectors v2.0 for Oracle and Teradata" and install them in my machine. but still nothing happened, i cant see the connection manager
- AttunitySSISOraAdaptersSetup.msi
- AttunitySSISOraAdaptersSetupX64.msi
in SSIS toolbox i was able to see oracle destination and source component.
i searched the net for a step by step article on how to do this but no luck
please help.
thank you