How to Select Transaction Properties for Import

  • Article

You use the TransDimension and TransCategory tables in the transactions database to select which transaction properties are imported into the Data Warehouse during the Transaction data import Data Transformation Services (DTS) task.

To copy data from a new orders runtime table or view to the Data Warehouse

  1. Open SQL Server Enterprise Manager, SQL Server Management Studio, or SQL Server Management Studio Express.

  2. Expand the transactions database.

  3. Open the TransCategory table.

  4. Add a new row to the table, and provide the following values for the columns.

    Column name

    Entry

    CategoryName

    The name of the Data Warehouse class to create.

    TableName

    The name of the table or view in the transactions database.

  5. Click ! to save your changes.

To export new columns from an orders runtime table or view

  1. Open SQL Server Enterprise Manager, SQL Server Management Studio, or SQL Server Management Studio Express.

  2. Expand the transactions database.

  3. Open the TransDimension table.

  4. Add a new row to the table, and provide the following values for the columns.

    Column name

    Entry

    DimensionName

    The name of the column in the Data Warehouse.

    FieldName

    The name of the column in the Commerce Server 2009 runtime table or view. This name must match a value in the TableName column in the TransCategory table.

    CategoryName

    The name of the Data Warehouse class. This name must match a value in the CategoryName column in the TransCategory table.

    KeyField

    True if the column being exported is a key column; False otherwise. If you are adding data for one of the existing classes, this value should be False.

    RequiredDim

    True if a value for this column must exist in the transactions database; False otherwise.

  5. Click ! to save your changes.

  6. If you extended one of the existing tables in the transactions database, add the new column to the csv_OrderFormHeader, csv_OrderFormLineItems, csv_OrderGroup, and csv_OrderGroupAddress views as needed.

    The next time that the Transaction data import DTS task is run, data that is stored in the tables or columns of the Commerce Server 2009 database is imported to the extended class and column of the Data Warehouse.

See Also

Other Resources

Specifying Data to be Imported into the Data Warehouse

Importing Data into the Data Warehouse

Running the DTS Tasks

Managing the Data Warehouse