Working with Python Data Studio API for Autonomous Database

Python Data Studio API package works both in OML notebook and as a standalone application.

You can view the REST API endpoints hosted on Oracle Autonomous Database. These endpoints allow you to store Machine Learning models along with their metadata, and create scoring endpoints for the model.

Connecting to Autonomous Database

To connect to the Autonomous Database via your username and password, run the following command:
import adp 
adp_instance = adp.login('<url>', '<username>', '<password>')
Here are the parameters and their descriptions:

url: This specifies the Database Actions host. For example, https://abcdefg.oraclecloudapps.com.

username:This specifies the schema name.

password:This specifies the password to the schema.

Connecting inside OML Notebooks

Login inside OML notebooks by entering the following command:
import adp
adp_instance = adp.connect()

The return value of the login method is an instance of class that contains all Autonomous Data Platform (ADP) functions.

The Adp class instance consists of the following inner classes:
  • Ingest
  • Analytics
  • Insight
  • Miscellaneous
  • Data Share

Refer to the following functions in the subsequent chapter.