Month: July 2014

Oracle Data Integrator: What is a Repository?

by Brent Dayley, Senior Instructor at Oracle University

While teaching Oracle University classes on Oracle Data Integrator, I often instruct my students that it takes roughly one and a half days to understand the setup that we do in ODI Studio in order to start to map data from source to target. I start out by giving them a visual tour of the four navigators: Topology, Security, Designer and Operator. After giving them the visual overview, I begin teaching about the tasks that need to be done in the Topology Navigator to get started mapping data from source to target. The Topology Navigator includes a number of different sections that are used to describe the Information System that will be used for source, staging and target tasks. Among the different sections of the Topology Navigator is the “Repositories” section:

pic1

Often I get perplexed looks regarding the Repositories and it sometimes seems to cause thoughts of “Black Magic”.

Simplifying the Mysterious:

Simply put, the Repositories are nothing more than ODI objects that map to storage areas that contain database objects, such as tables, that hold information about what we are doing in ODI. At the very least, we need to create two repositories, a Master Repository and a Work Repository, and usually a modified Work Repository for production purposes called an Execution Repository. Even though these repositories are described as two separate ODI objects, they can point to one or more actual database schemas:

pic2

Proprietary Database Required?

No, ODI does not require a proprietary database engine type. The repositories can be Oracle-based, or a number of other database types:

pic3

ODI offers flexible methods for creating the database objects that store the information about what we are doing in ODI Studio and we do make recommendations regarding which is the preferred method when setting up the repositories with an Oracle database. One of the repository creation methods is to use a separate utility, called the “Repository Creation Utility” or more commonly referred to as “RCU”, to create the repositories. The RCU is the preferred method when creating repositories in 12c, because of the auditing infrastructure, however ODI Studio also has Master and Work repository creation methods built in. When using RCU, both the Master and Work repositories will default to pointing to the same storage schema in the database. When creating the repositories using the ODI Studio methodology, one can use the same or separate database schemas to house the repository tables. Here is an example of two separate schemas in MySQL that are used for the Master and Work repository tables. SNPM1 holds the Master repository tables and SNPW1 holds the Work repository tables:

pic4

pic5

pic6

Here is an example of some of the type of information that is held in a typical repository table, in this case the name of a project that has been created in the Designer Navigator:

pic7

I hope that you have learned a little bit about our outstanding Oracle Data Integrator. I hope to meet you in one of my upcoming 11g or 12c classes!

Take Oracle Data Integrator Training

About the Author:

brentdayley

Mr. Brent Dayley is a Senior Instructor with Oracle University. Brent has worked at Oracle for over 10 years and teaches the SQL, PL/SQL, Application Express, Oracle Database Administration, SQL Tuning , MySQL and Data Integrator classes.

Oracle Data Integrator: What is a Repository?

by Brent Dayley, Senior Instructor at Oracle University

While teaching Oracle University classes on Oracle Data Integrator, I often instruct my students that it takes roughly one and a half days to understand the setup that we do in ODI Studio in order to start to map data from source to target. I start out by giving them a visual tour of the four navigators: Topology, Security, Designer and Operator. After giving them the visual overview, I begin teaching about the tasks that need to be done in the Topology Navigator to get started mapping data from source to target. The Topology Navigator includes a number of different sections that are used to describe the Information System that will be used for source, staging and target tasks. Among the different sections of the Topology Navigator is the “Repositories” section:

pic1

Often I get perplexed looks regarding the Repositories and it sometimes seems to cause thoughts of “Black Magic”.

Simplifying the Mysterious:

Simply put, the Repositories are nothing more than ODI objects that map to storage areas that contain database objects, such as tables, that hold information about what we are doing in ODI. At the very least, we need to create two repositories, a Master Repository and a Work Repository, and usually a modified Work Repository for production purposes called an Execution Repository. Even though these repositories are described as two separate ODI objects, they can point to one or more actual database schemas:

pic2

Proprietary Database Required?

No, ODI does not require a proprietary database engine type. The repositories can be Oracle-based, or a number of other database types:

pic3

ODI offers flexible methods for creating the database objects that store the information about what we are doing in ODI Studio and we do make recommendations regarding which is the preferred method when setting up the repositories with an Oracle database. One of the repository creation methods is to use a separate utility, called the “Repository Creation Utility” or more commonly referred to as “RCU”, to create the repositories. The RCU is the preferred method when creating repositories in 12c, because of the auditing infrastructure, however ODI Studio also has Master and Work repository creation methods built in. When using RCU, both the Master and Work repositories will default to pointing to the same storage schema in the database. When creating the repositories using the ODI Studio methodology, one can use the same or separate database schemas to house the repository tables. Here is an example of two separate schemas in MySQL that are used for the Master and Work repository tables. SNPM1 holds the Master repository tables and SNPW1 holds the Work repository tables:

pic4

pic5

pic6

Here is an example of some of the type of information that is held in a typical repository table, in this case the name of a project that has been created in the Designer Navigator:

pic7

I hope that you have learned a little bit about our outstanding Oracle Data Integrator. I hope to meet you in one of my upcoming 11g or 12c classes!
Take Oracle Data Integrator Training

About the Author:

brentdayleyMr. Brent Dayley is a Senior Instructor with Oracle University. Brent has worked at Oracle for over 10 years and teaches the SQL, PL/SQL, Application Express, Oracle Database Administration, SQL Tuning , MySQL and Data Integrator classes.

Oracle支持服务网上讲座(2014年8月)

