Heterogén adatelérés OWB-vel: ODI EE Enterprise ETL

Posted by Fekete Zoltán on Oracle Blogs See other posts from Oracle Blogs or by Fekete Zoltán
Published on Fri, 28 May 2010 06:59:22 +0100 Indexed on 2010/05/28 7:42 UTC
Read the original article Hit count: 396

Filed under:

ODI

|

OWB

|

adatintegráció

|

heterogén

Az elozo ketto blogbejegyzéshez kapcsolódva felmerül a kérdés: Hogyan lehet az Oracle Warehouse Builderrel heterogén adatforrásokat elérni?
Ajánlott olvasmány: Oracle Warehouse Builder 11gR2: OWB ETL Using ODI Knowledge Modules

Természetesen az OWB az Oracle Database Heterogeneous Services-zel ODBC-vel illetve Oracle Gateway-k alkalmazásával eddig is lehetett mindenféle ODBC kompatibilis továbbá mainframe-es adatbázisokat elérni. Oracle Database Gateways: MS SQL Server, Sybase, Teradata, Informix, ODBC, DRDA, APPC, WebSphere MQ, DB2, DB2/400.
A megfelelo Application Adapters megvásárlásával lehet csatlakozni az OWB-vel például a következo forrásokhoz: SAP, Oracle E-Business Suite, Peoplesoft, Siebel, Oracle Customer Data Hub (CDH), Universal Customer Master (UCM), Product Information Management (PIM).
Az OWB 11gR2-tol kezdve az OWB tudja használni az Oracle Data Integrator Knowledge moduljait a heterogén adatelérésre, ez JDBC-vel illetve más heterogén elérési módokkal.
Ajánlott olvasmány: Oracle Warehouse Builder 11gR2: OWB ETL Using ODI Knowledge Modules
Letöltés: Oracle Warehouse Builder.
BTW az OWB Java-s kliens szoftver Linux-on és Windows-on is használható. A szerver oldal pedig természetesen az Oracle adatbázisban fut: Solaris, Linux, HP-UX, AIX, Windows operációs rendszereken.

© Oracle Blogs or respective owner

Related posts about ODI

New Feature in ODI 11.1.1.6: ODI for Big Data

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Normal 0 false false false EN-US X-NONE X-NONE … >>> More
ODI 12c - Installing ODI Studio

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Today the 12c release of the Oracle Data Integrator was made GA on OTN. Once you have downloaded and are running the installer, if you want to install the ODI Studio, ensure you select 'Enterprise Installation' as this is where the ODI Studio for 12.1.2 can be installed from. If you choose 'Standalone… >>> More
Heterogén adatelérés OWB-vel: ODI EE Enterprise ETL

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Az elozo ketto blogbejegyzéshez kapcsolódva felmerül a kérdés: Hogyan lehet az Oracle Warehouse Builderrel heterogén adatforrásokat elérni? Ajánlott olvasmány: Oracle Warehouse Builder 11gR2: OWB ETL Using ODI Knowledge Modules Természetesen az OWB az Oracle Database Heterogeneous Services-zel ODBC-vel… >>> More
ODI and OBIEE 11g Integration

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Here we will see some of the connectivity options to OBIEE 11g using the JDBC driver. You’ll see based upon some connection properties how the physical or presentation layers can be utilized. In the integrators guide for OBIEE 11g you will find a brief statement indicating that there actually is a… >>> More
OWB/ODI Users: Last Chance to Submit and Vote On Sessions for OpenWorld 2010

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Now is the last chance for OWB and ODI users to propose new ETL/DW/DI sessions for OpenWorld! Oracle OpenWorld 2010 "Suggest a Session" lets members of the Oracle Mix community submit and vote on papers/talks for OpenWorld. The most popular session proposals will be included in the conference… >>> More

Related posts about OWB

OWB – How to update OWB after Database Cloning

as seen on Oracle Blogs - Search for 'Oracle Blogs'
One of the most commonly asked questions led to one of the most commonly accessed support documents (strange that) for OWB is the document describing how to update the OWB repository details after cloning the Oracle database. The document in the Oracle support site has id 434272.1, and is titled 'How… >>> More
OWB 11.2.0.2: Managing Use of Optional OWB Features

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Most OWB users know that parts of Warehouse Builder are covered with the database license and others require additional options (such as the Oracle Data Integrator Enterprise Edition license). Warehouse Builder 11.2.0.2 adds the ability to disable optional feature groups. This lets you avoid the… >>> More
OWB 11gR2 – Flexible and extensible

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The Oracle data integration extensibility capabilities are something I love, nothing more frustrating than a tool or platform that is very constraining. I think extensibility and flexibility are invaluable capabilities in the data integration arena. I liked Uli Bethke's posting on some extensibility… >>> More
Installing Multiple OWB Patches

as seen on Oracle Blogs - Search for 'Oracle Blogs'
When an OUBI bug requires a fix to the Oracle Warehouse Builder (OWB) code, the fix is delivered as an MDL export file that will need to be imported and deployed in OWB. If more than one bug is being patched, then a recent question came in that asked if it would be possible to import one after the… >>> More
OWB 11gR2: Migration and Upgrade Paths from Previous Versions

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Over the next several months, we expect widespread adoption of OWB 11gR2, both for its new features and because it is the only release of Warehouse Builder certified for use with database 11gR2. Customers seeking to move existing environments to OWB 11gR2 should review the new whitepaper, OWB 11.2:… >>> More