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

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

Click Add New to open the Extractions form

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 [email protected]

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

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

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