How to access Remote Oracle SQL Database using R in Google Colab

msreevani · July 15, 2021, 1:26pm

Dear All,

I am not having proper idea to connect Remote Oracle SQL Database using R in Google Colab. Can anyone please assist me how to access ASAP ?

AndyR · July 16, 2021, 12:50am

Hi @msreevani ,
Certainly you can connect them, more info below:

gist.github.com

https://gist.github.com/FranckPachot/7fd9dec0d38a2326e0ab41151b88687f#file-oracleconnectiontocloud-ipynb

oracleconnectiontocloud.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "OracleConnectionToCloud.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },

This file has been truncated. show original

Above are the detailed instructions, the example is with python, but i think there should be no difference.

This is a plus to extract the better from Oracle and R
Hope this helps.

system · August 6, 2021, 12:51am

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.