Request help
What are integrations?
Kuali Build lets you integrate data from other systems like Banner, the Davidson Enterprise Data Warehouse, Blackbaud, Atrium, etc. Below is a list of available integrations with a short description about the data the integration retrieves.
We've split these integrations into two sections:
Form Integrations populate data into a form, like auto-filling certain form fields with user information or creating a dropdown list of options (e.g. campus buildings, departments, etc).
Workflow Integrations send form data to another system. So if you need to upload your data to a PowerBI report or update data in Banner.
Form Integrations
| Name | Description |
| Accounts: Expenses (By Code) | Gets a list of expense accounts from DavidsonEnterpriseDataWarehouse.dbo.DimAccount, ordered by code. |
| Accounts: Expenses (By Name) | Gets a list of expense accounts from DavidsonEnterpriseDataWarehouse.dbo.DimAccount, ordered by name. |
| Buildings | Lists all of the buildings in EMS by description. |
| CatCard: Accounts (All) | A list of every account type in Atrium. |
| CatCard: Accounts (Meal Plan) | A list of accounts in Atrium with Meal Plan currency type. |
| CatCard: Accounts (USD) | A list of accounts in Atrium with USD currency type. |
| Deparments: Name | Gets a list of departments by name from DavidsonEnterpriseDataWarehouse.dbo.DimOrganization. |
| Departments: Org Code | Gets a list of departments by org code from DavidsonEnterpriseDataWarehouse.dbo.DimOrganization. |
| Google Sheets | API integration to grab google sheets data |
| Integrations | Lists all integrations in Kuali Build. |
| Kuali: List Apps | Lists all Kuali apps in the environment. |
| Payroll: Deductions | Retrieves a list of optional payroll deduction codes of type 43 from Banner PTRBDCA. Employees may assign a one-time or recurring gift to any of these codes, which include organizations and initiatives such as WDAV, Lula Bell's Resource Center, and Friends of the Arts. |
| Scholarships | A list of scholarships from DavidsonEnterpriseDataWarehouse.dbo.DimEducationalInvolvement. |
| Sports: All | A list of all sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| Sports: Club | A list of Club Sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| Sports: Varsity | A list of Varsity Sports from EnterpriseDataWareHouse.dbo.DimEducationalInvolvement. |
| Subjects: Current | A list of departments offering courses in the current and next academic year. |
| Subjects: Majors | Retrieves a list of all primary and secondary majors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| Subjects: Minors All | Retrieves a list of all minors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| Subjects: Minors No Interdisciplinary | Retrieves a list of minors without interdisciplinary minors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| Subjects: Minors Only Interdisciplinary | Retrieves a list of only interdisciplinary minors held by current students from DavidsonEnterpriseDataWarehouse.student.vw_CurrentStudents. |
| Terms (By Code) | Gets a list of academic terms from DavidsonEnterpriseDataWarehouse.dbo.DimAcademicTerm, in descending order, labeled by code. |
| Terms (By Name) | Gets a list of academic terms from DavidsonEnterpriseDataWarehouse.dbo.DimAcademicTerm, in descending order, labeled by name. |
Workflow Integrations
| Name | Description |
| Covid-19: Populate Attendance Database | Inserts select fields from the Covid-19 test attendance tracker into the stg_Kuali_COVID19_TestCheckIn in wildcatODS. |
| Dev Covid Testing Reconciliation | A testing version of the Covid Testing Reconciliation Process |
| Kuali + GDrive => Kuali: Covid Testing Notifications Task | Covid Testing Notifications Task |
| Kuali: Clone App to Production | Clones a Kuali app to the production environment. Copies form and workflow structure. Does not copy documents or permissions. References to users, groups, and integrations will break when cloning to a different environment than the source app. |
| Kuali: Clone App to Sandbox | Clones a Kuali app to the sandbox environment. Copies form and workflow structure. Does not copy documents or permissions. References to users, groups, and integrations will break when cloning to a different environment than the source app. |
| Kuali: Clone App to Staging | Clones a Kuali app to the staging environment. Copies form and workflow structure. Does not copy documents or permissions. References to users, groups, and integrations will break when cloning to a different environment than the source app. |
| Kuali=>Smartsheet:Compliance Task | Triggers the warnings and compliance process to update smartsheet |
| STMP: Send T&I Mailer | Sends an HTML formatted email as ti@davidson.edu. |
| Send Data Elements to SmartSheet | Sends data elements submitted by the the Data Catalog working group for review by the Data Governance group. |
| Send Integration Request to Smartsheet | Sends an integration request to smartsheet as a new row |
| Send an E-Card | Sends one of 10 different e-cards to someone. |
| T&I Zendesk - COVID Faculty Hardware Request | Creates a zendesk ticket for a COVID faculty hardware request |
| T&I: Zendesk - CAB Ticket | Creates a change execution ticket in the T&I Change Advisory Board Zendesk group. |
| Update Lost and Found | This integration sends information about lost and found items to snaplogic and ultimately Zendesk. |
Comments
0 comments
Please sign in to leave a comment.