Object Naming Conventions #
Object Type | Rules | Example |
Folder | Free. Business Area Name or Application Name | ASWI_SW |
Model | Model names can be assigned freely and should match your standards. However, Model codes should be set with caution as they may be referenced by other objects within the repository. You could use the following rule for your model codes: <Technology>_<Model_Acronym> | ORACLE_COPS_INVENTORY |
Sub Model | Sub-model names can be assigned freely, but consider using the same constraints for the submodel codes as for the model codes. | ORACLE_COPS_INVENTORY_DETAILS |
Data Source, Columns | Depends on the reverse-engineering strategy selected. When creating your own datastores and columns within ODI, it is recommended that you enter object names and codes in upper case and avoid special characters such as spaces, commas, semi-colons etc. Elufa: Same as table name of the source / target database | ACCOUNTS INVOICE INVOICE_DETAILS etc. |
Primary Key | PK_< Name of the datastore > | PK_CUSTOMER |
Reference | FK___number May depend on the way foreign keys are defined in the database or application | FK_CUSTOMER_SALES_REP_001 |
Check Constraint | CK__ May depend on the way check constraints are defined in the database or application | CK_CUSTOMER_VALID_AGE |
Physical Topology: Data Server | Same as Oracle Database server name | |
Physical Topology: Physical Schema | Same as Oracle Schema | |
Reference Site
https://blogs.oracle.com/dataintegration/
ODI Parameters
https://blogs.oracle.com/dataintegration/entry/using_parameters_in_odi_the_dy_1
Oracle Data Integrator – Basic Oracle Learning Library (This is important, please take a look and try)
ODI History and Overview
http://gerardnico.com/wiki/dit/odi/odi
http://gerardnico.com/wiki/dit/odi/application
ODI Knowledge Modules – General Overview
http://gerardnico.com/wiki/dit/odi/km
ODI CDC – Overview
http://gerardnico.com/wiki/dit/odi/cdc
ODI CDC – Setup
http://gerardnico.com/wiki/dit/odi/cdc_setup
ODI Staging – Overview
http://gerardnico.com/wiki/dit/odi/staging_area
ODI 12c Agent Setup
http://gerardnico.com/wiki/dit/odi/installation_12.1.2
ODI 12c Standalone Agent
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_agent/odi12c_agent.html#overview
ODI 12c J2EE Agent
https://sarojsubramanian.wordpress.com/2015/10/14/odi-12c-with-j2ee-agent/
http://odizone.com/blog/setup-java-ee-agent-in-odi-12c/
**http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/setup_jee_agent/setup_jee_agent.htm
http://oditraining.blogspot.hk/2014/07/odi-12c-j2ee-agent-standalone-colacated.html
ODI Console
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_em_integration/odi_em_integration.htm
ODI Agent Comparision
http://www.ateam-oracle.com/odi-agents-standalone-jee-and-colocated/
ODI Best Practices
http://www.oracle.com/technetwork/middleware/data-integrator/overview/odi-bestpractices-datawarehouse-whi-129686.pdf
https://blogs.oracle.com/dataintegration/entry/top_ten_best_practises_in_orac
https://blog.cintra.com/?p=611
ODI Performance Guide
http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf
ODI Groovy & Automation
https://s3.amazonaws.com/rmc_docs/biforum2013_slides/odi_mclass_6_sdk_groovy.pdf
http://www.ateam-oracle.com/getting-groovy-with-odi-upgrades-and-owb-migrations/#OWB_ODI_migration