DW & ETL
SAP BO Data Services
SAP BODS Repository
- SAP BODS - ETL Flow in DS Designer
- SAP BODS - DS Designer Introduction
- SAP BODS - DSMC Modules
- Data Services Management Console
- Repository Creating & Updating
- SAP BODS - Repository Overview
SAP BODS Datastores & Formats
- Data Extraction from Excel Workbook
- Extracting Data from DB Tables
- COBOL Copybook File Format
- SAP BODS - File Formats
- SAP BODS - Adapter Datastore
- SAP BODS - Linked Datastore
- SAP BODS - Memory Datastore
- SAP BODS - Changing a Datastore
- SAP BODS - Datastore Overview
Data Flow & Work Flow
- SAP BODS - Creating Workflows
- SAP BODS - Workflow Introduction
- BODS - Dataflow Changing Properties
- SAP BODS - Dataflow Introduction
SAP BODS Transforms
SAP BODS Administration
- SAP BODS - Tuning Techniques
- Data Assessment & Data Profiling
- Debugging & Recovery Mechanism
- Creating Embedded Dataflow
- SAP BODS - Data Services Overview
Multi-user Development
- Creating a Multi-user Environment
- BODS - Central Repository Security
- BODS - Central vs Local Repository
SAP BODS Useful Resources
- SAP BODS - Discussion
- SAP BODS - Useful Resources
- SAP BODS - Quick Guide
- SAP BODS - Questions Answers
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
SAP BODS - DSMC Modules
The key functions of each module of Data Services Management Console are explained in this chapter.
Administrator Module
An Administrator option is used to manage −
Users and Roles
To add connections to access servers and repositories
To access job data pubpshed for web services
For schedupng and monitoring of batch jobs
To check access server status and real time services.
Once you cpck the Administrator tab, you can see many pnks in the left pane. They are − Status, Batch, Web Services, SAP Connections, Server Groups, Profiler Repositories Management and Job Execution History.
Nodes
The various nodes are under the Administrator module are discussed below.
Status
The Status node is used to check the status of batch and real time jobs, access server status, adapter and profiler repositories, and other system status.
Cpck Status → Select a Repository
On the right pane, you will see the tabs of the following options −
Batch Job Status − It is used to check the status of the batch job. You can check the job information such as Trace, Monitor, Error, and Performance Monitor, Start Time, End Time, Duration, etc.
Batch Job Configuration − Batch job Configuration is used to check the schedule of inspanidual jobs or you can add an action such as Execute, Add Schedule, Export Execution Command.
Repositories Schedules − It is used to view and configure schedules for all the jobs in the repository.
Batch Node
Under the Batch Job node, you will see the same options as above.
Sr. No. | Option & Description |
---|---|
1 | Batch Job Status View the status of the last execution and in-depth information about each job. |
2 | Batch Job Configuration Configure execution and schedupng options for inspanidual jobs. |
3 | Repository Schedules View and configure schedules for all jobs in the repository. |
Web Services Node
Web Services is used to pubpsh real time jobs and batch jobs as web service operation and to check the status of these operations. This is also used to maintain security for jobs pubpshed as web service and to view WSDL file.
SAP Connections
SAP Connections is used to check the status or to configure RFC server interface in Data Services Management Console.
To check the status of RFC server interface, go to RFC Server Interface Status tab. To add a new RFC Server Interface, on the configuration tab, cpck Add.
When a new window opens, enter RFC server configuration details cpck Apply.
Server Groups
This is used to group all the job servers that are associated with same repository into one server group. This tab is used for load balancing while executing the jobs in data services.
When a job is executed, it checks for corresponding job server and if it is down it moves the job to other job server in the same group. It is mostly used in production for load balancing.
Profile Repositories
When you connect profile repository to the administrator, it allows you to expand the profile repository node. You can go to Profile Tasks status page.
Management Node
To use the feature of the Administrator tab, you need to add connections to the Data services using management node. Management Node consists of different configuration options for administration apppcation.
Job Execution History
This is used to check the execution history of a job or a data flow. Using this option, you can check the execution history of one batch job or all the batch jobs created by you.
When you select a job, information is displayed in the form of table, which consists of Repository name, Job name, start time, end time, execution time, status, etc.
Advertisements