Integrated Data
Integrated Data Types
By integrating your Vista On-Premise data with Mosaic, you will be able to import the following:
- Employees
- Clients
- Projects
- Phases
- Time Entries
- Bill Rates
As Mosaic works on adding more data points to our integration with Vista On-Premise, this list may change. When a new feature is added to Mosaic, you can expect your Customer Success Manager to reach out requesting access to your server to update your replication.
Integrated Data Fields
Data Sources
| Vista Data Types | Mosaic Data Types |
|---|---|
| Payroll Module → PR Employees - Name | Employee - Name |
| Accounts Receivable → Customer Master - Name | Clients - Title |
| Job Cost → Job Master - Description - Customer - Job - Contract Amount (Current) | Projects - Title - Client - Project Number - Fee |
| Job Cost → Job Phases - Description - Phase - Contract - Total Cost (Current) | Phases - Title - Phase Number - Project Number - Budget |
| Job Cost → Cost Detail - Date - Hours - Job - Phase - Description - Employee | Time Entry - Date - Hours - Project - Phase - Description - Employee |
Mosaic is constantly working on adding more features to our integrations; you can expect additional data points to be added to your integration in the near future!
Please Note:
Mosaic only syncs posted time entries from Vista.
Unsupported Data Sources
- Changing field names in Mosaic to match custom labelling in Vista
- Integrating Data Types that are not explicitly listed in the Vista Integration Documentation
Please Note:
If there is a data endpoint not listed in this documentation and it is required for your integration, it will be a customization, charged at an hourly rate.
Extended Data Fields
Replicated Data
Mosaic replicates a subset of the data tables that are available in Vista On-Premise. The following tables will be included in your replication:
| Table Name | Use in Mosaic |
|---|---|
| JCJM | Project integration |
| JCCM | Project integration |
| JCJP | Phase integration |
| JCCP | Phase integration |
| JCCD | Time Entry integration |
| ARCM | Client integration |
| PREH | Employee integration |
| JCRD | Bill Rate integration* |
| JCRT | Bill Rate integration* |
*Data Import for Bill Rate Integration:
The tables used in Bill Rate integration (JCRD and JCRT) do not have a primary key in the Vista database. This means the data must be exported and provided to Mosaic for manual import into the database. This process will need to be repeated each time you want to refresh the data.
Alternatively, you can add a Primary Key to these table or replicate this table with a Primary Key following these instructions.
For more information on what these tables contain, you can reference the Vista by Viewpoint Product Help documentation.
Unsupported Data Sources
- Changing field names in Mosaic to match custom labels in your ERP.
- Integrating data types that aren’t listed in the integration documentation.
Customizations:
If you need a data source or endpoint that isn’t listed in the documentation, it will be considered a customization and charged at an hourly rate.
Updated about 1 month ago