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

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)