Data Studio Settings
This topic explains the Data Studio settings on the Data Studio tool.
This settings on the Data Studio navigation menu and the Data studio overview page enables you to use the associated Cloud Service, configure AI profile and configure SMTP.
This helps in defining the data during the load. This setting sets a variety of general preferences like setting default credentials to define the data you load, configure SMTP for data sharing and configure AI profile.
To set the Data Studio Settings, on the General tab of the wizard, specify the email address to configure your profile for Marketplace and Sharing.
On the Cloud Services tab of the wizard, under Cloud Object Store Access, specify the following field values:
- OCI Credential: Selecting an OCI credential enables you to discover the OCI buckets. Click + to create OCI Credentials.
- OCI Compartment: This drop-down field lists the buckets present in your compartment for loading and linking from Oracle cloud services. If you select any other cloud service provider apart from Oracle, this field displays None by default.
- AWS Credential: Selecting an AWS credential in Data Studio Settings enables you to discover the S3 buckets. Click + to create credentials for Amazon S3 cloud storage.
- Azure Credential: Selecting an Azure credential in preferences enables you to discover the to discover the Azure Blob storage. Click + to create credentials for Microsoft Azure blob storage.
Click Check Object Store Access to check if you have access to the object store. You will view a Policy Check wizard with the following bucket lists:
- OCI list buckets
- AWS list buckets
- Azure list buckets
The Object Storage Listing Policy checker evaluates if you have access to the buckets. If yes, the checker box is highlighted in green with a check sign, else the checker box displays the policy highlighted in red with a red cross.
- Oracle Cloud Interface (OCI)
- Amazon Web Services (AWS)
Click Check Cloud Service Access.
- Language- Checks if the Data Studio tool has accessed the Cloud’s language processing abilities. See Use OCI Language Service Capabilities in Data Studio for more information on this service.
- Document Understanding- Checks if the data you load into the Data Studio tool has accessed the Cloud’s Document Understanding AI ability. See Use OCI Document Understanding to extract Tables from Images for more information on this service.
- Translation- Checks if the Data Studio tool accesses the OCI Translation feature. See Perform Text Translation for more information on this service.
On the AI Profile tab of the Data Studio Settings wizard, you can configure your AI preferences.
- Select AI Profile (Experimental) from the drop-down use this AI profile for facilitating and configuring the translation of natural language prompts to SQL statements.
- To utilize the AI services in Data Studio, you must have either an OCI AI or OpenAI or Cohere or Azure OpenAI service account.
- You must also have access to
DBMS_CLOUD_AI
package to set your AI profile. - If you have Select AI set up using either OpenAI or Cohere or Azure OpenAI service, you can enhance your data by loading small reference data tables that are generated by large language models. Try out the suggested prompts or come up with your own to generate data to load into the autonomous database.
You can also use this AI profile to generate Marketplace dataset description and tags. This AI profile is used to generate table description in Catalog App.
See Use DBMS_CLOUD_AI to Configure AI Profiles to create and configure your AI profile.
-
Click Check AI Access.
The AI Policy checker checks for the following service:
- Generative AI- The Data Studio tool checks if it has access to the Generative AI service.
-
Click View Profile to view the details related to the AI profile you use. You can view the AI Provider, AI Model and the Credential you use to create the AI profile.
- Click Create Profile to create a new AI profile. Specify the following field values:
- Profile Name: Enter the name of the AI profile. For example, OCI AI.
- AI Provider: Select any of the following providers from the drop-down field:
- OCI AI
- AI Azure
- Cohere
- Model: Select any of the following models from the drop-down field:
- Llama
- Cohere
- Credential: Select any of the credentials from the drop-down to create an AI profile.
- Click Show Code to view the equivalent PL/SQL code to create AI profile.
BEGIN C##CLOUD$SERVICE.DBMS_CLOUD_AI.CREATE_PROFILE( PROFILE_NAME => 'new_profile', ATTRIBUTES => '{"credential_name":"my_credential_name","model":"","provider":""}'); END; /
Click Create AI Profile.
You have successfully set and configured your AI profile in the Data Studio Settings wizard.
You must configure SMTP only once and then the system uses the saved configuration from that point forward.
- Server host: Enter the endpoint used to send the email. For example, internal-mailrouter.oracle.com.
- Server port: Enter the SMTP port used to accept an email. Email Delivery supports TLS on port 25. Sender:
- Enter the email address of the sender. For example, oaapgens_us@oracle.com.
- Server Encryption: This field indicates if TLS, the standard means of performing encryption in transit for emails, is being used. Providers must encrypt emails while it's in transit to the Oracle Cloud Infrastructure Email Delivery service. Encrypted emails are protected from being read during transit. If there is no encryption, enter, None.
- Select credential to use for SMTP connection from the drop-down. If there is no available credential in the drop-down, you can create credential by clicking Create Credential icon.
Click Save to save your changes and Test the test the ongoing process of setting preferences.
You have successfully set and configured your preferences in the Data Studio Settings wizard.
Parent topic: The Data Load Page