Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Facing issues while integrating R with OBIEE 12c (version-12.2.1.2.0)

Received Response
11
Views
1
Comments
Jayshree Shervegar
Jayshree Shervegar Rank 1 - Community Starter

Hi,

I'm trying to install R with my OBIEE 12c Application by referring standard Oracle Document.

I changed Proxy.txt file to valid Inputs and then tried to install R through CMD but an exception occurred stating that "Unknown Host Exception".

Then I searched for this error and got to know Internet connection is prerequisites in this Installation of R and R packages.


Now I have 3 queries regarding this issue.

1. Is R supported for this OBIEE version  (version-12.2.1.2.0) ?

2. If supported, Do I need some pactch for resolving this issue ?

3. Any workaround/alternative for R integration if Internet connectivity is not possible on my server.

    like: get the Pre installed R package and put it in the same location and install R.exe manually in the required location.

           or in Proxy.txt file we can give another server's details where internet connectivity is there.

Thanks in advance for any suggestion or help.

Thanks & Regards,

Ashutosh Singh

Answers

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    1. Is R supported for this OBIEE version  (version-12.2.1.2.0) ?

    Yes, it is supported

    2. If supported, Do I need some pactch for resolving this issue ?

    It works with OOTB 12.2.1.2.0

    3. Any workaround/alternative for R integration if Internet connectivity is not possible on my server.

    a. proxy.txt is needed only if you have proxy server setup in your org, else you can skip that step

    b. If there is no internet connectivity, refer to the actual installpackages script and download them manually to install inside R shell.

    Example : > <span class="pln" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">install.packages</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">(<</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">pathtopackage</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">>,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;"> repos </span><span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">=</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;"> </span><span class="lit" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #7d2727;">NULL</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;"> type</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">=</span><span class="str" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #7d2727;">"source"</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">)</span>

    <span class="pun" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;"> </span>

    https://stackoverflow.com/questions/13940688/installing-package-from-a-local-tar-gz-file-on-linux