Oracle Data Integrator 12c-model and data storage (DataStore)

Source: Internet
Author: User

First, the concept

Model Model:

A model that describes relational data. is a set of data stores that are stored in a specific technology, such as Oracle. For example, when the technology is Oracle, the scheme corresponding to the database

DataStore: Data Storage

A model contains metadata that corresponds to a table or view in the scheme in which the model resides. Can be imported from a real environment via reverse engineering (reverse-engineered) or created in ODI

Second, the supported operation

Test form

DROP TABLEDEPT;CREATE TABLEDEPT (DEPTNO Number(2)CONSTRAINTPk_deptPRIMARY KEY, DnameVARCHAR2( -), LOCVARCHAR2( -));DROP TABLEEMP;CREATE TABLEEMP (EMPNO Number(4)CONSTRAINTPk_empPRIMARY KEY, enameVARCHAR2(Ten), JOBVARCHAR2(9), MGR Number(4), HireDate DATE, SAL Number(7,2), COMM Number(7,2), DEPTNO Number(2)CONSTRAINTFk_deptnoREFERENCESDEPT);
View Code

Inserting data

INSERT  intoDEPTVALUES(Ten,'ACCOUNTING','NEW YORK');INSERT  intoDEPTVALUES( -,' the','DALLAS');INSERT  intoDEPTVALUES( -,'SALES','CHICAGO');INSERT  intoDEPTVALUES( +,'OPERATIONS','BOSTON');INSERT  intoEmpVALUES(7369,'SMITH','Clerk',7902, To_date ('17-12-1980','dd-mm-yyyy'), -,NULL, -);INSERT  intoEmpVALUES(7499,'ALLEN','salesman',7698, To_date ('20-2-1981','dd-mm-yyyy'), the, -, -);INSERT  intoEmpVALUES(7521,'WARD','salesman',7698, To_date ('22-2-1981','dd-mm-yyyy'),1250, -, -);INSERT  intoEmpVALUES(7566,'JONES','MANAGER',7839, To_date ('2-4-1981','dd-mm-yyyy'),2975,NULL, -);INSERT  intoEmpVALUES(7654,'MARTIN','salesman',7698, To_date ('28-9-1981','dd-mm-yyyy'),1250,1400, -);INSERT  intoEmpVALUES(7698,'BLAKE','MANAGER',7839, To_date ('1-5-1981','dd-mm-yyyy'),2850,NULL, -);INSERT  intoEmpVALUES(7782,'CLARK','MANAGER',7839, To_date ('9-6-1981','dd-mm-yyyy'),2450,NULL,Ten);INSERT  intoEmpVALUES(7788,'SCOTT','ANALYST',7566, To_date ('13-jul-87')- -, the,NULL, -);INSERT  intoEmpVALUES(7839,'KING','President',NULL, To_date ('17-11-1981','dd-mm-yyyy'), the,NULL,Ten);INSERT  intoEmpVALUES(7844,'TURNER','salesman',7698, To_date ('8-9-1981','dd-mm-yyyy'), the,0, -);INSERT  intoEmpVALUES(7876,'ADAMS','Clerk',7788, To_date ('13-jul-87')-Wuyi,1100,NULL, -);INSERT  intoEmpVALUES(7900,'JAMES','Clerk',7698, To_date ('3-12-1981','dd-mm-yyyy'),950,NULL, -);INSERT  intoEmpVALUES(7902,'FORD','ANALYST',7566, To_date ('3-12-1981','dd-mm-yyyy'), the,NULL, -);INSERT  intoEmpVALUES(7934,'MILLER','Clerk',7782, To_date ('23-1-1982','dd-mm-yyyy'),1300,NULL,Ten);
View Code 2.1 Create models and reverse engineer

New Model icon, designer, model,

In the Model dialog box, under the Definition tab, enter the name ODI_SRC, select the technology Oracle and the logic scheme ODI_SRC

Under the "Reverse Engineering" tab, select the context, if not created context is global, select "Object type to reverse engineer" such as "table, view", and so on, only select table, save.

Right-click Model-Reverse engineering reverse engineering all the tables under the physical scheme corresponding to the logical scheme.

You can also check "selective reverse engineering" in "selective reverse engineering" and the table to reverse engineer, click Reverse Engineering, reverse engineer only for the selected table.

In reverse engineering

When the reverse engineering is complete, you'll see the built-in model in the designer's model box:

Similarly, new models are odi_tag and reverse engineered

2.2 import and export of models

Right-click Model, Export,

A mod_odi_src.xml file is generated that can be used to import

2.3 View Datastore ( Data Storage ) Data

Right-click the model to view the data

2.4 Create a new data store and synchronize to a database

STEP1 Right-click Model, new data store

STEP2 Input Table name

STEP3 Add attributes Step4 Add keywords, index, etc.

STEP5 generates a DDL that generates a procedure under the path you specify

STEP6 the execution process can be synchronized to the database

One more table in the database

2.5 Build Service 2.6 changed data capture

Oracle Data Integrator 12c-model and data store (DataStore)

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.