SABA Integration

  • EdCast LXP platform uses generic SFTP connector with CSV file for SABA integration
  • Generic SFTP connector uses source transformation feature to transform different CSV formats
  • SABA support matrix
    • 5.5
      • Courses - Education & Development Courses
      • Curriculum - Education & Development Paths
    • Cloud
      • Courses - My Learning Courses
      • Curriculum My Learning Paths
  • SABA integration adds the courses,assignments and completions data to LXP
  • Smart Cards are created for Courses
  • Curriculum is represented as one card in LXP. Child Content will be displayed in SABA
  • SABA Generic SFTP connector supports detailed log monitoring through UI
  • Supports syncing up archived in courses in SABA with LXP
  • LXP synchronizes the courses, assignments and completions data from SABA once in a day (Recommended)

SABA 5.5 - Courses - CSV File Format


Name

Description

Sample Value

id

● Unique Id for the Card
● If empty, then URL will be used as a unique identifier

curra000000000002350

title

Title to be displayed on the card

Q3 2008 Core Sales (EMEA) Required Training

description

Description to be displayed for the card

Q3 2008 Core Sales (EMEA) Required Training

image_url

● The image to be displayed on the card.
● If empty, then source default image will be displayed.
● If the default image is also empty, then stock images will be displayed.

deep_link_url

The URL to which the user will be navigated to when
he clicks on the card. This should point to the actual
content

https://acme.sabacloud.com/Saba/Web_spf/PRODTNT091/common/ledetail/cours000000000357675

keywords

Will be used as the tags. Multiple tags should be separated by the comma

readable_card_type

● The Readable-Card-Type e.g. document to be displayed on the card. If blank, the card will
display "course" as the readable_card_type.
● default value also can be added from source_transformation

course

content_type

The Content-Type of the card, If blank, then it will be considered "course" as the content type

course

duration

● The duration to be displayed on the card
● The format should be like hh:mm or hh:mm:ss

12:30:12

archive

If the value here is "Y" or "y", the card will be archived
& no longer displayed to the users

Y

archive_date

● This value will be used only if the archive header is empty or not present in the given CSV file.
● A date after which course will be going to expire
● Date format should be in YYYY-MM-DD
● While processing CSV file if archive date < today's date then system will mark the course as archived otherwise no action will be taken.

2019-02-24


SABA 5.5 - Courses - Source Transformation

Copy and paste the below value in source_transformation value while configuring SFTP source.

{
   "value_transformation":[
      {
         "target_header":"readable_card_type",
         "operation":"add_default",
         "default_value":"course"
      }
   ],
   "header_transformation":[
      {
         "target_header":"duration",
         "replace_value":"duration_in_hh_mm_ss"
      }
   ]
}  

SABA 5.5 - Curriculum - CSV File Format


Name

Description

Sample Value

id

● Unique Id for the Card
● If empty, then URL will be used as a unique identifier

curra000000000002350

title

Title to be displayed on the card

Q3 2008 Core Sales (EMEA) Required Training

description

Description to be displayed for the card

Q3 2008 Core Sales (EMEA) Required Training

image_url

● The image to be displayed on the card.
● If empty, then source default image will be displayed.
● If the default image is also empty, then stock images will be displayed

deep_link_url

The URL to which the user will be navigated to when he clicks on the card. This should point to the actual content

https://acme.sabacloud.com/Saba/Web_spf/PRODTNT091/common/ledetail/cours000000000357675

keywords

Will be used as the tags. Multiple tags should be separated by the comma

readable_card_type

● The Readable-Card-Type e.g. document to be displayed on the card. If blank, the card will
display "course" as the readable_card_type
● default value also can be added from source_transformation

course

content_type

The Content-Type of the card, If blank, then it will be considered "course" as the content type.

course

duration

● The duration to be displayed on the card
● The format should be like hh:mm or hh:mm:ss

12:30:12

archive

If the value here is "Y" or "y", the card will be archived & no longer displayed to the users

Y

archive_date

● This value will be used only if the archive header is empty or not present in the given CSV file.
● A date after which course will be going to expire
● Date format should be in YYYY-MM-DD
● While processing CSV file if archive date < today's date then system will mark the course as archived otherwise no action will be taken.

2019-02-24


SABA 5.5 - Curriculum - Source Transformation

Below value should be saved in source_transformation value while configuring SFTP source.

{
   "value_transformation":[
      {
         "target_header":"readable_card_type",
         "operation":"add_default",
         "default_value":"curriculum"
      }
   ],
   "header_transformation":[
      {
         "target_header":"duration",
         "replace_value":"duration_in_hh_mm_ss"
      }
   ]
}   

SABA Cloud - Courses - CSV File Format


Name

Description

Sample Value

course_course_id

● Unique Id for the Card
● If empty, then URL will be used as a unique identifier

35129

course_title

Title to be displayed on the card

Customer Care - Productive Case Management - Ownership

description

Description to be displayed for the card

Utilize this training to help you increase customer experience, better.

image_url

● The image to be displayed on the card.
● If empty, then source default image will be displayed.
● If the default image is also empty, then stock images will be displayed.

deeplink

The URL to which the user will be navigated to when he clicks on the card. This should point to the actual content

