SAP Data Services
SAP Business Objects Data Services Overview
Data Services is a GUI based ETL tool from SAP Business Objects. It is a client server technology and an integrated tool-set for designing, running, monitoring, scheduling and administrating the ETL jobs.
Data Integrator/Data Services allows to develop data warehouse applications in both Batch and Real-Time job mode. It manages the data from heterogeneous and homogeneous sources and transforms the data according to business logic, integrates into single data source for analysis. It extracts the data from operational source systems and external source systems typically like RDBMS, Flat files, XML files, XML Messages, SAP IDoc’s, PeopleSoft, Siebel etc. We can develop complex dataflow mappings using simple GUI, point & click techniques
Here I’m going to share some basic stuff in DI/DS, which is useful for beginners (novice).
Data Services Topics
- Case
- Date_Generation
- Data_Transfer
- Effective_Date
- Hierarchy_Flattening
- History_Preserving
- Key_Generation
- Map_CDC_Operation
- Map_Operation
- Merge
- Pivot
- Query
- Reverse Pivot
- Row_Generation
- SQL
- Table_Comparison
- Validation
- XML_Pipeline
- Lookups
- Migration of Repositories (Export/Import)
- System Configuration – Multiple Datastore settings
- DI Central Repo vs IBM’s Rational ClearCase (Version Controlling)
Best Practices
- Significance of Overflow option
- Flatfile Lookup
- Cummulative Measure
- Loading DI Log files(Error, Trace, Monitor) into a table
- Repo Password Encryption
- How to get job execution statistics using repository tables.
- How to import atl into repository using al_engine
Tips & Tweaks
- How to view more than 1000 records in View data section window
- How can I see complete Workflow/Dataflow names in the workspace
- Troubleshooting DI standard toolbar docking
- Importance of Annotations
- Compact Repository
- Pushdown_Sql()
What’s New in SAP BODI/DS
- Business Objects Data Integrator 6.1
- Business Objects Data Integrator 6.5
- Business Objects Data Integrator 11.5 XI
- Business Objects Data Integrator 11.7 Accelerated
- SAP Business Objects Data Services 12.0
- SAP Business Objects Data Services 12.1
- SAP Business Objects Data Services 4.0 Vision & Roadmap
- SAP Business Objects Data Services 4.0
Hi Sudheer,please give me full information about variables and parameters in the form of snap shots,how and where we will use this variables(global & local) and parameters.
Hi Sudheer,
My requirement is to fetch any SAP function from SAP R/3 system and use it in SAP BODS.
I know how to import function,I have created new data store and imported the function,but when I intend to use the same in “new function call -> Custom function “,there is some issue in mapping.
Kindly advice..
Thanks in advance.
Hi Sudheer,
Do you have any documents or screenshots or links on clustering servers in BODS 4.0.?
If so please share..
Thanks,
Nisha
I’m sorry for that, I have no information.
Cheers,
Sudheer Sharma
Hi Sudheer,
Can you give me the necessity of the following options of table comparison with images as you have provided for other transforms?Kindly provide the necessity for the options?
Input contains duplicate keys
Generated Key column
Detect Deleted row(s) from comparison table->I understand that If this is checked, then it will show ‘D” opcode when the record is not available in source but available the comparison table
Detect all rows
Detect row with largest generated key value.
Thanks,
nisha
Hi All,
I would like to know what is the importance of SAP BODS??
when there are similar technologies like MDM/PI/BI in SAP.
please help me regarding this.
Thanks,
Sairam.
Hi Sudheer,
Thanks for your valuable information.
Please Provide some information about MAP_CDC_operaration. For that we need to create CDC tables in oracle, then what is the structure for that cdc table.
In your blog also i didn’t find any information about that transformation.
And also provide some information about Admin part of BODS.
Thanks,
Suresh.
You would have to assign some special roles in oracle.