Follow

Adding SQL Queries to Data Hub

Upon installing the data connector, you may enter your extraction queries in the DemandCaster data hub by following the steps outlined below.

Open the Data Hub View

  1. Click on Data in main menu
  2. Click on Data Hub in sub-menu

Open ETL Extractions

  1. Click on ETL in main menu
  2. Click on Extraction in sub-menu

Add New Extractions

Click Add New to open the Extractions form

Enter Your SQL Extractions

These steps will be repeated for each data set being extracted from your database per the DemandCaster Data Table Requirements documents previously sent. If for some reason, you do not have these documents, please let us know by emailing support@demandcaster.com

  1. Extraction Type will be Connector unless the data is being pulled from FTP or other method.
  2. Query Connector will be the Connector that was created during the Installing the Data Connector step. The connector should pre-populate or can be added via the drop down.
  3. Enter the name of the query. This can be any descriptive name you choose
  4. Enter a description as needed. This is optional.
  5. Enter the SQL Query
  6. Enter the file name - The name must follow the naming provided in the DemandCaster Data Table Requirements documents.
  7. Click Save to save the query

Repeat steps to add next query

Let Us Know

Once your queries are entered, please notify support by emailing support@demandcaster.com so we can proceed with the transformation and load steps. These steps are not currently available to end-users.

Return to DemandCaster

Click on the Gear icon at the top right hand side of DemandCaster and then click on Back to Admin to return to DemandCaster

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk