I am not able to load large data from Oracle to fabric, Microsoft said they dont have that provision till date, is there any way to get 100million + data from Oracle on prem to fabric without dataflow ? Thanks
How come is this considered connecting to an on-prem DB when you are actually connecting to a Azure VM? The backend in the case of on-prem should be an NIC connected to an on-prem, while during the creation you only see Azure VMs
Can we write the same python code in fabric notebook. Exexuting python code in azure synapse analytics will incure extra cost. In fabric no need to pay extra cost for python code. It is part of fabric subscription
Hi @dineshs9670 - Yes, eventually you will be able to use the same code in Fabric Spark (when we ship the equivalent of Managed VNets in Fabric). But at the moment, Fabric Spark clusters will have no way to reach your on-prem DB behind firewalls privately. In order to enable that connectivity, you may be required to open up your on-prm DB with a Public IP and allow inbound ports such as 1433 (or whatever the DB is listening on) for our spark clusters to connect - if your security allows that, then yes you can use Fabric Spark with the same approach. The workaround I showed with Synapse will pass your security gates.
Awesome!! Thanks for that!
very good we like to use immediately very happy we need some help how i connect u sir
I am not able to load large data from Oracle to fabric, Microsoft said they dont have that provision till date, is there any way to get 100million + data from Oracle on prem to fabric without dataflow ?
Thanks
Data pipeline Copy data is support now with Oracle Onprem as well as cloud
How come is this considered connecting to an on-prem DB when you are actually connecting to a Azure VM? The backend in the case of on-prem should be an NIC connected to an on-prem, while during the creation you only see Azure VMs
Can we write the same python code in fabric notebook. Exexuting python code in azure synapse analytics will incure extra cost. In fabric no need to pay extra cost for python code. It is part of fabric subscription
Hi @dineshs9670 - Yes, eventually you will be able to use the same code in Fabric Spark (when we ship the equivalent of Managed VNets in Fabric). But at the moment, Fabric Spark clusters will have no way to reach your on-prem DB behind firewalls privately. In order to enable that connectivity, you may be required to open up your on-prm DB with a Public IP and allow inbound ports such as 1433 (or whatever the DB is listening on) for our spark clusters to connect - if your security allows that, then yes you can use Fabric Spark with the same approach. The workaround I showed with Synapse will pass your security gates.
@@datagravity3578 any idea when Managed VNets in Fabric will be available?