SAP Data Services

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 …

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 …

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 …

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 …

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 …

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 …

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 …

  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 …

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 …

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 …

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 …

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 …

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) …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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. …

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 …

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 …

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. …

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 …

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 …

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 …

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 …

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 …

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 …