SAP BODSBeginners guide.docx
- 文档编号:9014951
- 上传时间:2023-02-02
- 格式:DOCX
- 页数:41
- 大小:2.07MB
SAP BODSBeginners guide.docx
《SAP BODSBeginners guide.docx》由会员分享,可在线阅读,更多相关《SAP BODSBeginners guide.docx(41页珍藏版)》请在冰豆网上搜索。
SAPBODSBeginnersguide
SAPBODS
SAPBODS-Beginnersguide
ByAlokRanjan
AIM:
-ThepurposeofthetutorialistogiveanoviceagoodhandsexperienceonBODSproducttobeabletocreatehis/herownlocalrepository,configurejobserver,starthisbasic jobdevelopmentandexecutethejobtoextractdatafromsourcesystemsandloaddatatotargetsystemsafterperformingtransformations,look-upsandvalidations.
WhatisBODS:
-ItisanETLtoolcurrentlyacquiredbySAPusedforintegrationwithalltypesofdisparatesystems,extractingdatafromthem,transformingthemintomeaningfulinformationandloadingthemintoalltypesofsystems.
ItistightlyintegratedwithSAPsystemsandhencereallyagoodtooltomigratedatafromlegacysystemstoSAPsystemswitheaseandlessdevelopmenteffortswitheffectivedebuggingandmonitoringcapabilities.
Howtogetstarted?
:
-
AftergettingBODSinstalledonthemachine,youcanseethefollowingonStart>AllPrograms
ThereareseveralcomponentsinstalledaspartofSAPBODS3.2installation.
IntherecentreleaselikeSAPBODS4,therehasbeenimprovementsonthearchitecture,componentsandtheenhancementfeaturesinseveraltransforms.
However,theBODSDesignerlooksprettysameonboth3.2and4.0versions.
ThemajorenhancementisintheValidationTransformin4.0whichfacilitatesdeveloperstoswitchonandoffthevalidationsflagseasilyforoneorseveralcolumns.
Whattolaunchnext- Normally,thedeveloperswouldliketostartBODSDesignertostartdevelopingjobs straightaway,butitisalwaysgoodtostartcreatingownlocalrepositoryfirstsothatyouhavefullcontrolonyourowndevelopmentenvironmentwithoutanydependencyonothers.
Inordertocreateyourownlocalrepository,itisimportanttoknowthedatabasewhereyouareallocatedspacequotatocreatethesame.
ItdependsonthedatabasevendorlikeOracle,SQLServer,Informix,DB2,etcwhichyouhavecurrentlyaccessto.
However,BODSinstallationcomeswithdefaultmySQLdatabase,whichyoushouldhaveinstalledonyoursystem.
Thereisneedofuser/schemaanddatabasecreationonmySQLwhichcanbeeasilydonebyDBA.
Onceuser/schemaanddatabasenameinformationisassignedtoyou,youcancreatethelocalrepository.
NextScreenshowsthe BODSRepositoryManager whichadministersyoutocreatelocalrepository.
Asyouneedtocreateyourownlocalrepositorytodoyourowndevelopmentactivities,youneedtoselecttheRepositorytypeas‘Local’.
NowyouneedtochoosetheDatabaseType/vendor,whereyouwanttocreaterepositoryon.
Sinceasmentionedearlier,mySQLdatabasecomesshippedwithBODSproduct,itisconvenienttocreaterepositoryonthesame.
Hence,choose‘MySQL’inDatabasetype.
MySQLDatabasetyperequiresyoutochooseODBCdatasource.
Therefore,youjustneedtoconfigureODBCwithnecessaryparameters.
Allyoushouldknowisyourusernameandpasswordanddatabaseschemaname.
NextscreenhelpsyouhowtoconfigureODBCdatastore:
-
LaunchODBCfromControlPanel>Administrationtools>ODBC
Goto‘SystemDSN’tab.
YoucanfindseveraldefaultaddedDSNnames.
IfyouwantadedicatedDSNforyourself,youshouldbeabletoaddyours.
ClickonAddbutton.
Selectthedriver‘MySQLODBC’.(Pleasenotethattheversioncanbedifferent,henceyouneedtoaskadminteamifthereisanydiscrepancy,butallwhatyouwantismySQLdriver).
Now,youneedtosupplyinformationasbelow:
DataSourceName(itcanbeasperyourdesiredname).
Servername-local
User-(asgivenbyDBA)
Password–(asgivenbyDBA)
Database–(asgivenbyDBA)
Afterhavingprovidedalltheinformation,youwouldliketogofortestingtheconnection.
So,clickonTestbutton
YoucanseeyournewlycreatedDSNnameinthescreenbelow.
Now,launchagaintheRepositoryManagerandcheckinODBCdrop-downfornewlycreatedDSNname.
Ifthenameisnotvisible,thenyouneedtogotoODBCagainandre-configure.
Ifitislistednow,youcanproceedwiththenextsteps.
YouagainneedtoprovideallthemySQLlogincredentialsanddatabasenameaboveasyoudidearlierforDSNconfiguration.
Selecttheflag‘Showdetails’.Itgivesyoualltheinformationwhatversionitisandalltheotherdetailswhenyoustartcreatinglocalrepository.
Now,hitthe‘Create’button.
Youneedtowaitforsometimefortherepositorytobecreated.
Followthenextscreen.
Youshouldseethat‘localrepositorywassuccessfullycreated’
Youcancheckfortheversionoftherepositoryaswellbyhitting‘GetVersion’.
Now,itistimeforthemostimportantwork.
YouneedtolaunchBODSDesignertostartyourdevelopmentactivities.
GotoAllPrograms>SAPBusinessObjectsXI3.2>sapBusinessObjectsDataServices>DataServicesDesigner
Providealltheinformationyouusedincreatinglocalrepositoryawhileago.
Now,yougetthescreenlayout.
Therearebasicallythreeimportantareasyouneedtoundertand.
1)LocalObjectLibrary:
-Itcontainsallthenecessaryobjectsusedforthedevelopmentofjobs.
2)ProjectArea:
-Itcontainsallthejobswhicharereadyforexecutionoryouarecurrentlyworkingon.
3)Workspacearea:
Thebiggerspace,whereyouactuallydesignyourjob.
Startdevelopment
Rightonemptyspaceinlocalobjectarea/clickon‘CreateProject’underGettingStartedinthemainpage.
Createwithanynamelikeabove
Youcanfinditinthetopleftpane(projectarea).
Rightclickontheprojectnameandselect‘newBatchJob’.
Giveanynametothenewjobasshown.
Thejobiscreated.
No,itisnot!
!
!
Youneedtocreatedataflowunderit.
Ontherighthandside,youcanseethelistificons.
Youclick-oncethedataflowandclick-onceontheworkspacearea(biggerarea)
Namethedataflowasperyourwish.ItshouldstartwithDF_.
Now,youneedtodefinethesourcestructure.
Inthisexample,weareusingtheflatfileassource.So,wewillcreateflatfileformat.
Goto‘formats’tabinlocalobjectlibraryasbelow:
-
Rightclickontheflatfileandselectnew.
YouwillgettheFileFormatEditorasshownabove.
Now,youneedtodefinethestructureoftheinputfile.
Inthisexample,theinputfilehas3fieldsEMP_ID,EMP_NAMEandEMP_DEPT.
Clickunderthe‘fieldname’andaddthefieldnames.
Under‘Datatype’chooserelevantdatatypelike‘int’forEMP_ID,‘varchar’forEMP_NAME’etc.
Inthelefthandside,clickon‘Rootdirectory’foldertobrowsetothecorrectpathwheretheinputfileisplaced.
Clickon‘Filename(s)’andyoushouldbeabletobrowsetoseetheinputfile.
Followthenextsubsequentscreens.
Inthisexample,theinputfileisatextfilewhichhas2recordsasshownbelow:
-
Thetextfilecontainsthefirstrowasheaderdefiningthefieldtypes.
Thenext2rowscontaindata.
Since,wealreadydefinedtheflatfileformatstructurewithfieldnames,wecanignorethefirstrowheader(showninthenextscreen)
Whenyoutrytosaveandclosethefileformateditor,itgivesyoutheabovewarning.
Ifyouhavedefinedthestructurewithfieldnamesinyourfileformateditor,youshouldselect‘no’,elseitwilloverwritewithinputfileprovidedinthefilename.
Here,youselect‘no’.
Ignoringtherowheader
Now,sincewehavealreadydefinedthefileformatwithourfieldnames,wedonotrequiretherowheaderprovidedintheinputfile.
So,‘ignoretherowheader’.Seethenextscreen.
Youfindtheflatfileformatcreatedasshownabove.
Now,youneedtousethisfileformatassourceinyourdataflow.
Draganddropthefileformatintheworkspaceareaandmakeitassource.
Clickonceonthe‘Query’iconontherighthandsideandclickonceontheworkspace.
Namethequeryandjoinittothesourcefileformat.
Now,youneedtodefinethetarget.
Inthisexample,weareloadingtotable.
So,weneedtocreateadatastore(logicalconnectiontodatabase).
Goto‘datastores’tab inlocalobjectlibraryandrightclickontheblankspace.
Youwillgettheabovescreenwhereyouneedtoprovideinputs.
Datastorename:
-asperyourchoice.
Datastoretype;-Database
Databasetype:
-mySQL(inthiscase,asweareusingmySQLdatabaseforstagingtables)
Alloveragain,youneedtoprovidealllogincredentialsanddatabasenameasyouprovidedearlierforcreatinglocalrepository.
Ifyouareusinganotherdatabaseforstagingtables,youcanuseinformationprovidedbytheDBA.
Youseethedatastorecreated.
Now,youclickonceonthetemplatetableiconintherighthandsideandclickonceontheworkspace
Youneedtodefine thenameofthetargettableasperyourwish.
Clickon OK
Now,jointhequerytransformicontothetarget.
But,wehavenotstillmappedthefieldsfromsourcetotarget.
Clickonthenameofthequery.
Youwillfindthat,therearethreefieldsinthesource.
Youwouldliketomapallthethreefieldsfromsourcetotarget
Draganddropeachfieldfromleftpanetorightpaneonebyone.
Now,trytovalidatethatthedesignhasanyerrorsorwarnings
Clickonvalidatecurrenticon
Ifyougetthefollowingwarnings
[SourceFile:
"EMPLOYEE.txt"(EMPLOYEE)]
JobServererror(theJobServermaynotberesponding).Thedirectoryforthefile /EMPLOYEE.txt>cannotbevalidatedtoensurethatitisvalidatdesigntime.Ensurethatthedirectoryisvalidbyrun-time.(BODI-1110017) Itwasexpected.Thejobserverwasnotconfigured. Didyouseetheicon ? PleaserememberthatyouhaveBODSservercomponentsinstalledonyourmachineandsoyouareresponsibletoconfigureJobserveraswell. LaunchServ
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SAP BODS Beginners guide