Home / SAP Data Services

SAP Data Services

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 »

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 »

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 »

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 »

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 »

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 »

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 »