Create a repository using Oracle Data Integrator Studio

Source: Internet
Author: User

First, Creating the Database Schema
/*1th Step: Create a temporary table space*/Create Temporarytablespace user_temp tempfile'C:\app\ORACLE\oradata\orcl\user_temp.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local; /*2nd Step: Create a data table space*/Createtablespace user_data Logging datafile'C:\app\ORACLE\oradata\orcl\user_data.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local; /*3rd Step: Create a user and specify a tablespace*/Create UserOdi_repo identified byOdi_repodefaulttablespace user_dataTemporarytablespace user_temp; /*4th Step: Grant permissions to the user*/GrantConnect,resource,dba toOdi_repo;
Second, create Master Repository "and connect

Starting Odi64.exe, running the new Master Repository Wizard

Configure connection information, user name and port created for the first step

Ignore, character encoding issues

Enter the supervisor password

Created in

Created successfully

odi→ Connect New Login

Enter Repository connection information

When the connection succeeds, the Designer tab page is grayed out because the project exists in the repository

III. Create a work repository and connect

Log in to the Master repository, select topology → main repository Right-click New Job Repository,

By default, you can.

specifying types, developing

Log in to find the designer is not grayed out, indicating that the data archive successfully landed.

Create a repository using Oracle Data Integrator Studio

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.