Azure Data Factory - AWS Oracle Database to Azure SQL Server

0
votes

Is it possible to connect ADF to an Oracle database on AWS as source and migrate data to an Azure SQL Server?

I've made some attempties and the result was always timeout.

The goal was achieved using an Integration Runtime, but didn't wanted to use it. I'd like a direct connection.

1
azureazure-data-factory

1 Answers

0
votes

I've made some attempties and the result was always timeout.

Hi,Vinicius. Based on the Oracle connector,no more special properties you need to configure except host,user,password properties etc for Oracle database on AWS. You could check the supported versions of an Oracle database.

If you still have timeout issue, you could commit feedback to azure data factory to find an official statement.

Since you want to avoid IR, maybe you could refer to below solutions:

1.Try export data to AWS S3 and ADF supports AWS S3 connector as source.

2.Try to use Data Integration - Kettle tool to transfer data by jdbc driver.