Integrating data from disparate sources using the oracle data integrator tool odi karya technologies case studies
Download
1 / 1

Integrating Data From Disparate Sources Using The Oracle Data Integrator To... - PowerPoint PPT Presentation


KARYA was able to use the power of ODI to build a Robust Integration Solution with complex Business Rules incorporated in it..http://www.karyatech.com/pdf/Building-a-Robust-Integration-with-complex-Business-Rules-using-ODI.pdf

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

Download Presentation

Integrating Data From Disparate Sources Using The Oracle Dat...

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


IntegratingDataFromDisparateSourcesUsingTheOracleDataIntegratorTool(ODI)

KARYATechnologies,agoldpartnerofOracle,helpsitsglobalclientstoharnessthepowerofOracleDatabasethroughhighperformance,faulttolerance,andsecuredatabasesystems.

WhyKARYATechnologiesforOracleBusinessIntelligence?

KARYATechnologiescomprehensiveGlobal

isa

Enterprise

andSystem

SolutionsProviderIntegrator.

  • AdvancedCompetencyinOraclePlatformSolutions-OracleDatabase,ODI,OBIEE&Hyperion

  • BusinessFocusedDataWarehouseandBISolutions

  • SolutionforallBIMaturityLevels

  • ProvenGlobalEngagementModel

Wedeliverworld-classEnterpriseSolutionstoourglobalclientswithinoptimaltimeandcost.

Challenge

AHighTechScreeningcompanyinEastCoastisaGlobalSolutionProviderofBackgroundVerificationfortheirclients.TheirprimaryrequirementwastocreateaScoringSystembyextractingDatafromvarioussourcesintoasinglerepository.

Solution

HighlightsoftheSolutionwithBusinessValue

  • KARYAfirstcameupwitharightDataStructuretocapturetheextractedDataAs-is.

  • KARYAcreatedthenecessaryMappingandJobsinODItosimplifyandextractthedatafromvarioussourcesbasedonappropriatetriggersandloadthem.

  • KARYAproceededtobuildacomprehensiveScoringEngineusingODIMappingandTransformationstoprocessdatafromvarioussourcesandapplyBusinessRules.

  • KARYAthenassignedaScoreforeachcategoryforeachapplicant.

  • AlsodevelopedwasaReferencingSystemforallBackgroundRecorddetails.

  • KARYAcreatedFullloadsandIncrementalLoadswhichwillupdatedataonadailybasisorbybusinesstriggerintotheScoringsystem.

  • KARYAwasabletousethepowerofODItobuildaRobustIntegrationSolutionwithcomplexBusinessRulesincorporatedinit.

  • GiventhehighvolumeandvarietyofDataSources,thissolutionvastlyenhancedtheirturnaroundtimesfortheBackgroundVerificationProcess.Further,thelinkingofdetailtothescorespromotedDrilldownsAnalysis.

OurclientsalsowantedtomigratealltheirBackgroundInformationData,madeavailabletothemindifferentforms,suchasOracle,SQLServer,FlatFileandScannedDocumentswhichwereabout16innumber.ThebroadcategoryofInformationtypeswere:

TechnologyUsed

  • ODI(OracleDataIntegrator)

  • Oracle10g/11g

  • Toad

  • SQL,PL/SQL,ShellScripts

  • GeneralBackgroundScreening

  • EmploymentScreening

  • EducationScreening

  • CriminalRecordsScreening

  • Fingerprint

  • MedicalRecords

Industries

Infrastructure

Officeaddress:KARYATechnologiesInc.1240NormandyDr,BlueBell,PA19422,USAPhone:(215)5834456www.karyatech.com


ad
  • Login