Follow

Uploading Data Using the Data Hub

DemandCaster receives the data necessary to run an analysis in one of two ways.

  1. Automated Data Upload: This is an automated process done via the DataHub. The article below describes how a data upload may be initiated on demand.
  2. Manual Data Upload: This is a manual data upload process as described in the Manual Upload article.

The automated data upload process is an ETL (extract, transform, and load) process that is included with all DemandCaster licenses. This process automates and simplifies the data upload process by preparing and loading SQL queries via the data hub.

The queries will pull data from the client database using the installed data connector and will transform the data in the required format.

The Data Hub will only appear if you are authorized to run a data extract and the Data Hub is set up in your profile.

Click on Data Hub within the LHS menu

  1. Click on Data in top menu
  2. Click on Data Hub in the second level menu
Click on Data Hub within the LHS menu

You are now in the Data Hub

  1. Click on ETL in the upper menu bar
  2. Click on  Data Management in the second level menu
You are now in the Data Hub

Select the ETL to Run

  1. Identify the appropriate extraction template. Most often it is named “All Data”.
  2. Click "Run" to trigger the data extraction process.
Select the ETL to Run

Return to DemandCaster

  1. Click on the gear
  2. Click on “Back to Admin” to go back to DemandCaster while the extraction is running.
Return to DemandCaster

Check Progress

  1. Click on Data in the top menu group
  2. Click “Data Upload” in the second level menu
  3. You should see the process running as the extraction and transformation steps are progressing. When it loads, you will see the progress of each table as shown in the second image below.
  4. Once complete, the data will show up in the “Data Upload” interface with the date and time it was run and "Yes" in the completed column per the third image.
Check Progress

Reviewing Upload Files for Errors

Follow the steps described in the article: Reviewing Upload File for Errors

Reviewing Upload Files for Errors
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk