Oracle Data Integration: Tools for Harnessing Data

  • 3h 25m
  • Bobby Curtis, Chris Lawless, Michelle Malcher
  • Oracle Press
  • 2015

Deliver continuous access to timely and accurate BI across your enterprise using the detailed information in this Oracle Press guide. Through clear explanations and practical examples, a team of Oracle experts shows how to assimilate data from disparate sources into a single, unified view. Find out how to transform data in real time, handle replication and migration, and deploy Oracle Data Integrator and Oracle GoldenGate. Oracle Data Integration: Tools for Harnessing Data offers complete coverage of the latest ¡§big data¡¨ hardware and software solutions.

  • Efficiently move data both inside and outside an Oracle environment
  • Map sources to database fields using Data Merge and ETL
  • Export schema through transportable tablespaces and Oracle Data Pump
  • Capture and apply changes across heterogeneous systems with Oracle GoldenGate
  • Seamlessly exchange information between databases using Oracle Data Integrator
  • Correct errors and maximize quality through data cleansing and validation
  • Plan and execute successful Oracle Database migrations and replications
  • Handle high-volume transactions with Oracle Big Data Appliance, Oracle NoSQL, and third-party utilities

About the Authors

Michelle Malcher is an Oracle ACE Director experienced in database development, design and administration. She has expertise in data services and integration, security, performance tuning, data modelling and database architecture of very large database environments. She has presented on new database features, security and other database administration topics around the world. She has written Oracle Database Administration for the Microsoft SQL Server DBA, and co-authored Oracle Database 12c Install, Configure & Maintain like a Professional, Securing Oracle Database 12c: A Technical Primer, Oracle Database 11g A Beginner's Guide. She is also a contributing author for the IOUG Best Practices Tip Booklet and Select Journal.

Bobby Curtis is an Oracle ACE, Senior Technical Consultant and member of various Oracle User Groups. He specializes in database monitoring and data integration technologies, both aimed at making usability simpler and easier. He is experienced in creating, managing and tuning enterprise databases including Exadata, GoldenGate replication and is known for his work with Oracle Enterprise Manager 12c. He is currently working as a Senior Technical Consultant focused on implementations and migrations of scalable databases while providing monitoring solutions for these environments. He is either a lead author or co-author on various technical books, published various technical articles in user group publications, and presented at conferences including Oracle Open World, Collaborate and KSCOPE. Bobby is a current member of the Independent Oracle User Group (IOUG), Oracle Development Tools User Group (ODTUG), Georgia Oracle User Group (GOUSER) and the Rocky Mountains Oracle User Group (RMOUG).

Chris Lawless began his career in data integration by working in support for GoldenGate. He then worked in consulting and pre-sales prior to becoming a Product Manager at GoldenGate. When GoldenGate was acquired by Oracle he became a Product Manager in the Data Integration Group at Oracle for the next four years. Prior to working at GoldenGate Chris was a DBA instructor at Oracle University. Chris is currently a Product Manager at Dbvist Software, a replication company.

In this Book

  • Introduction
  • Data Integrations Overview
  • Moving Data Around the Oracle Environment
  • Moving/Using Data
  • Oracle Replication (GoldenGate)
  • Oracle Data Integrator
  • Common Challenges
  • Data Cleansing
  • Big Data