Datamart Extractor reads an extraction file to initialize. The file details the connection and login parameters for the database and StarTeam Server . It also has the list of tables to extract, the project and view to extract, and an update option.
You can place information from multiple servers into one database by defining multiple extraction properties files. You do not need to create a new database for each properties file.
With Microsoft SQL Server, Datamart creates additional tables when Microsoft SQL Server is in danger of exceeding the row size limit (8060 bytes), because of the number and size of custom fields and item types. The additional tables contain the same primary key as the main table and any additional fields. Reports will require you to join the tables before performing other operations on them.
When a table is created, it includes all existing custom fields for that type. However, if a custom field is created after the utility is running in update mode, the new custom field is skipped.
If you requested specific access rights within a type, and want to extract the container access rights for a particular item type, you must request that item type as well.
It is recommended that a StarTeam Server user with full access rights to all StarTeam Server items run Datamart Extractor. If there are access rights limitations, the data extracted reflects only what the user has access to.
When launched, the Datamart Extractor displays a dialog box that enables you to run, to edit, or to remove a property file, to purge the database contents for the selected property file, and to refresh the list of files displayed.
Datamart Extractor also has an update mode. In this mode, the data from previous extractions is not refreshed. The tool compares what is in the existing database with what is in StarTeam Server and makes changes only when there are differences. If the extraction is stopped before reaching the end, the next time you run the extraction file, it will resume from where it stopped.