Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 3 Next »

Overview

Mainline was tasked with migrating TUFTS existing SAP HR extracts workflow into DENODO. The following documents important information related to this migration.

Diagram

https://tufts.box.com/s/khgpzut7rytigv2rakym6nky450or1gp

https://tufts.box.com/s/grhc5krxgk0k1hii10s97xb9e8f5v5fn

https://tufts.box.com/s/sjwvwt5cmhgj0k7hpetv1uqajeqkzjok

https://tufts.box.com/s/qomybpw6kynwdpulbvq8oc93kjq89o6d

https://tufts.box.com/s/ck4vllbzr88avg16j6d4xxi71ik1a2xi

https://tufts.box.com/s/xg6cnqwlo68nw6wy6fp35pnix0arhd89

https://tufts.box.com/s/fqmuekymokon1y1snro01tcwvksqe49n

https://tufts.box.com/s/0l17s5qynd0ysn9fgtgqlspgrnzgap1n

https://tufts.box.com/s/loj4qspzabjy9d37j6lse0hh2ckehfhm

Denodo Elements

The following is a list of all elements that were added in Denodo. The naming “_final” was used to denote views that serve as the final table, comparable to the original target table. The naming “_lineout” was used to denote views that serve as the lineout/csv file from the existing ETL. These views would be what an API can grab directly from.

DB - Education_technology

Location - 03-integration/SAP_Refactoring/

FIS2X_employees_plus:

  1. df_fis2x_hr_pre_proc_step1

  2. df_fis2x_hr_pre_proc_step2

  3. u_j_fis2x_hr_pre_proc_step2

  4. fis2x_employees_plus_final

FIS2X_HR0_001:

  1. fis2x_hr0_001_final

  2. j_fis2x_hr0_001_01 - ** Cached view

  3. j_fis2x_hr0_001_01_query1

  4. j_fis2x_hr0_001_step2_query

  5. j_fis2x_hr0_001_step2_sql

  6. j_fis2x_hr0_051_final

  7. j_fis2x_hr0_052_final

  8. j_s_hcm_eg_rank_descr

  9. j_s_hcm_names_fname_prf

  10. j_tfth_qry_div

  11. p_bv_d_fis_title

  12. p_bv_d_person_attr

  13. p_bv_s_hcm_dept_tbl

  14. p_bv_s_hcm_dept_tbl_ed

  15. p_bv_s_hcm_eg_rank_tbl

  16. p_bv_s_hcm_jobcode_tbl

  17. p_bv_s_hcm_names

  18. p_bv_s_hcm_names_b1_ed

  19. p_bv_s_hcm_tfth_dept_tbl

  20. p_bv_s_hcm_tfth_dept_tbl_eee

  21. p_bv_s_hcm_tfth_dept_tbl_max_effdt

  22. p_bv_s_tfth_appointmnt_f_ed

  23. p_bv_s_tfth_appointmnt_f_es

  24. p_bv_s_xlattable_vw

  25. p_j_fis2x_hr0_001_01_new_3_may

FIS2X_hr0_002:

  1. df_fis2x_fix_hr0_002_b4_write_sql

  2. fis2x_hr00_lineout - Final view to consume from, previously known as HR_FEED.csv

  3. fis2x_hr0_002_final

  4. j_load_fis2x_hr0_002_query

  5. j_load_fis2x_hr0_002_query_1

  6. j_load_fis2x_hr0_002_query_2

  7. j_load_fis2x_hr0_002_query_3

  8. j_load_fis2x_hr0_002_sql

  9. j_load_fis2x_hr0_002_sql_pref_name

  10. p_bv_d_hcm_degree_suffix_view_lookup

  11. p_bv_d_hcm_home_dept_tbl_lookup_descr

  12. p_bv_d_hcm_pers_names_lookup

  13. p_bv_s_tfth_fis_affctr_lookup

  14. p_load_hr0_002_sql_1

  15. p_load_hr0_002_sql_2

  16. p_u_fis2x_hr0_001_max_selection_rank

FIS2X_HR1_001:

  1. df_fis2x_load_hr1_001

  2. fis2x_hr01_lineout - Final view to consume, previously HR_PROF_1.csv

  3. fis2x_hr1_001

  4. fis2x_hr1_001_final

FIS2X_hr2_001:

  1. df_fis2x_load_hr2_001__new_sql

  2. fis2x_hr2_001_final

  3. p_bv_d_hcm_home_dept_tbl_lookup_tfth_qry_div

  4. p_bv_s_hcm_tfth_dept_tbl_descr_lookup

FIS2X_HR2_002:

  1. df_fis2x_load_hr2_002_new_query

  2. df_fis2x_load_hr2_002_new_query_1

  3. df_fis2x_load_hr2_002_new_sql

  4. fis2x_hr02_lineout - Final view to consume, previously HR_PROF_2.csv

  5. fis2x_hr2_002_final

  6. p_bv_d_hcm_home_dept_tbl_lookup_pdept

  7. p_bv_d_hcm_home_dept_tbl_lookup_pdept_ed

FIS2X_HR3_001:

  1. df_fis2x_load_hr3_001_final

  2. df_fis2x_load_hr3_001_lineout - Final view, HR_PROF_3.csv

  3. df_fis2x_load_hr3_001_sql

FIS2X_HR4_001:

  1. df_fis2x_load_hr4_001_final

  2. df_fis2x_load_hr4_001_lineout - Final view, HR_PROF_4.csv

  3. df_fis2x_load_hr4_001_query

  4. df_fis2x_load_hr4_001_sql

FIS2X_HR5_001:

  1. df_fis2x_load_hr5_001_final

  2. df_fis2x_load_hr5_001_lineout - Final view, HR_PROF_5.csv

  3. df_fis2x_load_hr5_001_sql

FIS2X_HR6_001:

  1. df_fis2x_load_hr6_001_final

  2. df_fis2x_load_hr6_001_lineout - Final view, HR_PROF_6.csv

  3. df_fis2x_load_hr6_001_sql

  4. p_bv_s_xlattable_vw_2

FIS2X_HR7_001:

  1. df_fis2x_load_hr7_001_final

  2. df_fis2x_load_hr7_001_lineout - Final view, HR_PROF_7.csv

  3. df_fis2x_load_hr7_001_sql

FIS2X_HR8_001:

  1. df_fis2x_load_hr8_001_final

  2. df_fis2x_load_hr8_001_lineout - Final view, HR_PROF_8.csv

  3. df_fis2x_load_hr8_001_sql

  4. df_fis2x_load_hr8_001_sql1

FIS2X_hr_url_master:

  1. fis2x_hr_url_all_sql

  2. fis2x_hr_url_master_all_empids

  3. fis2x_hr_url_master_all_emplids_plus_historical - **Cached

  4. fis2x_hr_url_master_final

  5. fis2x_hr_url_master_sql

  6. p_bv_fis2x_hr_url_master

  7. p_bv_fis2x_hr_url_master_tag

  8. p_fis2x_hr_url_master_historical_query

TODO - add job name for nightly cache refresh

Supporting Documents

FIS2X Elements documentation: DI_JOB_FIS2X_Generate_Extracts.xlsx

Additional info

For any questions reach out to:
Colton Henderson - chende03@tufts.edu

John Klein - john.klein@tufts.edu

  • No labels