Skip to main content

How to Connect Foundation to Workyard

A guide on the details you'll need to share to connect Foundation to Workyard

John Lambert avatar
Written by John Lambert
Updated over a week ago

Using the Workyard integration you can say goodbye to manually entering time data into Foundation! With Workyard you'll be able to pull in new employees, jobs and cost codes at the click of a button. And, easily export all of your time data from Workyard broken down by employee, phases, projects, cost codes and trades to import back into Foundation

How It Works

We'll need your Foundation account details along with a few set up preferences to enable your connection with Workyard:

What type of Foundation installation does your company have?

What is your Foundation Database name? (Example: CAS_1234)

What is the username for the Foundation database?

What is the password for the username?

Does your company use Phases in Foundation?

Does your company use Trades in Foundation?

Does your company use Cost Codes in Foundation?

Do you want Workyard or Foundation to calculate the overtime?

What is the earn code for Regular time?

What is the earn code for Overtime? (Enter 'none' if your company does not accrual overtime)

What is the earn code for Double time? (Enter 'none' if your company does not accrual double time)

What is your Database Host name? Here is a help article to help you locate your Foundation Database name: How Do I Find the Database Host Name For Foundation?

Do you want Workyard or Foundation to calculate the overtime?

What is the earn code for Paid time off? (Enter 'none' if this does not apply to your company)

What is the earn code for Unpaid time off? (Enter 'none' if this does not apply to your company)

What is the earn code for Holiday pay? (Enter 'none' if this does not apply to your company)

What is the earn code for Sick pay? (Enter 'none' if this does not apply to your company)

(For On-Premise Only) - What is your IPAII TCP Dynamic Port or Port number? How to find your port number can be found in this help article under "Getting Your SQL Server Port"

Once you have all these details send them to help@workyard.com or your account representative and we'll get your connection up and running!

Did this answer your question?