Transcript PowerPoint-Präsentation

Integrating Data From Disparate Sources Using
The Oracle Data Integrator Tool (ODI)
KARYA
Technologies
is
a
comprehensive Global Enterprise
Solutions Provider and System
Integrator.
We deliver world-class Enterprise
Solutions to our global clients within
optimal time and cost.
Challenge
Why KARYA
Intelligence ?
Technologies
•
Our clients also wanted to migrate all
their Background Information Data,
made available to them in different
forms, such as Oracle, SQL Server, Flat
File and Scanned Documents which
were about 16 in number. The broad
category of Information types were:
•
General Background Screening
Employment Screening
Education Screening
Criminal Records Screening
Fingerprint
Medical Records
•
•
•
•
for
Oracle
Business
• Advanced Competency in Oracle Platform SolutionsOracle Database, ODI, OBIEE & Hyperion
• Business Focused Data Warehouse and BI Solutions
• Solution for all BI Maturity Levels
• Proven Global Engagement Model
Solution
A High Tech Screening company in East
Coast is a Global Solution Provider of
Background Verification for their
clients. Their primary requirement was
to create a Scoring System by
extracting Data from various sources
into a single repository.
•
•
•
•
•
•
KARYA Technologies, a gold partner of Oracle , helps its global
clients to harness the power of Oracle Database through high
performance, fault tolerance, and secure database systems.
KARYA first came up with a right
Data Structure to capture the
extracted Data As-is.
KARYA created the necessary
Mapping and Jobs in ODI to simplify
and extract the data from various
sources based on appropriate
triggers and load them.
KARYA proceeded to build a
comprehensive Scoring Engine using
ODI Mapping and Transformations
to process data from various sources
and apply Business Rules.
KARYA then assigned a Score for
each category for each applicant.
Also developed was a Referencing
System for all Background Record
details.
KARYA created Full loads and
Incremental Loads which will update
data on a daily basis or by business
trigger into the Scoring system.
Highlights of the Solution with
Business Value
•
•
KARYA was able to use the power of
ODI to build a Robust Integration
Solution with complex Business
Rules incorporated in it.
Given the high volume and variety
of Data Sources, this solution vastly
enhanced their turnaround times for
the Background Verification Process.
Further, the linking of detail to the
scores
promoted
Drilldowns
Analysis.
Technology Used
•
•
•
•
ODI(Oracle Data Integrator)
Oracle 10g/11g
Toad
SQL, PL/SQL, Shell Scripts
Infrastructure
Office address: KARYA Technologies Inc. 1240 Normandy Dr, Blue Bell, PA 19422, USA Phone: (215) 583 4456
www.karyatech.com
Industries