Create a model from Salesforce solution

Requirements

  • Data Hub v8 or later

  • Salesforce

Create a new data model

Click New resource > Model.

Select source

In the Select Source step:

  1. Under the Apps (API) section, select Salesforce.

  2. From the source type pop-up, click Deploy on the Salesforce entry tagged Model.

Connect

  1. To set up the connection between Data Hub and Salesforce complete the following fields:

    1. URL - The URL of the Salesforce.com domain you want to connect to.

    2. User Name - Enter the user name of a user with access to the Salesforce instance.

    3. Password - Enter the password for the provided user name.

    4. Password - Enter the password for the provided user name.

  2. Click Test Connection to verify that ZAP Data Hub can connect to the Salesforce database with the credentials provided.

  3. Click Next to continue to the Create Model step.

Create model

  1. To deploy the data model provided by the Solution, complete the following fields:

    1. Model Name - Enter a name for the new data model.

    2. Model Location - Click Browse and select a root directory for data model using the Select Folder pop-up window. New folders can be created by right-clicking on existing folders and selecting New Folder.

    3. Model Server - Select an existing Model Server to use for this Data Model, or select Create new model server… to open a New Model Server tab.

    4. Model Database Name - Enter a name for the data warehouse table to be stored in Microsoft SQL Server. If the Model Database Name is already in use, attempting to create the model will not proceed until the Model Database Name is changed or Ownership of the existing table is changed.

    5. Deploy Analytics - When checked, analytics provided by the Solution are deployed during model creation. When cleared, analytics will not be deployed during module creation and will need to be deployed later from the model task pane.

    6. Modules- Select the pre-packaged modules to be deployed for this data model.

  2. Once the model is configured, click Create Model. The model creation process takes several minutes.

Configure calendars

  1. Select from the four calendars provided:

    Note

    All four calendars start on January 1 by default. This can be changed using the calendar pane.

    1. Calendar YQMD - Calendar: Year, Quarter, Month, Day

    2. Calendar YWD - Calendar: Year, Week, Day

    3. Fiscal YQMD - Calendar: Year, Quarter, Month, Day

    4. Fiscal YWD - Calendar: Year, Week, Day

  2. Click Finish.

In this section: