Oracle Data Integrator Enterprise Edition
ORACLE DATA SHEETORACLE DATA INTEGRATORENTERPRISE EDITIONOracle Data Integrator Enterprise Edition delivers high-performance datamovement and transformation among enterprise platforms with its open andintegrated E-LT architecture and extended support for Big Data. Oracle DataIntegrator Enterprise Edition is critical to leveraging data integration initiativeson-premise or in the cloud, such as Big Data management, Service OrientedArchitecture and Business Intelligence. An easy-to-use user interfacecombined with a rich extensibility framework helps Oracle Data IntegratorEnterprise Edition improve productivity, reduce development costs and lowertotal cost of ownership among data-centric architectures. Oracle DataIntegrator Enterprise Edition is fully integrated with Oracle FusionMiddleware, Oracle GoldenGate, Oracle Database, Oracle Big DataAppliance and Exadata to put data at the center of your enterprise. OracleData Integrator Enterprise Edition is open and standards-based to work with3rd party applications as well as Oracle’s applications.KEYFEATURESOut-of-box integration withdatabases, Hadoop, ERPs, CRMs,B2B systems, flat files, XML, JSON,LDAP, JDBC, ODBCKnowledge module frameworkfor extensibilityAbout Oracle’s Data Integration SolutionsOracle is a leader in the Data Integration market, with the industry’s mostcomprehensive fully-integrated offering for data integration, including Oracle DataIntegrator Enterprise Edition, Oracle GoldenGate, Oracle Enterprise Data Quality,Oracle Big Data Preparation Cloud Service and Oracle Enterprise MetadataManagement. Oracle’s Data Integration solutions provide continuous access totimely, trusted, and heterogeneous data across the enterprise to support bothPowerful data transformation forheterogeneous database and BigData infrastructuresanalytical and operational data integration.Rich ETL for Oracle databases includingOracleExadata,withcomplexdimension and cube loading supportNew capabilities included in Oracle Data Integrator Enterprise Edition 12c include:Integrates with Oracle GoldenGatefor real-time data warehousingMetadata-driven data lineage andimpact analysis with OracleEnterprise Metadata ManagementIntegrates with Oracle EnterpriseData Quality for advanced profiling,What’s new in 12c? Superior productivity with a new flow-based declarative user interface. Theenhanced user experience is simple yet powerful and comprehensive; theability to seamlessly reuse mapping logic speeds up development and overalltime to solution. Improved parallelism functionality increases Oracle Data Integrator’salready high performance architecture. High performance E-LT capabilities integrated with Oracle GoldenGate toenable faster and more efficient loading and transformation of real-time datainto a data warehouse or Big Data system. Customers can now easilyconfigure and deploy real-time data warehousing solutions without impactingsource systems or batch window dependencies.
ORACLE DATA SHEETcleansing, matching anddata governance needs. Migration utility and improved interoperability with Oracle WarehouseBuilder, providing the tools and foundation for customers to migrate toOracle’s strategic Oracle Data Integrator platform.KEYBENEFITSNative big data Support Direct integration into Oracle Enterprise Manager Cloud Control 12c forimproved IT productivity in monitoring Oracle technology and applicationsfrom one central location. Extended big data support in unifying integration tooling via industrystandards across unstructured/semi-structured and structured data. Release management capabilities to allow customers to better manage theircode as well as their development, testing and production environments.This includes a deep integration with Apache Subversion.Leading PerformanceImproved ProductivityFlexibilityLow Total Cost of OwnershipExpanded Heterogeneity to bigdata sources and targetsOracle Data Integrator for Big DataUNIQUE B E N E F I T SOracle Data Integrator brings critical big data integration capabilities to enterprises. It bringsCuts hardware costs through improvedutilization and high-performance dataintegrationUnifies data-based, event-based,and service-based integration in asingle solutionLowers total cost of ownership andby maximizing designer productivityOpen, 100% Java, SOA,Standards basedSupports heterogeneoussources, targets and applicationsheterogeneity to Big Data by extending support to Hadoop standards. Through its decoupleddesign and implementation principles, ODI mappings seamlessly can switch betweenunderlying Big Data technologies. Currently ODI for Big Data natively supports Spark, SparkStreaming, Hive, Kafka, Cassandra, HBase, Sqoop and Pig. ODI also supports ApacheOozie scheduling, in addition to the traditional ODI agent to schedule and orchestrate bigdata mappings, procedures, packages and scenarios. Out of the box Knowledge Modulesprovide quick implementation and time to value to big data projects.Click here to learn more about Oracle Data Integrator for Big Data.Simplifying the Complexity of Data IntegrationOracle Data Integrator Enterprise Edition addresses multiple enterprise dataintegration needs. Data Warehousing and Business Intelligence—by executing high-volume, highperformance loading of data warehouses, data marts, On Line AnalyticalProcessing (OLAP) cubes, and analytical applications, Oracle Data Integratortransparently handles incremental loads and slowly changing dimensions,manages data integrity and consistency, and analyzes data lineage. Big Data—by providing prebuilt integration with big data technologies, such asSpark, Pig, HDFS, Hive, HBase or Sqoop, businesses are able to leverageadditional sources of data previously too large and unwieldy to gain benefits from.Oracle delivers integration for big data technologies leveraging a metadata drivenprocess while enabling data integration resources to easily manage how big datais extracted, loaded, and transformed. Service-Oriented Architecture (SOA)—by calling on external services for dataintegration and by deploying data services and transformation services that canbe seamlessly integrated within an SOA infrastructure. Oracle Data Integrator’sarchitecture additionally provides support for high-volume, high-performance bulkdata processing to an existing service-oriented architecture. Master Data Management (MDM)—by providing a comprehensive datasynchronization infrastructure for customers who build their own data hubs, work withpackaged MDM solutions, or coordinate hybrid MDM systems with integrated SOAprocess analytics and Business Process Execution Language (BPEL) compositions. Migration—by providing efficient bulk load of historical data (including complextransformations) from existing systems to new ones. Oracle GoldenGate thenseamlessly synchronizes data for as long as the two systems coexist, and OracleData Integrator continues to complement as needed for transformations.RELATEDPRODUCTSANDSERVICESOracle Data Integrator EnterpriseEdition delivers unique nextgeneration, extract load and transform(E-LT) technology that improvesperformance, reduces data integrationcosts and improves productivity.RELATEDPRODUCTSOracle Data Integrator EnterpriseEdition Big Data OptionsOracle GoldenGateOracle Enterprise Data QualityOracle Enterprise MetadataManagementOracle ExadataOracle Big Data ApplianceOracle Business Intelligence2 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
ORACLE DATA SHEETOracle SOA SuiteOracle DatabaseE-LT Architecture for High PerformanceOracle Data WarehousingOracle Master Data ManagementOracle Data Integrator Enterprise Edition’s Extract, Load, Transform (E-LT)architecture leverages disparate relational database management systems (RDBMS)or Big Data engines to process and transform the data. This approach optimizesperformance and scalability and lowers overall solution costs.Instead of relying on a separate, conventional ETL transformation server, Oracle DataIntegrator Enterprise Edition’s E-LT architecture generates native code for disparateRDBMS or big data engines (SQL, HiveQL, PySpark, Pig Latin or bulk loader scripts,for example). The E-LT architecture extracts data from the disparate sources, loads itinto a target, and executes transformations using the power of the database orHadoop. By leveraging existing databases and big data infrastructures, Oracle DataIntegrator Enterprise Edition provides unparalleled efficiency and lower cost ofownership. By reducing network traffic and transforming data in the server containingthe target data, the E-LT architecture delivers the highest possible performance.Heterogeneous SupportOracle Data Integrator Enterprise Edition provides heterogeneous support for 3rd partyplatforms, data-sources, and data warehousing appliances. While Oracle DataIntegrator Enterprise Edition leverages optimizations for Oracle Database to performE-LT data movement, transformation, data quality and standardization operations,Oracle Data Integrator Enterprise Edition is fully optimized for mixed technologiesincluding: sources, targets and applications, etc.Figure 1 - Oracle Data Integrator Enterprise Edition StudioHigh-Productivity Designer Paradigm for Data IntegrationOracle Data Integrator Enterprise Edition 12c introduces a new declarative flow-baseduser interface for enhanced user experience and productivity. The new user interface3 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
ORACLE DATA SHEETcombines the simplicity and ease-of-use of the declarative approach with the flexibility andextensibility of configurable flows. This blend simplifies common data integration designand deployment use cases, shortening implementation times. Data integration designersdescribe source and target data formats and data integration processes. The businessuser or the developer can focus on describing what to do, not how to do it. Oracle DataIntegrator Enterprise Edition generates, deploys and manages the code required toimplement those processes across the various source and target systems.The paradigm is also enriched with the ability to seamlessly reuse mapping logicduring development, giving developers a simpler and more efficient technique forproviding solutions to their completion.Knowledge Modules Provide Flexibility and ExtensibilityKnowledge Modules are at the core of the Oracle Data Integrator EnterpriseEdition’s architecture. They make all Oracle Data Integrator Enterprise Editionprocesses modular, flexible, and extensible.Knowledge Modules implement the actual data flows and define the templates for generating code across the multiple systems involved in each data integrationprocess. Knowledge Modules are generic, because they allow data flows to begenerated regardless of the transformation rules. At the same time, they are highlyspecific, because the code they generate and the integration strategy they implementare explicitly tuned for a given technology. Oracle Data Integrator Enterprise Editionprovides a comprehensive library of Knowledge Modules, which can be tailored toimplement existing best practices ranging from leveraging heterogeneous sourceand/or target systems, to methodologies for highest performance, for adhering tocorporate standards, or for specific vertical know-how. By helping companies captureand reuse technical expertise and best practices, Oracle Data Integrator EnterpriseEdition’s Knowledge Module framework reduces the cost of ownership. It also enablesmetadata-driven extensibility of product functionality to meet the most demandingdata integration challenges.Enterprise Deployment for High Availability and ScalabilityOracle Data Integrator Enterprise Edition integrates to Oracle Fusion Middleware asa platform. Oracle Data Integrator Enterprise Edition provides its run-timecomponents as Java EE applications, enhanced to fully leverage the capabilities ofthe Oracle WebLogic and Oracle Coherence. Oracle Data Integrator EnterpriseEdition components include exclusive features for Enterprise-Scale Deployments,high availability, scalability, and hardened security.High-Availability (HA) and Scalability is fully supported via clustered deployments forJava EE components. Oracle Data Integrator Enterprise Edition componentsdeployed in WebLogic Server benefits from the capabilities of clustering for scalability,including JDBC connection pooling and load balancing. In addition to the clusterinherited HA capabilities, the run-time agent also supports a connection retrymechanism to transparently recover sessions running in repositories that are stored inHA-capable database engines such as Oracle RAC.4 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
ORACLE DATA SHEETFigure 2: Enterprise Manager Cloud Control IntegrationUnified Administration and ManagementOracle Data Integrator Enterprise Edition simplifies complex data-centric deployments byimproving visibility and control for with a unified set of management interfaces.The Oracle Data Integrator Enterprise Edition Console leverages the OracleApplication Development Framework (ADF) and Ajax Framework for a rich userexperience. Using this console, production users can set up an environment, exportand import the repositories, manage run-time operations, monitor the sessions,diagnose the errors, browse design-time artifacts and generate lineage reports.In addition, this interface integrates seamlessly with the Oracle EnterpriseManager Fusion Middleware Control Console and allows administrators to monitorfrom a single screen not only their data integration components but their otherFusion Middleware components as well.To help maximize the value of Oracle Data Integrator, Oracle offers the ManagementPack for Oracle Data Integrator. This plugin leverages Oracle Enterprise ManagerCloud Control’s advanced management capabilities, to provide an integrated and topdown solution for your Oracle Data Integrator environments by providing aconsolidated view of your entire Oracle Data Integrator infrastructure enabling users tomonitor and manage all of their components centrally from Oracle Enterprise ManagerCloud Control.5 ORACLE DATA INTEGRATOR ENTERPRISE EDITION DATA SHEET
ORACLE DATA SHEETCONTACT USFor more information about Oracle Data Integrator Enterprise Edition, visitoracle.com/goto/dataintegration or call 1.800.ORACLE1 to speak to an Oracle representative.CONNECTWITH r.com/oracleCopyright 2019, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, andthe contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to anyother warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions ofmerchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and nocontractual obligations are formed either directly or indirectly by this document. This document may not be reproduced ortransmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.oracle.comIntel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and aretrademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarksor registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 1016
3rd party applications as well as Oracle’s applications. About Oracle’s Data Integration Solutions Oracle is a leader in the Data Integration market, with the industry’s most comprehensive fully-integrated offering for data integration, including Oracle Data Integrator Enterprise Edition, Oracle Gol
Oracle Data Integrator Log Locations and Configuration 4-5 Oracle Data Integrator High Availability and Failover Considerations 4-6 Oracle Data Integrator Clustered Deployment 4-7 Oracle Data Integrator Protection from Failure and Expected Behavior 4-8 WebLogic Server or Standalone Agent Crash 4-8
Oracle Data Integrator 12c New Features Overview Advancing Autonomous Database and Big Data O R A C L E W H I T E P A P E R SEPTEMBER 2 0 1 9 . ORACLE DATA INTEGRATOR 12C NEW FEATURES WHITEPAPER Table of Contents Executive Overview 6 Oracle Data Integrator 12.2.1.4.0 7 Oracle Sales Cloud 7 .
Oracle Data Integrator Best Practices for a Data Warehouse Page 7 Oracle Data Integrator for Best Practices for a Data Warehouse PREFACE Purpose This book describes the best practices for implementing Oracle Data Integrator (ODI) for a data warehouse solution. It is designed to help setup a successful
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle Data Integrator 12c New Features Overview Advancing Big Data and Cloud O R A C L E W H I T E P A P E R DECEMBER 2 0 1 8 . ORACLE DATA INTEGRATOR 12C NEW FEATURES WHITEPAPER Table of Contents Executive Overview 6 Oracle Data Integrator 12.2.1.3.1 7 Oracle Object Storage and Oracle Object Storage Classic 7 .
Oracle Compute hosting Oracle Data Integrator, the Oracle BI Applications Configuration Manager and Oracle Database Cloud Service. See detailed deployment documentation published on Oracle Support. (Figure 2) Hybrid solutions deploy the BI semantic model, analyses and dashboards on Oracle Analytics Cloud with Oracle Data Integrator and Oracle .
Refer to the Oracle Data Integrator Installation Guide for installing Oracle Data Quality products as well as Oracle Data Integrator. Setup the Data Files 1. On your server, create a directory where the sample files will be stored. We will refer to this directory as ODQ_SAMPLE_FILES throughout this document. (for example C:\demo\oracledq ). 2.
Financial Accounting Working Papers, Robert F. Meigs, Jan R. Williams, Sue Haka, Susan F. Haka, Mark S Bettner, Jun 1, 2000, Business & Economics, 400 pages. . Accounting Chapters 1-14 The Basis for Business Decisions, Robert F. Meigs, Jan R. Williams, Sue Haka, Susan F. Haka, Mark S. Bettner, Sep 1, 1998, Business & Economics, . The Study Guide enables the students to measure their progress .
