Mitratech University
Mitratech University provides end users, administrators and developers continuing education for sound practices and discipline in Collaborative Accountability for high-liability enterprise processes.
TeamConnect ERD Database Schema
This course provides students with a summary of TeamConnect database schema, to help system developers and database administrators interested in data migration and BusinessObjects reports. Students learn TeamConnect objects, their attributes, and their relationships with other objects found in the structure of the TeamConnect database as well as in the API.
Course Name:
TeamConnect ERD Database Schema
Audience:
Developer,
Business Objects Designer
Duration:
1/2 Day
Format:
80% Lecture, 20% Lab
Type:
Instructor-led training
System developers and database administrators interested in data migration and BusinessObjects reports.
Skill Level:
Intermediate
Available Locations:
Private Location,
Online Course Delivery,
Client Location
- Understand TeamConnect objects, their attributes, and their relationships;
- Use TeamConnect’s Data Warehouse scripts;
- Query data directly from TeamConnect’s database for troubleshooting.
- Previous System Administration training;
- Structured Query Language.
Course Outline:
- TeamConnect Objects:
- System Objects and Main tables
- Supplemental tables
- Y tables
- How data is mapped into the database
- How and where the detail fields are stored
- How to query data directly from the database for troubleshooting
- Exercises and Q&A
