SAP Data Services

What if you select the Sorted Input option in Table Comparison but forgot to give the order by condition?

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 this practically, Below is the mapping I’ve created:   Before execution, Source data: Query Transform: Table Comparison: Target data:   …

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   Information: Business Objects Data Integrator XI R2 Accelerated (11.7.3) and previous versions required a node-locked-license key file to activate …

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   Information: Business Objects Data Integrator XI R2 Accelerated (11.7.3) and previous versions required a node-locked-license key file to activate …

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 server that will be the source for the database Name the device, the path will be auto populated Specify 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 address data. DQMms key capabilities are: Address Cleansing Validate addresses per postal authority reference data Standardize the way addressed look …

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 called Table Comparison and its feature Detect Deleted Rows from comparison table comes handy in achieving this task. Let’s see …

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 Data Services 4.2 SP8 Migration Tools: Data Services Repository Manager Repository version: BODI 11.7 or BODS 3.X or BODS 4.X Installation & …

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 single Datastore and configure the System Configuration.   Detailed Steps for the Solution: Step 1: Create a Datastore and right …

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 <= 10) select * from ( SELECT distinct datastore_name, cast (substr(list,INSTR(LIST,'<DSConfigurationdefault=',1,seq_num)+37,instr(list,'">',INSTR(LIST,'<DSConfigurationdefault=',1,seq_num))-INSTR(LIST,'<DSConfigurationdefault=',1,seq_num)-37) as varchar2(4000)) as configuration, cast (substr(list,INSTR(LIST,'<oracle_host_string>',1,seq_num)+20,instr(list,'</oracle_host_string>',INSTR(LIST,'<oracle_host_string>',1,seq_num))-INSTR(LIST,'<oracle_host_string>',1,seq_num)-20) as varchar2(4000)) as …

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 goslate dct = locals() gs = goslate.Goslate() dct[u’Expresion’] = record.GetField(u’Expresion’) dct[u’Expresion’] = gs.translate(dct[u’Expresion’],’de’) record.SetField(u’TX’,dct[u’Expresion’] ) You can change ‘de’ (Deutsche) …

Read More »