Copy on prem oracle database data to azure sql database using azure datafactory

Question

Copy on prem oracle database data to azure sql database using azure datafactory

04032588 60

Can we copy data from on prem oracle database to existing azure sql database using azure data factory? Are there any examples available for this activity on github or on microsoft documentation?

04032588 60 Reputation points

2023-08-09T13:17:43.7266667+00:00

Just wanted to know how much would be charged for the copy activity? Lets say if the data is around ~ 1 Gb. Do we have any references or articles for the same? Please let me know
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-08-09T14:58:47.1966667+00:00

Hope the answer provided here provides you the information you are looking for,

Accepted answer

0 additional answers

Your answer

04032588 60 Reputation points

2023-08-09T13:17:43.7266667+00:00

Just wanted to know how much would be charged for the copy activity? Lets say if the data is around ~ 1 Gb. Do we have any references or articles for the same? Please let me know
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-08-09T14:58:47.1966667+00:00

Hope the answer provided here provides you the information you are looking for,

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Please follow this step-by-step tutorial you can fin on Microsoft documentation.

Basically the tutorial will guide you to use a Copy Activity on Azure Data Factory (ADF) to read data from the Oracle database using an Oracle connector.

The tutorial will also guide you to create a linked service that specifies the connection information and credentials for your Oracle database.

Since your Oracle database is located inside an on-premises network, you also need to configure a self-hosted integration runtime that can access your Oracle database and transfer data to Azure SQL Database. You can install the self-hosted integration runtime on a Windows machine that has network connectivity to your Oracle database.

Alternatively, this GitHub article guides you on how to use Copy Activity in Azure Data Factory to move data from an on-premises Oracle database.

04032588 60 Reputation points

2023-08-03T16:08:17.27+00:00

Thanks for the links, However I can only see the copy activity is moving the oracle db data to blob storage and my requirement is to move the data to SQL Azure. Any links on this within ADF(low code) is greatly appreciated
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-08-03T16:14:08.83+00:00

You just need to select Azure SQL Database as sink and do the column mappings as explained here. Setting Azure as destination is the easiest part of the process.
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-03T20:35:26.5133333+00:00

04032588

Please don't forget to mark as accept answer if the above reply from @Alberto Morillo was helpful.

Regards,

Oury
04032588 60 Reputation points

2023-08-04T11:57:20.51+00:00

I see Rest API, Copy Activity and other means as well, which one would you recommend and the easiest one to copy on prem oracle database data to azure sql?

Also I'm looking for the delta data to automatically copy from on prem oracle to azure sql.

Please let me know.
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-08-04T12:36:38.54+00:00

I would try to avoid the REST API calls as they may get queued when querying the on-premises Oracle database.

This is the documentation to load data incrementally to a destination using Azure Data Factory. you will find the watermark method, Change Data Capture and slicing among the possibilities.

Share via

Copy on prem oracle database data to azure sql database using azure datafactory

0 additional answers

Your answer