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

Introduction

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.