Clients
Pike: Customers
Carries over: Client name and the projects billed to it.
You set in Pike: Nothing.
Template columns: customerName
Migration guide
Move from Deltek Ajera to Pike
Connect Ajera through an API user, run Import data, and keep syncing while teams move one at a time. Budget five weeks from connection to cutover, then one month-end in Pike.
Available now
Pike reads Ajera through the Ajera API, so clients, projects with their phases, employees, timesheet entries and invoices import with their links intact.
- In Ajera, go to Setup → Utility → Setup Integrations, open the API User tab and click New. Use a user name and password that differ from any employee login, select an authorizing employee, and tick Can Read. Ajera’s timesheet API requires an active authorizing employee.
- On the API Settings tab, copy the API URL. On a self-hosted Ajera, enter the external server address first. Ajera Cloud fills both in.
- In Pike, go to Workspace settings → Integrations → Deltek Ajera, click Add integration, enter the API URL and the API user, then click Import data. The stepper imports clients, projects, phases, employees, timesheet entries and invoices, in that order.
- Turn on Keep syncing. Pike imports new Ajera timesheet entries every 3 hours while the rest of the team finishes the month in Ajera.
Pike never writes to Ajera, so leave Can Write off on the API user. A project removed in Ajera shows as Removed in Ajera in Pike, with its history intact.
Available now
Use CSV when no Ajera administrator can set up an API user, or when you bring over only part of your history.
- Open Reports → Standard Inquiries → Employee → Timesheet Detail, set the date range, and click Export → Microsoft Excel (.xls). The export includes only the columns the inquiry shows.
- The inquiry lists one row per timesheet line with Day 1 to Day 7 columns. Turn each day into its own row with a `date` and `hours` before you upload.
- Map Project ID to `projectNumber`, Phase Description to `taskTitle` or Phases `phase`, and the employee’s email from your employee list to `email`. Check whether your export includes billable status.
- Upload customers, projects, phases, members, then time entries under Workspace settings → Integrations → CSV, using the CSV templates. Invoice history does not import by CSV.
Native sync is the only route that imports Ajera invoices, phase budgets and hourly rates with their project links.
Entity map
What each Deltek Ajera record becomes in Pike
Column one uses Ajera's own labels. Pike matches people on the email of each Ajera employee.
Projects
Pike: Projects
Carries over: Project ID, description, billing type, budget and hourly rates.
You set in Pike: Team and project template.
Template columns: projectNumber, title, customerNumber, billingType, budgetAmount, budgetHours, hourlyRate
Phases
Pike: Phases
Carries over: Phase name and budget, under the matching project.
You set in Pike: Start and end dates.
Template columns: projectNumber, phase, startDate, endDate
Employees
Pike: Members
Carries over: Name and email.
You set in Pike: Workspace role, team, position and cost profile.
Template columns: email, displayName
Timesheet entries
Pike: Time entries
Carries over: Date, hours, project, notes and billable flag.
You set in Pike: Approval. Pike’s Ajera import lists notes and the billable flag, and no supervisor or accounting approval, so approve open weeks in Time admin.
Template columns: date, hours, email, projectNumber, taskTitle, note, billableStatus
Client invoices
Pike: Invoice history (read-only)
Carries over: Invoices on each project.
You set in Pike: New invoices go out from Pike from cutover.
Activities
Pike: Not imported
Carries over: Activity on each timesheet line, such as Billable Time or Meetings.
You set in Pike: Labels, if you report on activity today.
Ajera bills Time & Expense projects from a billing rate table. When the table has no rate, Ajera multiplies the cost rate by the table’s markup. Pike imports the hourly rates on each project, so compare one project per rate table after the import.
Ajera has fee-based billing types (Fixed Fee, Percent Complete, Unit Price, Percent of Construction Cost) and Nonbillable, Marketing and Overhead. Pike has fixed fee, time and materials and non-billable, so check the type on every Percent Complete and Unit Price project.
Phase budgets import under each project. Pike’s Ajera import lists no cost rates, so set a cost profile for each member from the Ajera pay rate before the pilot.
The plan
Seven steps out of Deltek Ajera
The same steps as the main migration guide, with this tool's screens and settings.
Week 1
Migration owner, finance
Week 1 · Migration owner, finance
Freeze scope and export
On Native sync Pike reads Ajera directly. The export in week one is your archive copy.
- Pick a cutover Friday after your last Ajera invoice run and payroll of the month.
- Export the Timesheet Detail inquiry and the Client Invoice Register report for every year you keep outside Pike.
- List projects on Percent Complete, Unit Price or Percent of Construction Cost billing. You set their type in Pike after the import.
Done when: Archive exports in one folder, a cutover Friday on the calendar, and an Ajera administrator named to create the API user.
Week 1 to 2
Operations lead
Week 1 to 2 · Operations lead
Clean the data in Ajera
Pike imports what Ajera stores, so fix clients, phases and employee emails inside Ajera before you click Import data.
- Merge duplicate clients and mark finished projects inactive.
- Give every Time & Expense project a rate table, and every Percent Complete project contract amounts down to its lowest phase, as Ajera requires.
- Check every active employee has the email they will sign in to Pike with.
Done when: No duplicate clients. Every active project has a billing type, a rate table and phase budgets.
Week 2
Workspace admin, finance
Week 2 · Workspace admin, finance
Build the workspace shell
Ajera includes general ledger and payroll, so decide which accounting system takes over before you build anything else.
- Create teams and workspace roles. Invite admins and project leads only.
- Connect the accounting system that takes over from Ajera and run its Import data, so finance sees ledger customers in Pike.
- Set a cost profile for everyone who logs billable time.
Done when: Admins and leads are in Pike. Finance sees the same client list as Ajera.
Week 2 to 3
Workspace admin
Week 2 to 3 · Workspace admin
Run Import data
One click imports clients, projects, phases, employees, timesheet entries and invoices in dependency order.
- Turn on Read for clients, projects and phases and for timesheet entries, then click Import data. Retry anything listed under Sync issues.
- Set the billing type on every project from the fee-based list you made in week one.
- Open one Time & Expense and one Fixed Fee project and compare phase budgets, rates and last month’s hours with the Ajera Project inquiry.
Done when: Client, project, phase, employee and last-month hour counts match Ajera.
Week 3 to 4
Delivery lead, finance
Week 3 to 4 · Delivery lead, finance
One team in Pike, the rest in Ajera
Turn on Keep syncing and move one team with a live client project and an invoice due.
- The pilot team logs time in Pike only. Everyone else submits Ajera timesheets, and Pike imports those entries every 3 hours.
- Finance approves the pilot team’s time in Time admin and sends one invoice from Pike in place of an Ajera draft invoice.
- Compare the pilot project’s billed amount with the Ajera Billing report for the same period. A gap points to a rate table rate Pike does not match.
Done when: One invoice sent from Pike. Pilot hours in Pike match the same week in Ajera.
Week 4 to 5
Migration owner
Week 4 to 5 · Migration owner
Cutover weekend
Close Ajera timesheets on Friday evening. Finance continues to post in Ajera, so nobody else needs to open it from Monday.
- Friday: everyone submits, supervisors approve the week in Ajera, then an admin clicks Sync now in Pike and turns Keep syncing off.
- Run Reports → Employee → Timesheet Status for the final week to find anyone who has not entered time.
- Monday: everyone logs time in Pike. Pin one message with links to log time, find tasks and ask for help.
Done when: Time admin shows every active member by Monday afternoon. Ajera shows no timesheets after Friday.
Week 5 to 8
Finance
Week 5 to 8 · Finance
First month-end in Pike
Done when finance closes a month without opening Ajera for projects or time.
- Approve all time, invoice every billable project from Pike and send the invoices to accounting.
- Bill any Time & Expense hours from before cutover on a last Ajera invoice, until the Ajera Project inquiry shows no work in progress.
- Ask your Deltek account manager how long you keep access after the contract ends. The Ajera help center lists no retention period.
Done when: Month closed in Pike. Ajera exports saved with two owners. Deltek exit date agreed.
Rebuild
Set these up in Pike by hand
- Percent Complete and Unit Price billingChoose the closest Pike project type and set the budget.Pike docs
- Marketing projectsCreate proposals as deals with value and expected close date.Pike docs
- Overhead projectsTrack overhead costs in Pike finance.Pike docs
- Invoice formatsSet numbering, terms and layout in invoice settings.Pike docs
- Timesheet supervisorsChoose who approves time for each team in Time admin.Pike docs
Questions
Moving from Deltek Ajera: common questions
What access does the Ajera API user need?
Read access to clients, projects and employees, and an active authorizing employee, which Ajera’s timesheet API requires. Pike never writes to Ajera, so leave Can Write off.
How do Ajera phases come across?
Each Ajera phase imports as a Pike phase with its budget, under the matching project. Check phase budgets and hours on two projects against the Ajera Project inquiry after the import.
Our projects bill Percent Complete. What happens in Pike?
Pike’s project billing types are fixed fee, time and materials and non-billable. Set Percent Complete and Unit Price projects to fixed fee with the contract amount as budget, and invoice progress from Pike.
We run accounting in Ajera too. Does Pike cover that?
No. Pike covers projects, time and invoicing, and imports Ajera invoices as read-only history. Pick the ledger that takes over general ledger and payroll before cutover, and connect it to Pike.
Do the Ajera API and the Excel export include the same time?
The Timesheet Detail export includes only the columns the inquiry shows, one row per line with seven day columns. The Ajera API returns each timesheet with its project entries, daily hours and notes, so Native sync needs no reshaping of day columns.
Deltek Ajera documentation used for this guide
- Deltek Ajera: API reference
- Deltek Ajera: Timesheets API (version 2)
- Deltek Ajera: Projects API (version 2)
- Deltek Ajera: Setting up an API user
- Deltek Ajera: Configuring the API settings
- Deltek Ajera: Timesheet Detail inquiry
- Deltek Ajera: Exporting to Excel
- Deltek Ajera: About billing types
- Deltek Ajera: How Ajera calculates billing amounts
- Deltek Ajera: Client Invoice Register report
- Deltek Ajera: Project inquiry
- Deltek Ajera: Billing report
- Deltek Ajera: Timesheet Status report
Your business runs better on Pike.
ISO 27001
GDPR
SOC 2 Type II
Built to keep sensitive client data secure and private.