API Data Provider - Online Help
FreeePM Profile
Connecting to FreeePM
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
PartnerProjectAsContractors
PartnerProjectAsOrderers
Partners
People
ProjectBalance
ProjectConstractors
ProjectMembers
ProjectOrderers
Projects
ProjectTags
ProjectWorkloadTagGroups
TeamMembers
Teams
UnitCostRules
UnitCosts
UsersMe
Workloads
WorkloadSummaries
ProjectMembers
Generated schema file.
Columns
Name
Type
References
ProjectId [KEY]
Integer
PersonId [KEY]
Integer
PersonName
String