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 Tool (ODI) - KARYA Technologies Case Studies - PowerPoint PPT Presentation


  • 99 Views
  • Uploaded on

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

PowerPoint Slideshow about 'Integrating Data From Disparate Sources Using The Oracle Data Integrator Tool (ODI) - KARYA Technologies Case Studies' - karyatech


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