什么是 Oracle 数据集成器？

what is Oracle data integrator?

提问by Karthikeyan

What is ODI? what is the actual use of ODI? how oracle data integrator tool, helps with programming? what actually is the difference between an sql developer tool and an ODI tool? really fed up with the definitions found on some sites, it will be great if any one comes up with gud explanation..

什么是 ODI？ODI的实际用途是什么？oracle 数据集成工具如何帮助编程？sql 开发人员工具和 ODI 工具之间的实际区别是什么？真的厌倦了在某些网站上找到的定义，如果有人提出 gud 解释，那就太好了。

回答by mishkin

I totally agree Oracle site is confusing and these product descriptions are not for techies and written by marketing department.

我完全同意 Oracle 网站令人困惑，这些产品说明不适合技术人员并且由营销部门编写。

Let me try to explain in simple words. ODI is an ETL tool - to be precise EL-T tool. You can read more about ETL vs EL-T on wiki.

让我试着用简单的词来解释。ODI 是一个 ETL 工具——准确地说是 EL-T 工具。您可以在 wiki 上阅读有关 ETL 与 EL-T 的更多信息。

Oracle used to sell OWB (Oracle Warehouse Builder) before and then they bought ODI from Sunopsis. OWB will no longer be supported and ODI will be the tool used by many Oracle applications.

甲骨文以前卖的是OWB（Oracle Warehouse Builder），后来又从Sunopsis买ODI。将不再支持 OWB，ODI 将成为许多 Oracle 应用程序使用的工具。

You can do a lot of things with ODI but you would use it mostly to extract data from a source (files, databases), transform data in a staging area and load to your target database. ETL projects are normally take a lot of time and efforts and while you can do similar things by writing a custom code, ETL tools serve to help make these hards tasks easy for developers. ETL tools are used for data integration projects, data warehousing and so on.

您可以使用 ODI 做很多事情，但主要用于从源（文件、数据库）中提取数据、转换暂存区中的数据并加载到目标数据库。ETL 项目通常需要花费大量时间和精力，虽然您可以通过编写自定义代码来做类似的事情，但 ETL 工具有助于帮助开发人员轻松完成这些艰巨的任务。ETL 工具用于数据集成项目、数据仓库等。

If you ever heard about Microsoft SSIS tool shipped with MS SQL Server - that should give you an idea what ODI is for.

如果您听说过 MS SQL Server 附带的 Microsoft SSIS 工具 - 那应该会让您了解 ODI 的用途。

This is a good white paperthat explains how to use ODI and what the benefits are versus the custom coding.

这是一份很好的白皮书，解释了如何使用 ODI 以及与自定义编码相比有什么好处。

Oracle also came up with a version of ODI called ODI Data Services - a marketing trick to expand ODI to SOA market.

Oracle 还提出了一个名为 ODI 数据服务的 ODI 版本——一种将 ODI 扩展到 SOA 市场的营销技巧。

They also sell Golden Gate product which is intended for real-time ETL and data federation projects that can work well with other applications and web services. Data federation is a process to merge/integrate data in realtime without doing any ETL.

他们还销售用于实时 ETL 和数据联合项目的 Golden Gate 产品，这些项目可以与其他应用程序和 Web 服务很好地协同工作。数据联合是一个实时合并/集成数据而不进行任何 ETL 的过程。

Hope this helps!

希望这可以帮助！

回答by Uli

ODI is an ETL tool. It has two main advantages over competing products:

ODI 是一个 ETL 工具。与竞争产品相比，它有两个主要优势：

1) It uses an ELT type approach, i.e. all of the transformations happen on the target datawarehouse server in SQL. This means that ODI is not a black box and developers know exactly what is going on. This is great for debugging. It also means that ODI can leverage the horse power of the target warehouse server and does not require any additional application servers like traditional ETL tools, Informatica etc. It lowers the TCO.

1) 它使用 ELT 类型的方法，即所有转换都发生在 SQL 中的目标数据仓库服务器上。这意味着 ODI 不是一个黑匣子，开发人员确切地知道发生了什么。这非常适合调试。这也意味着 ODI 可以利用目标仓库服务器的马力，并且不需要像传统 ETL 工具、Informatica 等任何额外的应用程序服务器。它降低了 TCO。

2) The main advantage of ODI over competitive products is the code template approach. This guarantees extreme reusability of your and your developer's ETL code. Data transformation logic and strategies are encapsulated in so called Knowledge Modules and can be reused across your data warehouse. This may cut down development time by 30-50%.

2) ODI 相对于竞争产品的主要优势是代码模板方法。这保证了您和您的开发人员的 ETL 代码的极端可重用性。数据转换逻辑和策略封装在所谓的知识模块中，可以在整个数据仓库中重复使用。这可以将开发时间缩短 30-50%。

Links to ODI tutorialscan be found on the BI Quotient blog

可以在 BI Quotient 博客上找到ODI 教程的链接

回答by mcha

Here is a brief description found on Oracle ODI FAQ:

以下是Oracle ODI 常见问题解答中的简要说明：

What is Oracle Data Integrator (ODI)?

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services.

Which projects are suitable for Oracle Data Integrator?

Oracle Data Integrator can be used in several projects including:

• Conventional Data Integration
• Business Intelligence and Data Warehousin
• Modernization Initiatives
• Migrations and Consolidations
• Service Oriented Architecture (SOA) Initiatives
• Master Data Management

什么是 Oracle 数据集成器 (ODI)？

Oracle Data Integrator 是一个全面的数据集成平台，涵盖了所有数据集成需求：从大容量、高性能的批处理加载到事件驱动的涓流集成流程，再到支持 SOA 的数据服务。

哪些项目适合 Oracle Data Integrator？

Oracle Data Integrator 可用于多个项目，包括：

• 常规数据集成
• 商业智能和数据仓库
• 现代化举措
• 迁移和合并
• 面向服务的架构 (SOA) 计划
• 主数据管理