Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Assistance with Connecting Azure SQL to Oracle FDI – Firewall/Port Issue

Received Response
11
Views
2
Comments
PRATHEEK
PRATHEEK Rank 4 - Community Specialist

Hello Oracle CEAL Team & FDI Analytics community

am currently revisiting the process of connecting Azure SQL to Oracle FDI. I’m encountering an issue that seems related to firewall restrictions.

We previously opened port 1433 on our Azure SQL Database, and it appears the initial connection from Oracle FDI is reaching Azure SQL. However, the response from Azure SQL doesn’t seem to make it back to the Oracle side, suggesting a possible return path issue.

Does Oracle has any documentation regarding successful connections between Azure SQL and Oracle FDI? If so, any guidance or recommended configurations (especially around network/firewall settings) would be greatly appreciated.

Answers