Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
Access your training data in the business intelligence tool of your choice. Allowing you to share training data with the rest of the organization.

About

We know your Learndot data is important to you for reporting, analytics and much more. Our Data Pipeline App provides you the ability to access your data in several ways and define how you use it. To make our data structure and relationships easier to understand we simplify our data model down into a Logical Data Model. All data that is listed as part of our Logical Data Model comes as part of our Data Pipeline App. 

Info
Data is populated and refreshed through batch operations performed on intervals. NOTE: Our Data Pipeline App does not provide real-time data updates, only interval batch updates which happens every 4 hours. For a shorter window, please reach out to us via our success portal. And, if you looking for real-time data access, consider using our Learndot API.


Note
Additional cost is associated with this App, please contact us using our success portal for details or reach out to us at support@learndot.com

App Aim

It is important to first understand the purpose of the integration and what problem it will solve. The purpose of this connector is to:

  • Allow Administrators to collect their Learndot data into their own personal database for running internal queries or generating reports.

Setting up Data Pipeline App

To Setup the Data Pipeline App:


Excerpt
hiddentrue

Vendor-Hosted database

ServiceRocket will host a MySQL database for you and provide credential access. The full Logical Data Model will be available with regular data refreshes. 


Info
titleNote

We need to define the steps and process in order to offer this



  1. Choose We only offer a single Database type. Our Data Pipeline App can be connected to a variety of destinations Details is, as listed below: 
    1. Customer-Hosted database
      You host a MySQL database and provide ServiceRocket read-write access to database. ServiceRocket will provide a script to create the necessary tables and columns in database to match what is listed as part of the Logical Data Model. The full Logical Data Model will be available with regular data refreshes

      Custom
      Want something different? Get in contact with our Learndot Support Team to inquire about connecting our Data Pipeline App to additional locations or getting data feeds in different formats

  2. Send an email to Learndot Support requesting to get onboard the Data Pipeline App along with the type of database (Customer-Hosted OR Custom) you choose to use.
  3. If you choose to utilize your own database, Support will revert back to you with our Data Pipeline App Server IP Address which the database administrator has to White-list and Database creation SQL statement which the database manager has to run, to successfully create the database. 
  4. After creating the database and white-listing the Server IP Address, revert back to Learndot Support with the database Username and Password, and the URL (path of the database).  
  5. Our Learndot team will perform the initial push. Synchronization will then take place with regular data refreshes. 

Logical Data Model

Our Logical Data Model is a simplified model of our underlying Learndot database. Click here to learn more about our Data Model. Feel free to reach out to our Learndot Support Team with questions or clarifications around any of the data attributes.


Info
titleRecord Deletion

Deletion is not supported at the moment. Therefore if a record deleted from Learndot, it will not be deleted from the destination database.


Feature Implementation

Any custom feature request will be considered and added to the roadmap for implementation if deemed viable. 

Excerpt
hiddentrue


Expand
titleAchieve


Entity NameFieldsDescription
Account
  • Name
  • Address Country
  • Address City
  • Address Region
  • Address Postal Code
  • Tax ID
  • Phone
  • Fax
  • Logo
  • Created Date
  • Created By ID
  • Modified Date
  • Modified By ID

Catalog Item
  • Currency
  • Name
  • Status
  • Type

Category
  • Name

Class
  • Type
  • Language
  • Equipment Provided
  • Refreshments Provided
  • Food Provided
  • Snacks Provided
  • Courseware Provided
  • Status
  • Capacity
  • Hours
  • Start Date
  • Instructors (relationship)
  • Location (relationship)
  • Learning Component (relationship)

Contact
  • Email
  • First Name
  • Last Name
  • Name
  • Address City
  • Address State
  • Address Postal Code
  • Address Country
  • Title
  • Department
  • Salutation
  • Office Phone
  • Home Phone
  • Fax
  • Email Verified
  • Enabled
  • Enabled Staff
  • Tax ID
  • Date of Birth
  • Last Login
  • Last Password Reset
  • Created By ID
  • Created Date
  • Modified Date
  • Modified By ID
  • Number of Successful Logins
  • Number of Forum Posts
  • Account (relationship)

Course
  • Name
  • Type
  • Progress
  • Contact (relationship)
  • Account (relationship)

Discount
  • Currency
  • Amount
  • Created
  • Coupon (relationship)
  • Order Line (relationship)
Tracks the number of discounts given and the reason for the discount (eg manual adjustment, pricing rule, coupon, etc.)
Discount Rule
  • Coupon Code
  • Enabled
The list of all Coupons and Discount Rules in the system
Enrollment
  • Status
  • Score
  • Time Spent
  • Confidence
  • Created
  • Completed
  • Expiry
  • Learning Component (relationship)
  • Contact (relationship)
  • Class (relationship)
  • Provider (relationship)

Instructor
  • Name

Lead
  • Status
  • Subject
  • Created
  • Contact (relationship)

Learning Component
  • Name
  • Language
  • Type

Learning Pathway
  • Name
  • Progress
  • Contact (relationship)
  • Account (relationship)

Location
  • Address City
  • Address Region
  • Address Postal Code
  • Address Country
  • Name
  • Time Zone
  • Online

Opportunity
  • Currency
  • Stage
  • Value
  • Created
  • Type
  • Lead (relationship)
  • Contact (relationship)
  • Account (relationship)
Type can be either "Request for Quote", "Request for Class" or NULL
Order
  • Status

Order Line
  • Status
  • Paid (Calculated)
  • Price
  • Discount (Calculated)
  • Tax
  • Total
  • Training Credits
  • Catalog Item (relationship)
  • Contact (relationship)
  • Account (relationship)
  • Provider (relationship)
  • Category (relationship)
  • Payment (relationship)
  • Order (relationship)
  • Class (relationship)

Payment
  • First Name
  • Last Name
  • Organization
  • Tax ID
  • Tax Country
  • Phone
  • Email
  • Currency
  • Failure Message
  • Status
  • Address Street 1
  • Address Street 2
  • Address City
  • Address Region
  • Address Postal Code
  • Address Country
  • Type
  • Amount
  • Order (relationship)

Provider
  • Name

Stream Post
  • URL Name
  • Title
  • Created
  • Views
  • Comments
  • Categories (relationship)
  • Author (relationship)

Training Credit Account
  • Name
  • Balance
  • Created

Training Credit Redemption Request
  • Status
  • Amount
  • Training Credit Account (relationship)
  • Order (relationship)
  • Contact (relationship)
  • Payment (relationship)

Training Credit Transaction
  • Amount
  • Reconciled
  • Created
  • Training Credit Account (relationship)

Training Survey Response
  • Facilities - Amenities Rating
  • Facilities - Equipment Rating
  • Facilities - Location Rating
  • Instructor - Knowledge Rating
  • Instructor - Pace Rating
  • Instructor - Presentation Rating
  • Instructor - Questions Rating
  • Instructor - Skills Rating
  • Overall Rating
  • Recommended Rating
  • Training - Curriculum Rating
  • Training - Expectations Rating
  • Training - Labs Rating
  • Training - Objectives Rating
  • Training - Organized Rating
  • Training - Overall Rating
  • Come Again Rating
  • Created
  • Class (relationship)
  • Location (relationship)
  • Learning Component (relationship)







Panel

Table of Contents


Tip

Got a suggestion for a new app or integration? Contact our friendly Support Team.


Tip
titleKey Resources

Quick links to additional resources for Data Pipeline App:

  1. Logical Data Model for Data Pipeline App
  2. Release Notes for Data Pipeline
  3. ERD Diagram