How do we connect EPM Cloud Narrative Reporting to On-Premise Essbase cubes.

Summary:

We are trying to connect EPM Cloud Narrative Reporting to On-Premise Essbase cubes. I am looking for information on the architecture of this connection, how it can be implemented (like what port/whitelisting rules/firewalls need to be opened on OnPrem server), authentication mechanism and what security protocols (SSL TLS etc) should be in place etc.

Content (required):

We are using 'Oracle Essbase Analytic Provider Services (APS)' datasource type on Narrative Reporting, for making this connection.

Version (include the version you are using, if applicable):

Version of Narrative Reporting: 21.09.61