Problems to connect with an Oracle EBS database when using copy data activity

[rmoraes1987]

Hello folks!

I'm trying to get data from Oracle EBS database. Here's the flow:

- VM Azure connect to a EBS server and access the data with a tnsnames.ora and Oracle client for microsoft tools installed;

- I checked the conn with an dbeaver installed inside the VM and that's okay;

- Now I'm trying to get data inside Fabric using the On-Premise Data Gateway. This app is installed and configured with the same e-mail using in Fabric;

- When I try to get data using dataflow gen2, It reaches the EBS server and database schemas;

- But when I try to get from Simple copy data activities, it just doesn't work, always get error 400.

Can somebody help me with this?

[lbendlin]

Can you confirm that you have done the tnsnames.ora setup on all gateway cluster members?