On-Premise QlikView Server Connection to Cloud Database

[spetushi]

Hello,

Is it possible to use Oracle Provider for OLEDB (OraOLEDB) data connector when QlikView Server is hosted on-premise and the source data is located on a Oracle Cloud database (Oracle 12)?

Can you share your experience if you have implemented such a data interface scenario?

Thank you,

Sokol

[qliksus]

When you want to do a data transfer between your cloud and On-premise server you have open the required Ports between the two server  i.e.   incase you want to transfer the file through FTP then you need to open the port 22 between both the servers to enable the file transfer . In your example you might want to open the default port 1433 between your servers to enable the data transfer

[spetushi]

Thanks for your reply Susant. Thx, Sokol

[spetushi]

I am hoping someone who has implemented something similar can share more details.

Thanks, Sokol