什么是Oracle数据集成商?

本文介绍了什么是Oracle数据集成商?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

什么是ODI? ODI的实际用途是什么? oracle数据集成器工具如何帮助编程? sql开发人员工具和ODI工具之间的实际区别是什么?确实厌倦了某些网站上的定义，如果有人提出解释会很棒..

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..

推荐答案

我完全同意Oracle站点令人困惑，并且这些产品描述不适合技术人员使用，而由营销部门撰写.

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

让我尝试用简单的词来解释. ODI是一种ETL工具-确切地说是EL-T工具.您可以在Wiki上阅读有关ETL vs EL-T的更多信息.

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.

Oracle以前曾经出售过OWB(Oracle Warehouse Builder)，然后又从Sunopsis购买了ODI. OWB将不再受支持，ODI将成为许多Oracle应用程序使用的工具.

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.

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

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.

如果您听说过MS SQL Server附带的Microsoft SSIS工具-应该可以使您了解ODI的用途.

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

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

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

Oracle还提出了一个称为ODI Data Services的ODI版本，这是一种将ODI扩展到SOA市场的营销技巧.

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

他们还出售Golden Gate产品，该产品用于实时ETL和数据联合项目，可以与其他应用程序和Web服务一起很好地工作.数据联合是一种无需进行任何ETL即可实时合并/集成数据的过程.

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.

希望这会有所帮助！