Hello SAPians, I was encountered with a question today, “What will happen if I forgot to give the order by in Query Transform but selected Sorted Input option in Table Comparison?” To this, I responded, “Job will get executed successfully, but it’ll give warning.” Now was I right? Let’s see …
Read More »BODI XI R2 Accelerated (11.7.3) – End of license key file support
Overview: This blog is intended for users of the below mentioned product versions which have been End-of-Life since December 31st, 2011 Product(s): Business Objects Data Integrator XI R2 Accelerated (11.7.3) and lower versions Support status: Unsupported. End-of-Life since December 31, 2011 Click here for reference. Importance: High …
Read More »BODI XI R2 Accelerated (11.7.3) – End of license key file support
Overview: This blog is intended for users of the below mentioned product versions which have been End-of-Life since December 31st, 2011 Product(s): Business Objects Data Integrator XI R2 Accelerated (11.7.3) and lower versions Support status: Unsupported. End-of-Life since December 31, 2011 Click here for reference. Importance: High …
Read More »Sybase Control Center DB Creation
Creation of a Database in the Sybase Control Center for use as a Data Services Repo takes a few more steps than first thought. Hopefully this step-by-step will help people. Create the Database Devices required for the schema Select Database Devices Select New from the available menu Select the …
Read More »Integration of SAP Data Quality Management microservices for location data into an SAP Data Services job
SAP Data Quality Management, microservices for location data (DQMms) offers cloud-based microservices for address cleansing, geocoding, and reverse geocoding on the SAP Cloud Platform (SCP). It enables embedding address cleansing and enrichment services within any business process or application in order to quickly leverage the value of complete and accurate …
Read More »Delete rows from target not present in source; Row by Row select
Hello All, What if on one fine day client asks to remove all the records which are present in target but not present in source or may be clients asks to remove at least one record from target and preserve the remaining? So to achieve this BODS provides a transform …
Read More »SAP Data Services 4.2 SP9 Upgrade steps
Purpose: The purpose of this document is to up-grade SAP Businessobjects Data Services from 4.2 SP8 to SAP Data Services 4.2 SP9 Overview: Environment Details: Operating system: Windows Server 2008 64 Bit Database: Microsoft SQL Server 2012 R2 Web Application: Tomcat 8 SAP Business Objects Tools: SAP BusinessObjects Information Platform Services 4.2 SP3; SAP …
Read More »SAP Data Services Configuration Management
Introduction: The purpose of the document is to provide the solution for Configuration Management in Data Services. Problem statement: While doing the deployment of the existing jobs and migrated data to multiple targets without modifying developed ETL package. Proposed solution: By Using existing feature of multiple profiles for …
Read More »Get datastore details form bods repository
Below select query displays all datastore details in target repository up to 10 configurations, to run for more just change the number 10 do desired number. Run the query in target repository metadata database select datastore_name,configuration,db_name,user_name from ( with level_select as (select level as seq_num from dual connect by level …
Read More »Sap Data services using Python to Google Translate
Hi There I just did a Custom Python Transformation to Google Translate some text using Data Services I downloaded the libraries from https://pypi.python.org/pypi/goslate#downloads and dropped them in C:Program Files (x86)SAP BusinessObjectsData ServicesDataQualitypythonLib then I created the job here is the function here is the code import …
Read More »Functioning of gen_row_num_by_group function in BODS
Hello Experts, I was using gen_row_num_by_group function provided by Data Services in my project and after experimenting on it I recorded my observations and thought of sharing with you all. Suppose you get a requirement to find the rank. Then BODS provides a function called gen_row_num_by_group which allots ranking to …
Read More »MATMAS_MASS_BAPI – IDoc processed with status 53 but material not created
Recently when I was trying to create a sample material using the IDoc MATMAS_MASS_BAPI we encountered a situation where the IDoc Message processed successfully (Status 53) but a material was not created. In such cases it is best to check the ALE interfaces for the BAPI. In …
Read More »How to get previous Sunday date of a particular date in SAP DATA SERVICES
Hello Everyone, In this blog,I am going to explain how to get the previous Sunday date for a particular date in SAP DATA SERVICES. For example if we give a particular date as “24-07-2017”, we need to get the output as “23-07-2017”. Step:1 Create a new text document (.txt file) …
Read More »TABLE COMPARISON: Generated Key Column, column present in Target not present in source, Target having duplicates
Hello Experts, I was trying to understand the Generated Key Column option present in table comparison and after experimenting I found the below observation. TABLE COMPARISON: – Generated Key Column, column present in Target not in source. When your target column has duplicate records present in it then this option …
Read More »TABLE COMPARISON: – Generated Key Column, same column name present in source and target, duplicate records in source
Hello Experts, Adding further concepts to my knowledge I was working on Generated Key column of Table Comparison, placing the common column existing in both source and target and incoming source has duplicates. So below is my observation please have a glimpse of it! TABLE COMPARISON: – Generated Key Column …
Read More »Table Comparison: Input Contains Duplicate Keys
Hello Experts, I was trying to understand Table Comparison’s Input Contain Duplicate Keys option and after my experiments I found below results. TABLE COMPARISON: – Input Contain Duplicate Keys When records coming from source has multiple similar values for primary key then to process them/handle them we use Input Contain …
Read More »Event Based Schedule of BODS Jobs using BOE Scheduler
BODS Scheduler does not have out of box option to do Event based scheduling. If one Job has to be triggered after successful running of another one, it is done by Custom scripts or third party schedulers. In this post, we will see how we can achieve the same with …
Read More »Data Services 4.2 SP8 Patch 2 update install
Sharing my experience of applying the 4.2 SP8 Patch2 update for Data Services and Information Steward. We were on 4.2 SP2 Patch2 for almost 3 years. There were only few niggles that prompted us to consider the upgrade. They were related FROMDBLOVER and slowness of central repository. The DBLOVER issue …
Read More »US Directory changes for June and July
Due to USPS requirements, the SHA-1 format of the DPV, LACSLink, SuiteLink, and RDI directories will no longer be available after July 2017. The SHA-1 format of the DPV directory download for June and July will contain alternative download instructions. The file size of the SHA-1 DPV download from …
Read More »Table Comparison : Row by Row select, processing of records
Hello Experts, I was trying to understand the Table Comparison options and started my research with Row by Row select option and after experimenting I found these observations. TABLE COMPARISON: – Table comparison is used to update the target table when source records have been updated/changed. It is used in …
Read More »How to perform Left outer join in BODS and execute via console
The Main agenda of creating this blog i will be showing you how to do an Left outer join in SAP-BODS. Step 1: Here On bottom left of the screen you can find the tables which you wanted to join. Select your desired tables and drag them. …
Read More »How to create a Project, Job and Job execution in SAP-Business Objects Data Services (BODS)
Purpose of this Documentation: The main agenda behind creating this documentation is to know how to create a project, job , one to one mapping and job execution in Data Service designer. SAP-Business Objects Data Services (BODS) Version — 14.2.5.800 Following are the steps to proceed things in a …
Read More »Functioning of word_ext() function
Hello Experts, I was trying to understand how does ‘separator’ in word_ext() works. How does it picks the string? After exploring and experimenting, I recorded my observation. Here it is: word_ext() is used to extract a string from a list of strings provided as input. The input provided by user …
Read More »[Tips] Working with SAP Data Services Flat File Formats
One of the most common scenarios working with SAP Data Services is flat file generating. A lot of questions were asked around how to dynamically generate the series of flat files based on data records. This is mostly depending on the consumed applications and how they require on file formatting. …
Read More »Transform requires option to be set
Hi All, I m getting this error when i run a job having multiple Oracle tables with one SQL Query having in SQL Transform. Data Services Management Console initDom(“../images/skin_standard/”,”en”); styleSheet() JOB_DM4113_DAILY_NEWS_TCPN_DMN (14.2) 04-20-17 22:10:31 (E) (88784:89388) VAL-030147: |SESSION JOB_DM4113_DAILY_NEWS_TCPN_DMN|WORKFLOW WF_DM4113_TCPN_DMN|DATAFLOW DF_DM4113_TCPN_ICSPM_STG|STATEMENT <GUID::'90e74271-18b2-407a-a7de-0fc3dab2a12c' TRANSFORM SQL OUTPUT(DM4113_TCPN_DMN_V)> Transform <SQL> requires …
Read More »Does data quality matter to a digital business?
I recently had the good fortune to attend the Garter Data & Analytics Summit in Texas. It was an awesome trip – not just for the best steak I’ve ever eaten (sorry Calgary) – but as a relative newbie to the world of data management, it was an intense three-day …
Read More »How to perform an Inner Join in SAP-BODS and Execute it via Console
The main purpose of creating this blog is i will be showing you how to do an Inner Join in SAP-BODS. Its working point: The inner join captures the common data from both the tables based on common fields. Step 1–> Here on bottom left of the screen you …
Read More »SAP Directories Now Available on SAPStore.com
As a recognized leader in Data Quality Tools for the past decade, SAP clearly understands the value accurate, trustworthy and timely information to the enterprise. Included in SAP’s vast portfolio of data quality solutions, and often behind the scenes, are SAP Address and Geocode Directories. These directories help customers clean their …
Read More »Extracting data from SAP ECC
Many SAP Data Services (DS) applications use SAP ECC data as a source. It now happens that DS supports multiple mechanisms to extract data from SAP ECC. Which one to choose? There often is a preferred method, depending on the functionality required and on the capabilities offered within the actual …
Read More »How to execute a Job in SAP-BODS via Data Services Management Console
As i told you in my previous blog i’ll be coming up with how to execute a Job in SAP-BODS via Data Services Management Console. Reference link of my previous blog: How to create a Project, Job and a simple One To One Mapping in SAP-BODS(Data Services) in a very detailed …
Read More »