Forum Discussion

YairCzitrom's avatar
YairCzitrom
Helper II
2 years ago

Error when trying to create a dataflow gen 2.

Hi Guys. I have a data lake and date warehouse. Tried to create on both of the the same thing and i got the same error. Crteated a dataflow gen 2 that gets table from my on prem SQL server via a w...
Dataflows
data_power's avatar
data_power
Frequent Visitor
2 years ago

Hi Folk,
I got the same error while trying to use my oracle database as source. But didn't work like the others. I made another try to see if the firewall issue or not with giving a try with an csv file which is located on my client. So i don't expect to get an error because of firewall. But still getting the same error. 

Any idea what could be the issue? I have the fabric admin user rights and while checking the tables via Lakehouse component I be able to see the tables files and get any query if I want. 

Thanks in advance for the advices.

YairCzitrom's avatar
YairCzitrom
Helper II
2 years ago

We ended up with opening our fire wall to specific IP's that we could see that they are being used and that fixed the problem.

  • Element115's avatar
    Element115
    Memorable Member
    2 years ago

    Yeah finally, we got it fixed to.  The sysadmin set a rule like this: 

    outgoing IP: 0.0.0.0 (essentially any IP address)
    protocol: TCP

    port: 1433