Creating an Extraction File

Datamart extracts content data directly from the vault, so it is required that the Datamart process has direct access to the server's repository and vault. The server repository path needs to be provided by the user. This can be entered in the user interface or by editing the serverRepositoryPath option in the .stxtract file. Content extraction is optional and can be disabled by clearing the serverRepositoryPath value.

  1. Click Start > Programs > StarTeam > Datamart > Datamart Extractor. The Repository Extractor window displays.
  2. Click New. The Edit Property File dialog box is displayed.
  3. Click the StarTeam tab.
    1. Enter a File Name for the extraction.
    2. Enter the IP address (or host name) of the StarTeam Server that contains the data you want to extract, and the Endpoint for that machine.
    3. Enter your StarTeam Server User Name and Password.
    4. The All Projects check box is selected by default. Click the Browse button to select a subset of projects from which to extract the data.
    5. If only one project is selected, the Views section of the Edit Property File dialog box will be enabled and the All Views check box selected by default. Click the Browse button to select a subset of views from which to extract the data.
    6. If the option to Extract content property data is selected, a valid server repository path needs to be entered.

      This option is provided to extract content data for content properties. If the option is not selected, Datamart will extract only the metadata information as it always does.

  4. Select the StarTeam Database tab.
    1. Select the Database Type.
    2. Enter the Server name or IP address.
    3. Enter the Database name.
    4. Enter your User Name and Password for the database.
  5. Select the Database tab.
    1. Select the Database Type.
    2. Enter the Server name or IP address.
    3. Enter the Database name.
    4. Enter your User Name and Password for the database.
    5. Check the Update option to set the Extractor to update mode. Update mode only updates the data for any changes since the last extract. The alternative is full extract mode, in which all tables are removed, recreated and filled. Update mode is much faster.
    6. Check the Continuous option to set the default refresh interval to the default of five minutes. This value can be modified as scheduledRefreshInterval in the .stxtract file. The continuous data extraction mode provides near real-time data reporting. This feature requires an MPX-enabled server for optimal performance. With this option, Datamart will run as a continuous process listening to events on the views/projects that have been selected for extraction and only queries the database when there is an update of interest on the server.
  6. Select the Tables tab.
    1. Select the tables you want to include in the extraction file. You can select them individually, use the Shift key to select a range of groups, or the Ctrl key to select additional groups. Some tables are contingent upon others.
      Note: Labels and links take the most time to extract.
    2. Click the Add button, or click the Add All to add all of the tables.
    3. Click OK. The data is stored in a file at C:/Program Files/Micro Focus/Datamart (or wherever you installed Datamart) with the extension .stxtract that contains the extraction information.