Integrating data from disparate sources using the oracle data integrator tool odi karya technologies case studies
This presentation is the property of its rightful owner.
Sponsored Links
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

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


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

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


  • Login