Sample Header Ad - 728x90

What do I need to develop an integration service to extract data from an Oracle DB to a SQL Server DB using Visual Studio 2015?

0 votes
1 answer
169 views
I have to develop an ETL to extract some data from an Oracle DB 11g to a SQL Server 2017 DB. I am pretty new at all this technology so I would like some advices. The strongest problem so far is to understand what I exactly need to perform this, as the more I read, the more confused I feel about all the tools I am supposed to install. Here what I have so far: - The SQL Server 2017 DB is on a server. I can access the DB through Microsoft SQL Manager. Also, I have access to the server itself through remote connection but no permission to install whatever I want. However, I guess I could ask for any installation if it was mandatory. - The Oracle DB is on another server. I do not have access to the server itself. I have access to the DB through SQL Developer Tool. I access to the DB using EZ Connect, not a TNS. - On my PC, I have the following tools installed: - Visual Studio 2015 - Visual Studio extension Microsoft SQL data tool, in order to develop the SSIS - Visual Studio extension Oracle Developer Tools in order to connect to the Oracle DB through Visual Studio I can already develop a SSIS and transfer some data from my PC to the SQL server DB. However, I am not able to connect to the Oracle DB through the SSIS. I am pretty sure there are plenty of details that I am missing so I would be grateful to whoever that would give me any advice.
Asked by Isa (3 rep)
Mar 29, 2019, 04:29 PM
Last activity: Mar 30, 2019, 06:32 PM