The Publish Model job entry allows you to publish the data source created with the Build Model job entry available for use on the BA Server. Before publishing the model, you will have the option of sharing the data model with everyone, or a specific user or role.
You must have an existing BA Server and permissions to Publish Content and Manage Data Sources in the BA Server in order to use this job entry.
This job entry requires that the Build Model entry comes before it in Spoon, as shown here in this example.
After publishing, the Data Source Wizard data source created in the BA Server will be named the same as the model in the Build Model job entry. Once it is published, you won't be able to use the Data Source Wizard to edit the connection information for the model, because the editing source in the Data Source Model Editor is disabled.
Using the Publish Model Job Entry
This section describes how to set up the Publish Model job entry.
- Locate the Publish Model entry from the Design pane in PDI.
- Drag and drop the Publish Model icon onto the transformation canvas.
- Double-click the Publish Model icon to open the dialog box.
- Fill out the information in the dialog box:
- Entry Name - type a name for your entry in this field.
- Replace Existing Published Model - select if you want to replace an already-existing model.
- Enter the URL for the BA Server.
- Enter the User Name and Password for the BA Server.
- Click the Test Connection button.
- Choose who to Grant Access To: Everyone, User, or Role.
- If needed, you can enter a specific user or role name.
- Click OK to continue or Cancel to close the dialog box
This is an example of the Publish Model dialog box, along with a table that has more details about each field.
|Entry Name||Use this field to name the Publish Model entry.|
|Replace Existing Published Model||Select this to overwrite an existing Data Source Wizard data source and database connection. If disabled, and you attempt to publish a model with the same name, the Publish Data Source job entry will fail.|
|URL||Enter the URL to the BA Server.|
|User Name||Type the user name for the BA Server.|
|Password||Enter the password.|
|Test Connection||Click to test the connection to the BA Server. This button also checks user permissions |
to Publish Content and Manage Data Sources.
|Grant Access To||Grant access to the data model to everyone, specific user(s), or specific role(s). |
The permission granted is Read Only. If access is granted to Everyone, the User/Role Name field is disabled.
Note: If you are using variables to populate this field, the variable can contain one of three values: everyone, user, or role. These values MUST be lower-case.
|User/Role Name||Enter the name of the User or Role that you want to grant access to.|
|Help||Provides a link to the Help documentation.|
|OK||Click OK to save.|
|Cancel||Click Cancel to close the window.|