Create an external resource

OceanBase Developer Center (ODC) allows you to create an external resource in the visual interface.

Background information

Currently, ODC external resources are specifically used for external storage functions. You can upload Java and Python program files to create external resources. By supporting Java UDFs and Python UDFs, you can integrate a large number of Java and Python ecosystem products into OceanBase Database, thereby improving the efficiency of UDF development.

For example, OceanBase Database manages the dependencies of external stored procedures such as Java UDF Jar packages through external resources. You need to upload the Jar package by using the DBMS_JAVA.LOADJAVA system package function and reference the external resource corresponding to the Jar package in the created Java UDF. There is no strict requirement on the order of uploading external resources and creating UDFs. As long as the resources are uploaded before the UDFs are called. In addition, one external resource can be used by multiple UDFs.

1. Enter the resource name.

2. Select the resource type.

3. Select the file to upload.

4. Edit the description.

5. Click Create.

Prerequisites

You have the permission to create an external resource in the target database. For information about how to apply for a permission, see Apply for project permissions, Apply for database permissions.

Procedure

1. Log in to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click External Resources in the left-side navigation pane to get a list of external resources.

2. In the upper-right corner of the external resources list, click + to create an external resource.

3. In the Create External Resource dialog box, specify the required parameters and click Create. The following table describes the parameters.

   Parameter	Description
   Resource Name	The display name of the external resource.
   Resource Type	The type of the external resource. Valid values: JAVA_JAR and PYTHON_PY.
   Upload File	The file to upload. The file format must be .jar, .py, or .zip.
   Description	The description of the external resource.

4. After you create an external resource, you can view it in the external resources list.

References

• Create a table
• Create a view
• Create a materialized view
• Create a function
• Create a stored procedure
• Create a sequence
• Create a program package
• Create a trigger
• Create a type
• Create a synonym