Create a windows firewall rule to allow sql ssis to talk to an oracle database using microsoft connector for oracle

Greg Booth 1,296 Reputation points
2022-03-25T18:19:22.29+00:00

We have an ssis package that uses the microsoft oracle connector to talk to an oracle database. This is deployed to a server running ssis - which will need to talk to the oracle db (and write to a seperate sql instance).
The SSIS server has the windows firewall enabled.
We have had to create an an outbound rule to allow the ssis server to talk to the sql database.
For some reason we have not had to create a rule to allow it to talk to the oracle database (listening on port 1521).
Can anyone see a reason why its still connecting to the oracle db ? and is there anythign special we need to do to allow the connection to the oracle database ongoing ?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,948 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 42,451 Reputation points
    2022-03-28T07:36:44.303+00:00

    I don't understand a single work of your post.
    SSIS acts here as any other database/Oracle client and requires the same Firewall rules as any other Orcale client to connect to the Oracle database.

    0 comments No comments