Loader
Mitratech - Connecting People, Knowledge, Process Connecting People, Knowledge, Process

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

Who Should Attend:

System developers and database administrators interested in data migration and BusinessObjects reports.

Skill Level:
Intermediate

Available Locations:
Private Location, Online Course Delivery, Client Location

Skills Obtained:
  • Understand TeamConnect objects, their attributes, and their relationships;
  • Use TeamConnect’s Data Warehouse scripts;
  • Query data directly from TeamConnect’s database for troubleshooting.
Prerequisites:
  • 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