In this chapter, we have taken a look at Business Objects Data Services (BODS). We have seen that it is an ETL (Extract, Transform, Load) tool, developed by SAP.
We have seen that a data transfer needs a source, an optional transformation, and a target. Sources and targets can be flat files (formats), or database tables (datastores), and transformations can do simple things such as text case changes, or more complex transformations, maybe complex enough to require coding via the use of functions.
A data flow can be included in a work flow if it needs to be reusable, and either data flows or work flows can be included in a job, which can then be executed to run the data transfer.
We have now examined both data modeling in SAP HANA in the first ...