页眉内容1页脚内容SAPBODSSAPBODS-BeginnersguideByAlokRanjanAIM:-ThepurposeofthetutorialistogiveanoviceagoodhandsexperienceonBODSproducttobeabletocreatehis/herownlocalrepository,configurejobserver,starthisbasicjobdevelopmentandexecutethejobtoextractdatafromsourcesystemsandloaddatatotargetsystemsafterperformingtransformations,look-upsandvalidations.WhatisBODS:-ItisanETLtoolcurrentlyacquiredbySAPusedforintegrationwithalltypesofdisparatesystems,extractingdatafromthem,transformingthemintomeaningfulinformationandloadingthemintoalltypesofsystems.ItistightlyintegratedwithSAPsystemsandhencereallyagoodtooltomigratedatafromlegacysystemstoSAPsystemswitheaseandlessdevelopmenteffortswitheffectivedebuggingandmonitoringcapabilities.Howtogetstarted?:-AftergettingBODSinstalledonthemachine,youcanseethefollowingonStart>AllProgramsThereareseveralcomponentsinstalledaspartofSAPBODS3.2installation.IntherecentreleaselikeSAPBODS4,therehasbeenimprovementsonthearchitecture,componentsandtheenhancementfeaturesinseveraltransforms.However,theBODSDesignerlooksprettysameonboth3.2and4.0versions.ThemajorenhancementisintheValidationTransformin4.0whichfacilitatesdeveloperstoswitchonandoffthevalidationsflagseasilyforoneorseveralcolumns.Whattolaunchnext-Normally,thedeveloperswouldliketostartBODSDesignertostartdevelopingjobsstraightaway,butitisalwaysgoodtostartcreatingownlocalrepositoryfirstsothatyouhavefullcontrolonyourowndevelopmentenvironmentwithoutanydependencyonothers.Inordertocreateyourownlocalrepository,itisimportanttoknowthedatabasewhereyouareallocatedspacequotatocreatethesame.页眉内容2页脚内容ItdependsonthedatabasevendorlikeOracle,SQLServer,Informix,DB2,etcwhichyouhavecurrentlyaccessto.However,BODSinstallationcomeswithdefaultmySQLdatabase,whichyoushouldhaveinstalledonyoursystem.Thereisneedofuser/schemaanddatabasecreationonmySQLwhichcanbeeasilydonebyDBA.Onceuser/schemaanddatabasenameinformationisassignedtoyou,youcancreatethelocalrepository.NextScreenshowstheBODSRepositoryManagerwhichadministersyoutocreatelocalrepository.Asyouneedtocreateyourownlocalrepositorytodoyourowndevelopmentactivities,youneedtoselecttheRepositorytypeas‘Local’.NowyouneedtochoosetheDatabaseType/vendor,whereyouwanttocreaterepositoryon.Sinceasmentionedearlier,mySQLdatabasecomesshippedwithBODSproduct,itisconvenienttocreaterepositoryonthesame.Hence,choose‘MySQL’inDatabasetype.MySQLDatabasetyperequiresyoutochooseODBCdatasource.Therefore,youjustneedtoconfigureODBCwithnecessaryparameters.Allyoushouldknowisyourusernameandpasswordanddatabaseschemaname.NextscreenhelpsyouhowtoconfigureODBCdatastore:-LaunchODBCfromControlPanel>Administrationtools>ODBCGoto‘SystemDSN’tab.YoucanfindseveraldefaultaddedDSNnames.IfyouwantadedicatedDSNforyourself,youshouldbeabletoaddyours.ClickonAddbutton.页眉内容3页脚内容Selectthedriver‘MySQLODBC’.(Pleasenotethattheversioncanbedifferent,henceyouneedtoaskadminteamifthereisanydiscrepancy,butallwhatyouwantismySQLdriver).Now,youneedtosupplyinformationasbelow:DataSourceName(itcanbeasperyourdesiredname).Servername-localUser-(asgivenbyDBA)Password–(asgivenbyDBA)Database–(asgivenbyDBA)Afterhavingprovidedalltheinformation,youwouldliketogofortestingtheconnection.So,clickonTestbuttonYoucanseeyournewlycreatedDSNnameinthescreenbelow.Now,launchagaintheRepositoryManagerandcheckinODBCdrop-downfornewlycreatedDSNname.Ifthena...