https://acme.sabacloud.com/Saba/Web_spf/PRODTNT091/common/ledetail/cours000000000357675

course_keywords

Will be used as the tags. Multiple tags should be separated by the comma

readable_card_type

● The Readable-Card-Type e.g. document to be displayed on the card. If blank, the card will display "course" as the readable_card_type
● default value also can be added from source_transformation

curriculum

content_type

The Content-Type of the card, If blank, then it will be considered "course" as the content type

course

duration

● The duration to be displayed on the card
● The format should be like hh:mm or hh:mm:ss

12:30:12

archive

If the value here is "Y" or "y", the card will be archived & no longer displayed to the users

Y

archive_date

● This value will be used only if the archive header is empty or not present in the given CSV file.
● A date after which course will be going to expire
● Date format should be in YYYY-MM-DD
● While processing CSV file if archive date < today's date then system will mark the course as archived otherwise no action will be taken

2019-02-24


SABA Cloud - Courses - Source Transformation

Below value should be saved in source_transformation value while configuring SFTP source.

{
   "value_transformation":[
      {
         "target_header":"readable_card_type",
         "operation":"add_default",
         "default_value":"course"
      }
   ],
   "header_transformation":[
      {
         "target_header":"course_keywords",
         "replace_value":"keywords"
      },
      {
         "target_header":"course_course_id",
         "replace_value":"id"
      },
      {
         "target_header":"duration",
         "replace_value":"duration_hh:mm:ss"
      },
      {
         "target_header":"course_title",
         "replace_value":"title"
      },
      {
         "target_header":"course_description",
         "replace_value":"description"
      },
      {
         "target_header":"deeplink",
         "replace_value":"deeplink_url"
      }
   ]
}

SABA Cloud - Curriculum - CSV File Format


Name

Description

Sample Value

curriculum_id

● Unique Id for the Card
● If empty, then URL will be used as a unique identifier

curra000000000002350

curriculum_name

Title to be displayed on the card

Q3 2008 Core Sales (EMEA) Required Training

description

Description to be displayed for the card

Q3 2008 Core Sales (EMEA) Required Training

image_url

● The image to be displayed on the card.
● If empty, then source default image will be displayed.
● If the default image is also empty, then stock images will be displayed

deep_link_url

The URL to which the user will be navigated to when he clicks on the card. This should point to the actual content

https://acme.sabacloud.com/Saba/Web_spf/PRODTNT091/common/ledetail/cours000000000357675

curricula_category

Will be used as the tags. Multiple tags should be separated by the comma

readable_card_type

● The Readable-Card-Type e.g. document to be displayed on the card. If blank, the card will
display "course" as the readable_card_type
● default value also can be added from source_transformation

curriculum

content_type

The Content-Type of the card, If blank, then it will be considered "course" as the content type.

course

duration

● The duration to be displayed on the card
● The format should be like hh:mm or hh:mm:ss

12:30:12

archive

If the value here is "Y" or "y", the card will be archived & no longer displayed to the users

Y

archive_date

● This value will be used only if the archive header is empty or not present in the given CSV file.
● A date after which course will be going to expire
● Date format should be in YYYY-MM-DD
● While processing CSV file if archive date < today's date then system will mark the course
as archived otherwise no action will be taken

2019-02-24


SABA Cloud - Curriculum - Source Transformation

Below value should be saved in source_transformation value while configuring SFTP source.

{
   "value_transformation":[
      {
         "target_header":"readable_card_type",
         "operation":"add_default",
         "default_value":"curriculum"
      }
   ],
   "header_transformation":[
      {
         "target_header":"curricula_category",
         "replace_value":"keywords"
      },
      {
         "target_header":"curriculum_id",
         "replace_value":"id"
      },
      {
         "target_header":"duration",
         "replace_value":"duration_hh:mm:ss"
      },
      {
         "target_header":"curriculum_name",
         "replace_value":"title"
      },
      {
         "target_header":"curriculum_description",
         "replace_value":"description"
      },
      {
         "target_header":"deeplink",
         "replace_value":"deeplink_url"
      }
   ]
}

SABA Integrations - Monitoring Logs

Logs of SABA generic SFTP connector can be viewed/Downloaded from the LXP Integrations page



SABA Integration - Completions

  • SABA completions can be pushed to LXP using LRS SFTP connector
  • LRS SFTP connector runs once in a day and synchronizes the completion data for the users
  • CSV Attributes

Fields

Description

actor_name

Map the EdCast LXP schema to customer’s
WorkDay schema

actor_id

Organization of the customer deployment

object_id

The option enables the WorkDay connector

status

object_name


  • We will updating the configuration of the source(SFTP LRS) to include new fields - This helps us determine which source this completion is for and mapping for identifying the user (i.e. Custom Field to User Id).


  • We will be looking up the content with object_id provided to get URL of the content.
    • If Content is found in ECL database we will push with URL from the content item.
    • If Content is not found in ECL database we will push to LRS with object_id.
  • We will be looking up user id depending upon the mapping provided in the source_configuration.
    • If User is found in LXP database we will push the statement into LRS.
    • If User is not found in LXP database we will not be pushing the statement into our LRS.
  • Then we will be pushing the data into LRS