Here below you will find the list of our reference jobs to extract data from sources and store the result to a Google Cloud Storage bucket.
| JOB NAME | SOURCE | JOB DESCRIPTION |
|---|---|---|
| J001_SharedFolder_to_GCS | Shared folder | The job uploads a list of files from a shared folder and upload them into a Google Cloud Storage bucket |
| J002_FTP_TO_GCS | FTP FOLDER | The job reads all files from a FTP folder and upload them to a Google Cloud Storage bucket. |
| J003_GDrive_to_GCS | Google Drive | Upload files from a Google Drive folder into Google Cloud Storage |
| J005_Oracle_to_GCS | Oracle DB | It extracts data from using a SQL query and save the result, as a CSV file, in a Google Cloud Storage bucket. |
| J006_GSheet_to_GCS | Google Sheet | It stores the content of a Google Sheet file as a CSV file in a Google Cloud Storage bucket. |
| J007_Excel_to_GCS | Excel file | Upload the content of the tab of an Excel as a CSV file in a Google Cloud Storage bucket. |
| J008_REST_API_to_GCS | REST API | Call a REST API endpoint and upload the reponse as a CSV file in a Googel Cloud Storage bucket. |
| MES, REST API | Call MES Unified API and get interpolated data | |
| J012_MSSQL_TO_GCS | MS SQL Server | It extracts data from a Microsoft SQL server db using a SQL query and save the result, as a CSV file, in a Google Cloud Storage bucket. |
| J013_SF_to_GCS | Salesforce | Extracts data from a Salesforce module and stores it, as a CSV file, in a Google Cloud Storage bucket. |
| J014_SF_Query_to_GCS | Salesforce | Extracts data from a Salesforce module using a SQL query and stores it, as a CSV file, in a Google Cloud Storage bucket. |
| J020_ECC_Table_to GCS | SAP ECC / BW | The job extract the table from SAP |
| J022_BW_MasterData_to_GCS | SAP BW | The job extract master data table and join between attribute and text table and using split file by row number since this component has error on FTP Batch |
| J023_BW_DSO_to_GCS | SAP BW | The job extract data from BW DSO |
| J024_BW_InfoCube_to_GCS | SAP BW | The job extract data from BW Cube |
| J025_BW_ADSO_to_GCS | SAP BW | The job extract data from BW ADSO |
| J026_BW_Multiprovider_to_GCS | SAP BW | The job extract data from BW MultiProvider |
| J027_BW_Composite_to_GCS | SAP BW | The job extract data from BW Composite provider |
| J028_BW_Query_csv_to_GCS | SAP BW | The job extract data from BW Query (Prerequisite configuration on BW and Xtract) |