Data Integration

Oracle Data Integration – ODI, GoldenGate, EDQ, OEMM, BDP, ODI CS, DIPC, OWB, Informatica

Building your Data for Analytics

Extraction, Loading, and Transformation (ELT) is not only the heart, but also the highest cost element of any analytics implementation. Poorly implemented processes drive down data-load performance, while increasing the cost of implementation. To avoid the associated pitfalls, BIAS has developed a highly proven and best-practices based data integration approach that leverages product strengths to reduce development time, improve performance, and lower the ongoing administrative costs. BIAS delivers extensive expertise in designing, architecting, implementing, and managing Oracle Data Integrator (ODI), GoldenGate (GG), Oracle Enterprise Data Quality (EDQ), Oracle Enterprise Metadata Management (OEMM), Big Data Preparation (BDP), ODI CS, Data Integration Platform Cloud (DIPC), Oracle Warehouse Builder (OWB), and Informatica based ELT/ETL processes that help customers start their critical initiatives with the right foundation and deliver them faster with consistency. We also help customers design and develop solutions to migrate from Oracle Warehouse Builder, which is now out of Premier Support, to ODI. Learn more about Oracle’s Data Integration platforms, BIAS’ customer successes and related products by clicking through the tabs below.


Oracle Data Integrator (ODI) is Oracle’s next generation, comprehensive, and high-performance data integration platform designed to support the large heterogeneous workloads including Big Data and complex highly available deployments. ODI has superior capabilities that foster high productivity, fast development cycle, and simple administration at a low overall total cost of ownership (TCO). ODI’s easy to use interface provides robust capabilities for developers and drives collaboration and consistency across the entire development team. ODI also integrates natively with Oracle GoldenGate (GG), an industry standard for high performance and fidelity replication to enable real-time analytics and reporting as well as flexible architectures that support high performance real-time and near real-time loads. ODI also handles Big Data workloads and provides native support for Hadoop, JSON, and XML. ODI and GG are both fully capable of managing data integration initiatives on-premise or on Cloud and also offers flexible deployment alternatives. ODI also replaces OWB’s capabilities and comes with a utility that helps with migration of existing OWB workloads to ODI.

Oracle Enterprise Data Quality (EDQ) provides a comprehensive set of data quality management capabilities such as data profiling, auditing, parsing and standardization, match and merge, case management, address verification and provides a robust governance framework. EDQ is also integrated with ODI to support complex ELT processing involving EDQ.

Oracle Enterprise Metadata Management (OEMM) is an industry leading metadata management tool that is increasingly critical to organizations having a large set of Oracle and 3rd party data sources that feed into reports being capabilities to their end users. OEMM harvests metadata from a large pool of source systems and the ETL and reporting tools and provides end-to-end lineage between such transactional systems to the processed information provided in the hands of users in a highly efficient manner that saves the organization the large hidden cost it incurs in the form of routinely taken poor decisions due to lack of clear understanding of detail behind the reports, conflicting understanding of users, and the confusion posed by poor trust in data. OEMM is also a key tool for governance and greatly increases quality of development and testing. OEMM provides robust impact analyses thereby improving productivity of report and ETL developers when they try to introduce changes into the system.

Contact us  to find out about our Quick Start Data Integration engagements and learn more.

SITA, Dartmouth, Neenah Paper Inc., RNDC, TVA, Macy’s

BIAS has delivered complex Data Integration Architectures for numerous customers for over a decade.  These architectures have ranged from meeting the needs of a single data mart, an enterprise data warehouse with high availability requirements, an operational data source consolidating data from multiple sources, real-time data warehouses, and very large and high throughput data warehouses.  Example initiatives include ODI and GG Architecture Design, implementation and support for SITA’s Messaging service line and Passenger Service Line data warehouse initiatives, Real-Time Data Warehouse and Business Intelligence for Dartmouth leveraging ODI and GG, Sales Analytics Warehouse and four Modules of BI Applications for Neenah, real-time order management analytics for Macys.com, BI Applications (Informatica based) implementation and upgrade for UL, and 5-year, multi-phase custom-built Enterprise Data Warehouse for TVA using Informatica.

BIAS utilizes a combination of one or more of the following products in our Data Integration engagements:

  • Oracle Data Integrator Enterprise Edition (ODI EE)
  • Oracle GoldenGate (GG)
  • Oracle Enterprise Data Quality (EDQ) and EDQ with Customer Data Services
  • Oracle Data Integrator Cloud Services (ODI CS)
  • Oracle GoldenGate Cloud Services (GG CS)
  • Oracle Data Integration Platform Cloud (DIPC)
  • Informatica
  • Oracle BI Applications (7.9.6.x and 11.1.1.7+)
  • Oracle Big Data
  • Oracle Essbase
  • Oracle Enterprise Metadata Management
  • Oracle Master Data Management (MDM) Applications – Customer, Product, Person

BIAS has been recognized for its expertise in delivering the following Oracle Data Integration Solutions:

  • Oracle Data Integrator 11g – The Oracle Business Intelligence Foundation Suite 11g Specialization recognizes partner organizations that are proficient in selling and/or implementing BI solutions using OBI EE 11g.
  • Oracle GoldenGate 11g – The Oracle Business Intelligence (BI) Applications Specialization recognizes partner organizations that are proficient in selling, implementing and/or developing Oracle BI Applications solutions.