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

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 …

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 …

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 …

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 …

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 …

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

  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 …

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 …

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