Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Z_H
Contributor
Contributor

Connect Oracle with Qlik Sense

Dear all,

I am new and trying to explore the connection setup between Qlik and Oracle. Just wondering does it need 1 way or 2 way connections if need to open the firewall for port 1521 to connect from Qliksense to Oracle DB?

Seek your expertise advise.

Many Thanks.

Labels (1)
1 Solution

Accepted Solutions
Marc
Employee
Employee

When performing a reload, the Qlik Sense Server establishes a connection to the oracle DB to extract the requested data.

So yes, you need a firewall rule that allows the Qlik Sense server to establish a connection to the Oracle DB.

The Oracle DB will not open a connection to the Qlik Sense Server.

View solution in original post

1 Reply
Marc
Employee
Employee

When performing a reload, the Qlik Sense Server establishes a connection to the oracle DB to extract the requested data.

So yes, you need a firewall rule that allows the Qlik Sense server to establish a connection to the Oracle DB.

The Oracle DB will not open a connection to the Qlik Sense Server.