SAP BODS
1. Installation
on BODS
- SQL Server Management Studio 2005
- Oracle
2. Creation
of Repositories types
- Local repo
- Central repo
- Profiler
3. Creation
of job servers
4. Understanding
Data Integrator
- Describe components, management tools, and the development
process
- Explain object relationship
5. Defining
source and target metadata
- Create a database data store and import metadata
- Create a new file format and handle errors in file formats
- Create a new Excel format use as a source in Designer
Screen.
6. Validating, tracing, and
debugging jobs
- Use description and annotations
- Validate and trace jobs
- Use view data and the Interactive Debugger
7. Creating a batch job
- Create a project, job, work flow, and data flow
- Use the query transform in a data flow
- Use template tables
8. Using
built-in transforms and nested data
- Use the case, merge, Map-Operations, SQL, key Generator and
validation transforms
9. Using
built-in functions
- Use date and time functions and the date generation
transform to build a dimension table
- Use the lookup functions to look up status in a table
10. Handling
errors and auditing
11. Supporting a multi-user
environment
- Describe terminology and repository types in a multi-user
environment
- Create and activate the central repository
- Work with objects in the central repository
12. Migrating Projects
- Work
with projects in the central repository (using check-in/check-out)
13. Using the Administrator
- Add a repository and user roles
- Set the job status interval and log retention period
- Execute, schedule, and monitor batch jobs
- Understand architecture and job execution in server groups
14. Managing
Metadata
- Import and export metadata
- Use Metadata Reports
15. SAP
Data Management (If Connect Available)
- Connecting to SAP Applications
- ABAP data Flow Processing Using Data services
- Extract data into SAP using Extractors
- IDoc interface connectivity Using Data services