Data Services Python Script Call In the magical world of data extraction Data Services offers great out of the box functionality to extract data from databases like SQL Server, MySQL, PostgreSQL, Oracle… and from SAP ECC. However, to extract data from REST APIs it lacks some functionality. Therefore, we will use one of the most […]
Tag: BODS
BODS – ETL Framework [Part II]
BODS – ETL Framework [Part II] Note: this is the second part of the blog. Missed the first part? Read it here. For the extraction of data, a where clause needs to be defined. With the current logic this will be a combination of global variables ($G_Load_Mode, $G_Extraction_From_DT, $G_Extraction_To_DT, $G_Delta_Days). $G_Load_Mode: INIT/DELTA (All or subset of […]
BODS – ETL Framework [Part I]
BODS – ETL Framework [Part I] Requirements Each execution step in a job should be logged in a logging table Provide a delta and init mechanism ‣ Extraction from and to date need to be calculated automatically (moving window) ‣ Assign own extraction from and to date ‣ Use sysdate and subtract […]