Thousands of companies rely on Harvest timekeeping and forecasting to track utilization of resources and manage invoicing and expenses in order to run their businesses. That data is available to you so that your organization can synchronize it to a warehouse for enriching with other datasets or integrating it with other operational systems that allow you to see the full end to end view of your business. DataLakeHouse.io is the best means to do that for your organization consistently and with confidence.
The Harvest account that you are using should be assigned the Administrator role and have access to all Modules. Steps to ensure the Harvest account has access to all Modules.
DataLakeHouse.io securely connects to your Harvest account. Using the form in the DataLakeHouse.io portal please complete the following steps:
- Enter a Name or Alias for this connection, in the 'Name/Alias' field, that is unique from other connectors.
- Enter in the 'Target Schema Prefix' field, a name that will be unique in your cloud warehouse destination database where you wish to replicate the data.
- Click the Authorize Your Account button which will save the connection.
The following Harvest entities are replicated to your target destination. These are the table names you will see:
When the following type of error is seen in the DataLakeHouse.io Logs & Monitoring this is due to the Harvest account not having access to all the necessary Modules.
Resolution: Adjust the Modules in Harvest to match the image below for the user you using to connect to Harvest and run the Sync Bridge.
After you run a Sync Bridge you notice that not all of the desired Harvest data is in your Target connection.
Resolution: Run a Historical Re-sync for the Sync Bridge. This is only needed to be done once after the initial sync.