Chapter 3. Data Services Basics – Data Types, Scripting Language, and Functions

In this chapter, I will introduce you to scripting language in Data Services. In this chapter, we will cover the following topics:

  • Creating variables and parameters
  • Creating a script
  • Using string functions
  • Using date functions
  • Using conversion functions
  • Using database functions
  • Using aggregate functions
  • Using math functions
  • Using miscellaneous functions
  • Creating custom functions


It is easy to underestimate the importance of the scripting language in Data Services, but you should not fall for this pitfall. In simple words, scripting language is a glue that allows you to build smart and reliable ETL and unite all processing units of work (which are dataflow objects) ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.