Prerequisites to Create a Data Source

Before you create a data source, you must set up the database to create a schema user.

Complete the following step to create a schema user:

1. Create a schema user for the datasource.

   For example, let's create hello schema user:

   create user hello identified by "<password>";
   
   GRANT CONNECT TO hello;
   GRANT RESOURCE TO hello;
   GRANT DBA TO hello;
   
   GRANT CREATE SESSION TO hello;
   GRANT UNLIMITED TABLESPACE TO hello;
   
   ALTER SESSION SET CURRENT_SCHEMA = hello;
   
   CREATE TABLE products
   ( product_id number(10) not null,
   product_name varchar2(50) not null,
   CONSTRAINT products_pk PRIMARY KEY (product_id)
   );
   
   insert into products values
   (1, 'lamp');
   
   commit;

2. Add the schema user that you created in step 1 to the model Yaml template.

   Example:

   Properties:
               user:
                 Value:<schema user name>