在线讲座

主题 描述 日期时间 报名
My Oracle Support 版本14.3新特性 新的My Oracle Support 14.3版本带来的变化,以帮助您更有效地与Oracle支持工作。
本讲座是针对My Oracle Support的常规用户,并希望很快了解新功能和改进的客户。此外,本讲座还提供了参考资料,以进一步学习Oracle支持的资源。
8月12日11:00 报名
My Oracle Support 客户用户管理员技巧 客户用户管理员(CUA)研讨会针对新的Oracle客户支持环境的客户,以及那些想更好地了解My Oracle Support门户不同层次的访问控制的用户。

本讲座让客户了解My Oracle Support的管理和访问模型。将包括用户类型,客户用户管理员(CUA)的基本功能,有效地使用您的CUA最佳做法,CUA如何使用My Oracle Support快速,轻松地管理访问请求和变更。

8月13日11:00 报名
使用支持标识符组

客户不再仅限于Oracle提供/生成的支持标识符(SI) 。随着支持标识符集团功能,客户用户管理员(CUA)现在可以创建新的支持标识符,或使用现有的支持标识符为基础,将硬件资产,软件许可证以及用户分到最适合您的商业模式的分组中。加入我们的讲座一起回顾支持标识符组可用的选项,你需要知道如何才能妥善规划,创建和管理它们。时长:30分钟

8月14日11:00 报名
使用新的 My Oracle Support社区平台

My Oracle Support的社区迁移到一个新的平台,以提高你的经验。用户将能够利用新的和改进的功能来与Oracle,同行和其他用户互动来讨论和解决问题。加入我们的新平台,学习新的概念,并开始体验您的新社区。

8月26日11:00 报名
WebLogic 12.1.3 新特性介绍

这个一小时会议为用户介绍WebLogic最新版本12.1.3 的性特性,在这个会议中几乎涵盖了所有WebLogic新特性的介绍以及一些重要特性的功能演示

主要内容包括:
  • weblogic新特性的介绍
  • 一些新特性的最佳实践
如果时间允许,还会有一个简短的现场演示和QA环节。Oracle Advisor Webcasts致力于帮您更深地理解我们的产品和服务。本次会议不会替代Oracle Global Support Services所提供的服务。
8月27日14:00 报名
在My Oracle Support中寻找解决方案

“在My Oracle Support寻找解决方案”的讲座是为那些每天处理日常问题和使用Oracle产品而产生的问题的客户设计的。即使对My Oracle Support有经验的用户可能会在本讲座中发现一些有用的技巧和技术。

本讲座旨在为客户获得My Oracle Support的搜索提供专业知识,了解如何为特定的信息需求选择最好的搜索技术,以及参与My Oracle Support的社区提出问题,并找出解决办法推荐的最佳做法。持续时间:30分钟。

8月27日11:00 报名

Say Hello To Oracle Linux 7.0….

Seems like it’s going to be a week of new releases only. Last night only, I downloaded and installed Oracle database 12c patchset(12102) and today, Oracle Linux’s latest release OL7 is released. The download is available from E-Delivery portal and mine is going on. I don’t think it would take long before 12c would be …

Oracle TimesTen 内存数据库更名通告

Oracle TimesTen 内存数据库

Oracle 内存数据库高速缓存产品名称变更
    自2014年6月11日起生效,Oracle 数据库企业版下的 Oracle 内存数据库高速缓存(Oracle In-Memory Database Cache)产品组件已经被更名为 Oracle TimesTen应用层数据库高速缓存(Oracle TimesTen Application-Tier Database Cache)。Oracle 技术商业价格表已经更新,以反映这种变化。
    Oracle TimesTen 应用层数据库高速缓存 使客户能够缓存 Oracle 数据库表的子集到 TimesTen 数据库,并在应用层上运行。对于 OLTP 事务,缓存表可以像常规关系型表一样,通过使用 SQL 和 PL / SQL 从 Java,C + +,NET,和 C 程序被访问。事务在 TimesTen 数据库,通过自动本地持久化,事务一致性,以及与 Oracle 数据库同步方式被执行。欲了解更多信息,请访问OTN上的 TimesTen 产品中心

    TimesTen 内存分析功能可运行在独立的 TimesTen 产品上
    自2014年6月11日起生效,现有的 TimesTen 内存分析功能,包括基于数据字典的列压缩和星形连接优化,现提供给所有TimesTen 的授权客户。更多关于该功能在不同的 TimesTen 产品许可证的可用性的详细信息,请参阅TimesTen Licensing 文档

TimesTen 11.2.2.7 版本发布
    TimesTen 11.2.2.7 现已发布并可以下载全平台版本。该版本新增加了一些功能,其中包括:
        更快速的 TimesTen 数据库重启时间,使用并行操作从 SSD/Flash 存储加载到主内存
        TimesTen 复制功能进一步得到增强来复制 DDL 操作。
        TimesTen 交互 SQL 工具(ttIsql)增加了一些功能来增强用户体验
    更多详情,请参阅 TimesTen11.2.2.7.0 版本说明

Exalytics 认证
    TimesTen 11.2.2.7.2 认证了 OBIEE 11.1.1.7.x 来支持当前运行在 Exalytics PS3 和 PS4 软件上的Exalytics 用户。Exalytics 用户可以通过 My Oracle Support 官网来下载 TimesTen 11.2.2.7.2 版本。更多详情,请参阅Exalytics certification matrix

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569