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, configure AI profile and configure Marketplace cloud link access.
Integration of Slack with Data Studio bridges the gap between real time collaboration between various team members in staying informed and making correct decisions.
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 Azure BLOB storage. Click + to create credentials for Microsoft Azure BLOB storage and Azure Data Lake 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.
Note:
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. Refer to Create Oracle Cloud Infrastructure Native Credentials for more details.
Click Test to test the SMTP configuration. You will view a screen that asks you to run the ACL script. You can run the script if you have the ADMIN rights. This is just a first time setting. After you receive a successful message of SMTP Test, you can save the SMTP configuration.
On the Marketplace tab, you can set the configurations you require for the Data Marketplace tool.
- Restricted, Requires Authorization:
Selecting this option enables you to publish restricted cloud links and, consequently, restricted marketplace listings. You will have the ability to grant and revoke access to these listings to specific OCIDs.
- Publish:
This option specifies who and from where you are allowed to access the registered table.
You can choose from any of the following available options:- TENANCY: You can grant remote data access to any resource, tenancy, compartment, or database in the tenancy of the Autonomous Database instance that is registering the data set. This scope is more restrictive than the REGION scope.
- COMPARTMENT: You can grant remote data access to any resource, compartment, or database in the compartment of the Autonomous Database instance that is registering the data set.
- REGION: You can grant remote data access via cloud links to other tenancies in the Autonomous Database instance that is registering the data set.
Note:
Marketplace listing currently can only be published up to the compartment level. The tool does not allow you to publish a marketplace listing to entire region for security reasons. - None: You do not have access to any resource.
- Read:
This option allows READ access for the specific user to access the registered table.
On the Slack tab you can configure your Slack profile to receive notifications on certain events while using the Jobs feature.
- Slack Credential Name: Enter the Credentials from the drop-down. The drop-down lists the credentials in your compartment. Click + to create your own credentials.
- Selecting + opens a Create Credential dialog box. Specify the following field values to create a credential:
- Credential Name: Enter a name of your choice. For example, SLACK_CRED.
- Cloud Service: Select Slack from the drop-down.
- Username: Enter your OCI user name. You must use Oracle Cloud Infrastructure User Name from your profile in the OCI console. For example:
oracleidentitycloudservice/foo@example.com.
ordefault/foo@example.com
- Password: *********. For the slack provider, the username value can be any valid string and the password is the Slack bot token.
Click Create Credential to create a new credential.
Enter this value in the Slack Credential Name field.
- Selecting + opens a Create Credential dialog box. Specify the following field values to create a credential:
-
Slack Channel ID: This specifies the Channel ID in a
String
value. The Channel ID is a unique ID for a channel and is different from the channel name. In Slack, when you view channel details you can find the Channel ID on theAbout
tab. -
Slack Message: Enter a message to test the notifications.
Click Test to test the notification. You receive a confirmation message after you successfully authenticate into Slack from Data Studio Settings.. Click Save to set the Slack Credential.
You can refer to the Create Job to set up notifications to receive Slack alerts about the status of a job run.
On the Share provider Identity tab you can provide the details of the provider before you share the data. The share provider identification will be available to recipients with whom you grant the share while using the Data Share tool. This provides information to the recipient on how to identify you.
- Name: Enter the name of the provider. For example, ams.
- Email: Enter the email address of the provider. For example, ams@gmail.com.
- Description: Enter a description of the provider. For example, AMS sharing stuff.
Click Save to save the provider identification information. You will receive a successful message of configuring the provider identification information.
Select Apply Changes to save and apply the configuration you made in the Marketplace tab of the Data Settings dialog.
You have successfully set and configured your preferences in the Data Studio Settings wizard.
- Slack Integration with Data Studio
You can integrate Data Studio with Slack on Data Studio Settings using Slack Channel ID and Credentials. With this configuration you can send or schedule reports of the Jobs feature when certain events occur in Slack. The team members of the Slack channel can view the updates, discuss the data insights, and make well informed decisions.
Parent topic: The Data Load Page