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)